| archive logs directory (FRA) accidentally deleted [message #668795] |
Wed, 14 March 2018 22:46  |
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.
|
|
|
|
|
|
| Re: archive logs directory (FRA) accidentally deleted [message #668797 is a reply to message #668796] |
Thu, 15 March 2018 00:34  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Sir, thank you for your prompt reply.
As I'd list the archived logs using RMAN (LIST BACKUP OF ARCHIVELOG ALL;),
it shows that all archived logs dated from Feb. 2 up to Mar. 14, 10:31PM were already backed-up.
But, when I execute this command: "select sequence#, first_time, next_time, applied, archived from v$archived_log"
there were still 27,840 archived logs (dated Feb. 2 to Mar. 15, 2018) that have not been applied (APPLIED=NO).
What would be our next steps? Can we forcibly apply those still "unapplied" archived logs?
Thanks again.
|
|
|
|
| Re: archive logs directory (FRA) accidentally deleted [message #668798 is a reply to message #668795] |
Thu, 15 March 2018 01:36 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
We are you re-starting the database? There is no need to do that just to change the location of the FRA. This all seems rather a fuss about nothing. All you need do is change your db_recovery_file_dest and then:
{backup database plus archivelog;
crosscheck backip;
crosscheck archivelog all;
delete expired backup;
delete expired archivelog all;} |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
