| NORESETLOGS when restoring from cold backup [message #282815] |
Fri, 23 November 2007 15:39  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
