| ORA-19901 After restore [message #355904] |
Tue, 28 October 2008 07:20  |
dae01
Messages: 1
Registered: October 2008
|
Junior Member |
|
|
Hi,
I am trying to restore my database to its state 3 years ago. I have got tapes with level0 backup (includes datafiles, controlfile and archived logs). Using RMAN I restored all of the datafiles and archived logs.
As I did not have redo logs from the time I just put files from my current state (thinking that they are not really required as I am going to do a RESETLOGS anyway).
After RMAN successfully restored datafiles and archived logs I issued:
recover database using backup controlfile until cancel;
command in SQLPlus.
However after all of the archived logs were applied I have got warning that OPEN RESETLOGS is going to fail with ORA-19901.
Which it indeed fail. They only solution I have found is to continue media recovery, but I do not have anymore archived logs left and also when I query v$recover_file it shows that all datafiles change# is the same.
The only abnormality I can see is that when I query v$database it shows last system change LESS than the one for all datafiles.
Please advise what I should do.
Thank you.
Andre.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
