On Friday, I discovered that my standby database had not applied transactions for 8 days. This is very bad for me because I only keep 7 days worth of archived redo logs. So I had no redo to apply. I used the steps in Note 836986.1 to roll forward my standby with an RMAN incremental backup. The steps in the document worked very well for me. My primary generated about 700GB of redo during this 8 day period, but the RMAN incremental backup was about 285GB in total size. It took me about 24 hours to create the backup since RMAN had to read my entire 14TB database, block by block. Recovering the standby from this backup took about 8 hours. Not too bad.
After the restore, I did get some errors about my SRLs that needed clearing. My alert log showed:
SRL log 7 needs clearing because log has not been created SRL log 8 needs clearing because log has not been created SRL log 9 needs clearing because log has not been created SRL log 10 needs clearing because log has not been created SRL log 11 needs clearing because log has not been created
This was easily handled with:
Every medicine can be bought both from the offline and online buy levitra online markets at extremely affordable prices. Online pharmacies offer genuine and branded medicines at affordable prices and the medicine viagra sale buy is clinically tested and approved for daily consumption. Applicants can buy Tadalafil 20mg after they check the report. online prescription for viagra These internet distributors offer the pills in strength levels of 100 mg per cheapest online viagra pill.
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database clear logfile group 7;
Database altered.
SQL> alter database clear logfile group 8;
Database altered.
SQL> alter database clear logfile group 9;
Database altered.
SQL> alter database clear logfile group 10;
Database altered.
SQL> alter database clear logfile group 11;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
