Printable View
so what if I resynced my recovery catalog at
10:00AM and there has been high transaction after that.
I'm automatically archiving. And the database crashes at 2:00PM
Would I be able to recover everything uptill the time
the database crashed or I would only be able
to recover up to the last time the recovery catalog was
resynced?
run {
allocate channel ch1 type disk;
backup database
format '/oracle/storage/backup%U';
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
sql 'ALTER SYSTEM ARCHIVE LOG ALL';
}
If you don't specify the until option rman would recover your database to the point of failure, this includes that of applying the archive logs from the backupset and also the ones from the disk.
Sam
To answer your question :
I will be able to recover as long as you have all archived logs available between 10 a.m. and 2 p.m in addition to whatever archives are required to bring database up to 10 a.m.
Am I coming across with my point?
Thanks to all of you. Your help has been very helpful
A better way to handle this is to setup a cron job that will resync the catalog frequently - I do mine every hour.