Title: RE: rman restore & arclogs
Lisa,
I
believe Oracle tries to restore the most recent version of the archivelogs,
according to the timestamp in the catalog. But if that's corrupted or not
found for whatever reason, you can get it from the other
backupset.
Jim
P.S. Sorry for the v
Lisa,
We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs. We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.
Have a look at rman's tables and views. You should be able to query
Title: rman restore & arclogs
Lisa,
I
guess I'm lazy (or cautious) in that I would allow the first backup to take this
archive log files back to tape where they belong, rather than determine (by
running reports) which log files I may delete (by hand).
The
cautious part of me says that if
Title: RE: rman restore arclogs
Thanks Tom. I did try removing the arclogs and then running a backup - no complaints. The arclogs in question were still present in the catalog via past backups. I'm guessing this is because the last scn of the last backup was larger than the scn's included
ple recipients of list ORACLE-LSubject:
RE: rman restore arclogs
Lisa,
I
guess I'm lazy (or cautious) in that I would allow the first backup to take
this archive log files back to tape where they belong, rather than determine
(by running reports) which log files I may dele
Title: RE: rman restore arclogs
Interesting. Does rman ever get confused during a restore or does it just grab the most convenient backup set with the required archive logs on it? I don't suppose you can parallel restore your arclogs from different files/tapes? (There goes that monkey again
We have a slightly differnt apprach for this ..
1.
cp arch files to arch history location (stage 2 days
worth achives on disk. there is a cron that fires
everday and deletes all files from hostory arch
location which are two or more days older)
2.there is a script that invokes rman to backup
cc:
Sent by:Subject: RE: rman restore arclogs
[EMAIL PROTECTED