Isn't it obvious?
Printable View
Isn't it obvious?
Very obvious :-)Quote:
Originally posted by jmodic
Isn't it obvious?
Thanks for your responses. I just got back from a 4day vacation. Am yet to assimilate what you guys said completely. Will respond later in the day. Inbox is flooded..and have a few fires to put off.
PS : Why did I even bother taking a vacation..@#$$#!!
PPS: Just looked at the responses briefly again..I don't understand, how I would be able to extract the newly backed up archivelogs with an old controlfile? Note: the archivelogs were backed up using RMAN.
Julian,
Para 1 - Machine bombed. There are NO archivelogs on disk. All that I have to go by are the hourly RMAN archivelog backups, that are now on tape.Quote:
OK: if the control file is old, you restore and roll forward to the last archive you have on disk. Even if the control file has no entries of this "new archives" created after the backups, it will allow you to roll past this point. "Recover using backup controlfile".
If you have all the archivelogs on tape, you can restore them to disk, "catalog" them and you will be able to recover.
Para 2 - Again, the archivelogs were backed using the RMAN catalog. So it's not easy restoring them, since the catalog itself crashed. So no question of recovering them and re"catalog"ing them.
Hrishy,
Yes. But RMAN does NOT include controlfiles when you backup archivelogs. So your code is not applicable. I'll end up with an old controlfile.Quote:
The reason being RMAN always includes the control file in a backup operation that includes file 1 (system data file),regardless of the autobackup setting
so u will be able to recover completely in your case.
Julian - How does your second piece of code/post help the cause?
Thanks for your responses.
Hi
You mention
The target was backed up at 8am this morning
i will use this backupset to extract the controlfile using the script posted above.Once i have the controlfile extracted i can use that controlfile mount the database and ask rman to rollforward the database by applying the archived redo logs.
I hope i am able to clear your doubts.In case you still have trouble i suggest a booj oracle RMAN backup and recovery guide by Robert Freeman it covers some of the scenarios like this
regards
Hrishy
Julian/Hrishy - my fault. Didn't notice the "backup" controlfile bit. I'll have to try it with RMAN. Doesn't seem readily documented in the user guide. Lemme search again..
OK; do it in two steps, extract the controlfile via PL/SQL and them roll forward with RMAN.Quote:
Originally posted by Axr2
Julian/Hrishy - my fault. Didn't notice the "backup" controlfile bit. I'll have to try it with RMAN. Doesn't seem readily documented in the user guide. Lemme search again..