Home » RDBMS Server » Backup & Recovery » help me with restore problem..
help me with restore problem.. [message #266528] Tue, 11 September 2007 01:49 Go to next message
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>
Re: help me with restore problem.. [message #266545 is a reply to message #266528] Tue, 11 September 2007 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Provide what Oracle asks for or the online redo logs if archived never existed.

Regards
Michel
Re: help me with restore problem.. [message #266550 is a reply to message #266528] Tue, 11 September 2007 02:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

after using recover database using backup controlfile;
provide redo.
Re: help me with restore problem.. [message #266581 is a reply to message #266550] Tue, 11 September 2007 03:06 Go to previous messageGo to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
hello

freind I hve applied all the redo i hav , now i want to start the db with that only. mean till this redo logs only

please help
Re: help me with restore problem.. [message #266597 is a reply to message #266581] Tue, 11 September 2007 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter database open?

Regards
Michel
Re: help me with restore problem.. [message #266911 is a reply to message #266528] Wed, 12 September 2007 00:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Try with below command.
SQL> set autorecovery on
SQL> recover database using backup controlfile UNTIL CANCEL;
SQL> alter database open resetlogs;


If your problem similar like below link.
http://dbataj.blogspot.com/2007/09/clone-db-on-new-host-with-hotbkp.html

Regards
Mohammed Taj
Previous Topic: how can i use BAK and TRN files
Next Topic: ORA-01180: can not create SYSTEM datafile
Goto Forum:
  


Current Time: Sat Dec 03 12:15:20 CST 2016

Total time taken to generate the page: 0.04004 seconds