Home » RDBMS Server » Backup & Recovery » NORESETLOGS when restoring from cold backup (10.2.0.3, Linux SLES 9)
NORESETLOGS when restoring from cold backup [message #282815] Fri, 23 November 2007 15:39 Go to next message
lybc
Messages: 3
Registered: November 2007
Junior Member
Oracle version: 10.2.0.3
Database is in NOARCHIVELOG mode, using spfile
RMAN is configured controlfile autobackup on;

I want to restore from a cold backup. The backup was taken when the database was in NOARCHIVELOG mode. My controlfile is on autobackup. Here is my backup and restore script

======================================================
run {
allocate channel t1 device type disk;
backup database;
release channel t1;
}
======================================================
rman> startup nomount;
run {
allocate channel t1 device type disk;
restore controlfile from autobackup;
alter database mount;
restore database;
release channel t1;
}

Afterwards i try to open db.

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 NORESETLOGS;
alter database open NORESETLOGS
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


Opening with RESETLOGS is not a problem but I do not want multiple incarnations of the database because this restore will be run nightly as a scheduled job.

Is there a way i can open the database using NORESETLOGS ?

Thanks.
Re: NORESETLOGS when restoring from cold backup [message #282826 is a reply to message #282815] Fri, 23 November 2007 22:53 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

try with below command.
recover database using backup controlfile until cancel;

when prompt enter: CANCEL;
Previous Topic: Problem after moving server
Next Topic: tape backup- help required pls
Goto Forum:
  


Current Time: Sat Dec 10 12:49:51 CST 2016

Total time taken to generate the page: 0.29559 seconds