Oracle Restore and Recovery
Hello.
Guys I`m pretty new to Oracle and I been trying to restore our backup from Live Database to Our Test Database.
This is what i did.
After installing the Oracle 11g (11.2.0) on our Rhel6 environment, I try to create the folder structure to Test Server same as on Live Server.
After that I "startup nomount pfile='directory'" then created the spfile.
Then I copy the backupset and control file from Live Server to Test Server and restore the control file.
I alter Database to mount mode then go to rman to restore Database.
It all goes well but when I try to recover Database I receive an error.
This is the Error = RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 8929 and starting SCN of 811164225283.
I try to ignore this error and proceed to opening the database;
Alter Database Open resetlogs.
But then again I receive this error.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 8020
Session ID: 3 Serial number: 4461
Can some one please help me on how to do this?
I`m really new to oracle and I dont know what to do.