Home » RDBMS Server » Backup & Recovery » ORA-19901 After restore (Oracle EE Solaris 5.9 SPARC)
ORA-19901 After restore [message #355904] Tue, 28 October 2008 07:20 Go to next message
Messages: 1
Registered: October 2008
Junior Member

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.
Re: ORA-19901 After restore [message #356718 is a reply to message #355904] Sat, 01 November 2008 06:53 Go to previous message
Messages: 38
Registered: July 2007

hello Andre.

pls post your output here,use below command..

rman>list incarnation of database 'database name';

rman>list incarnation of database prod1;

Previous Topic: RMAN - script
Next Topic: restore RMAN FROM TAPE
Goto Forum:

Current Time: Sun Aug 20 06:55:50 CDT 2017

Total time taken to generate the page: 0.14821 seconds