Home » RDBMS Server » Backup & Recovery » archive logs directory (FRA) accidentally deleted (Oracle 10g 10.2.0.5, RHEL 6.2)
archive logs directory (FRA) accidentally deleted [message #668795] Wed, 14 March 2018 22:46 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day.

One of our SysAdm accidentally formatted (Mar. 13 6PM) the flash_recovery_area directory of our production database.
According to him, the command (creation/expansion of mountpoints) he accidentally executed will lose all existing archived logs once the database server is restarted.

We immediately implemented an adhoc RMAN full backup (Mar. 14, 4PM, completed on Mar. 15, 12AM - 1.7TB size)
while he (SysAdm) backup continuously all the files in the said FRA to another directory.
We're also scheduling a database restart this afternoon at 5PM, where we will create/point the FRA to another directory.

Are the archived logs generated from 6PM of Mar. 13 up to 5PM today still restorable/recoverable?
Or said archived logs are considered "corrupted" already?

Thank you in advance.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: RMAN pushing same backups again and again to tape causing TSM running out of space
Next Topic: ORA-27072: File I/O error for sysaux.dbf, more logfiles than expected
Goto Forum:
  


Current Time: Fri Apr 19 20:07:22 CDT 2024