oracle recovery scenarios
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 7 Feb 2009 15:27:04 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
