Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESETLOG? [message #544851] |
Fri, 24 February 2012 04:51 |
|
swaorclser
Messages: 56 Registered: August 2011
|
Member |
|
|
Hello All,
I have a little problem here.
My database is in NOARCHIVELOG mode.I took whole DB backup ( cold).
Then just after half an hour I ran following script.
RMAN> RUN { RESTORE DATABASE;RECOVER DATABASE;alter database open;}
Starting restore at 24-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/PROD/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/PROD/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/PROD/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/PROD/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/PROD/backupset/2012_02_24/
o1_mf_nnndf_TAG20120224T152404_7ngqkwdv_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/PROD/backupset/2012_02_24/
o1_mf_nnndf_TAG20120224T152404_7ngqkwdv_.bkp tag=TAG20120224T152404
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 24-FEB-12
Starting recover at 24-FEB-12
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 2 is already on disk as file
/u01/app/oracle/oradata/PROD/redo02.log
archived log file name=/u01/app/oracle/oradata/PROD/redo02.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:01
Finished recover at 24-FEB-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/24/2012 16:04:08
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN>
Why do I need to specify an option at the first place?
As my redo is intact, it is not incomplete recovery and, I do not want to generate new incarnation of my database.
Why oracle simply not opening my database?
Thanks in advance.
Regards,
swaorclser
[Updated on: Mon, 27 February 2012 03:24] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545117 is a reply to message #545114] |
Mon, 27 February 2012 05:56 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Well, it abuses of term "archived", it can apply archived and online redo logs, they are not different for it, most of the time it is archived logs, so they (Oracle developers) do not want to check if it is actually an archived or rather an online log to display the message, so it always displays "archived".
If I'd develop it, I'd only say "log" without any adjective to prevent from this kind of misunderstanding.
Regards
Michel
|
|
|
|
|
|