Home » RDBMS Server » Backup & Recovery » NORESETLOGS when restoring from cold backup (, Linux SLES 9)
NORESETLOGS when restoring from cold backup [message #282815] Fri, 23 November 2007 15:39 Go to next message
Messages: 3
Registered: November 2007
Junior Member
Oracle version:
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 ?

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 Oct 22 01:12:05 CDT 2016

Total time taken to generate the page: 0.23694 seconds