| help me with restore problem.. [message #266528] |
Tue, 11 September 2007 01:49  |
aboodlardy
Messages: 80
Registered: November 2006
Location: India
|
Member |
|
|
hello friends
I took the offline backup of my live db, and restore with all files in my test
db it given me that controlfile is older than file 1.
I took "alter database backup controlfile to " this copy and restore in test.
But now it gives me this error please help.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\TAEF\SYSTEM01.DBF'
SQL> recover database using backup controlfile;
ORA-00279: change 86270157 generated at 09/11/2007 08:29:34 needed for thread 1
ORA-00289: suggestion :
E:\ORACLE\PRODUCT\10.1.0\ARCHIVELOG\ARC28789_0563426554.001
ORA-00280: change 86270157 for thread 1 is in sequence #28789
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.1.0\ORADATA\TAEF\SYSTEM01.DBF'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
