Re: oracle recovery scenarios
Date: Sun, 8 Feb 2009 12:58:12 +0000
I've been asked to write a 'recovery manual' So if on holiday our developers can recover the database. If I could I would publish it!
Anyway you can add corruption sub heading - with corrupt dbf , redo , temp as subs of that.
My books growing isnt it!
2009/2/7 Dba DBA <oracledbaquestions_at_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
> 1. full recovery(with and without archivelog mode)
> 2. point in time recovery
> 3. flashback database
> 4. lost a redo log(both online and offline, with multiple redo log
> groups or without)
> 5. lost a datafile
> 6. restore control file
> 7. restore spfile
> 8. someone drops a table, so flash back table
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 08 2009 - 06:58:12 CST