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
allocate channel ch1 type disk;
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.
Life is a journey, not a destination!
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?
One, who thinks that the other one who thinks that know and does not know, does not know either!
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.
Click Here to Expand Forum to Full Width