oracle recovery scenarios
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Sat, 7 Feb 2009 15:27:04 -0500
Message-ID: <f30139790902071227l2b2db652s192f1bcb277d5392_at_mail.gmail.com>
I don't do alot of recoveries, so when I need to do something, I always end up googling it. So I want to write myself some notes for some of the basic scenarios. Here is my list so far. I keep notes of activities I don't use very often. So I don't have to look them up again.
Date: Sat, 7 Feb 2009 15:27:04 -0500
Message-ID: <f30139790902071227l2b2db652s192f1bcb277d5392_at_mail.gmail.com>
I don't do alot of recoveries, so when I need to do something, I always end up googling it. So I want to write myself some notes for some of the basic scenarios. Here is my list so far. I keep notes of activities I don't use very often. So I don't have to look them up again.
all of these assume I can use RMAN
- full recovery(with and without archivelog mode)
- point in time recovery
- flashback database
- lost a redo log(both online and offline, with multiple redo log groups or without)
- lost a datafile
- restore control file
- restore spfile
- someone drops a table, so flash back table -- http://www.freelists.org/webpage/oracle-l