| Incomplete RMAN recovery [message #164304] |
Wed, 22 March 2006 20:18  |
ashley75
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Hi all,
there are three ways to do INCOMPLETE recovery,
1. till time that the DB was crashed
2. SCN
3. sequence.
for SCN and Sequence, how can you find out the last SCN or sequence before the database crashed????
can somone please give me some instructions???
thanks
|
|
|
|
|
|
| Re: Incomplete RMAN recovery [message #164463 is a reply to message #164304] |
Thu, 23 March 2006 09:34  |
alanm
Messages: 284
Registered: March 2005
|
Senior Member |
|
|
hi,
look in your alert log file for the database. you should see lines something like the following
Thu Mar 23 16:36:04 2006
ARC0: Beginning to archive log# 6 seq# 162666
ARC0: Completed archiving log# 6 seq# 162666
look for a sequence number before the DB crash.
regards
Alan.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
