Home » RDBMS Server » Backup & Recovery » Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESETLOG? (Oracle 11 gR2, OEL5.6)
Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESETLOG? [message #544851] Fri, 24 February 2012 04:51 Go to next message
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 #544853 is a reply to message #544851] Fri, 24 February 2012 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
As my redo is intact, it is not incomplete recovery and, I do not want to generate new incarnation of my database.


So use NORESETLOGS.

Regards
Michel
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #544865 is a reply to message #544853] Fri, 24 February 2012 06:06 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Agreed!
But, if at all it wants me to give option, I am going to use NORESETLOGS in my case.
But, I am confused as to why Oracle wants us to specify an option in the first place? Why it can not do 'alter database open'?

Thanks & Regards,
Swaorclser
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #544872 is a reply to message #544865] Fri, 24 February 2012 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you base is in NOARCHIVELOG mode, so the option is mandatory.

Regards
Michel
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545033 is a reply to message #544872] Sun, 26 February 2012 22:34 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello Michel,

Thanks for your reply.
But, my observation is , we can fire "alter database open"
in Oracle 10 g without specifying any resetlog option in case of NOARCHIVELOG database.

Also, in Oracle 11g R2, we see

Quote:
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


My database is in NOARCHIVELOG mode still it says archived log....
??

Thanks a lot in advance!!

Regards,
swaorclser.
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545037 is a reply to message #545033] Sun, 26 February 2012 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My database is in NOARCHIVELOG mode still it says archived log


Post an evidence it is in NOARCHIVELOG, do not just tell us SHOW us (see OraFAQ Forum Guide).

Also did you use a backup of the control file to restore or the current one?

Regards
Michel

[Updated on: Sun, 26 February 2012 23:20]

Report message to a moderator

Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545083 is a reply to message #545037] Mon, 27 February 2012 03:03 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Here is the evidence that shows DB is in NOARCHIVELOG.
I fired,

SQL> select name, log_mode from v$database;

NAME      LOG_MODE
--------- ------------
ORCL      NOARCHIVELOG



I used current to restore.

Thanks & Regards,
swaorclser
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545085 is a reply to message #545083] Mon, 27 February 2012 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure that "=/u01/app/oracle/oradata/PROD/redo02.log" is an archived log and not an online one?

Regards
Michel
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545114 is a reply to message #545085] Mon, 27 February 2012 05:48 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello

Quote:
Are you sure that "=/u01/app/oracle/oradata/PROD/redo02.log" is an archived log and not an online one?

This is indeed an online REDO log.
I understand that completely, my question was why Oracle is calling it an Archived Log, when that is still online redo.
Database being in NOARCHIVELOG, there will be no ARCH processes to archive these redos at all.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545214 is a reply to message #545117] Mon, 27 February 2012 22:53 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello Michel,

Thanks for your kind reply and explanation.
So to conclude this thread,if
1) Your database is in NOARCHIVELOG
2) You are doing recovery.

You must specify RESETLOG or NORESETLOG depending on the situation.
For Oracle 11g R2.

Regards,
Swati Pathak.

Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545216 is a reply to message #545214] Mon, 27 February 2012 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65832
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, if you have to restore and recover in MOUNT mode a mandatory file/tablespace (like SYSTEM).
It is not needed for the other datafile/tablespace you can restore/recover in OPEN mode.

Regards
Michel
Re: Oracle11gR2 not allow to open database after complete recovery, asks to specify RESETLOG/NORESET [message #545224 is a reply to message #545216] Tue, 28 February 2012 00:33 Go to previous message
swaorclser
Messages: 56
Registered: August 2011
Member
Yes.
I need to do a Database restore and recovery in MOUNT mode.
As, I need to restore and recover whole DB, it will include SYSTEMS
tablespace always.
So, I will need to say NORESETLOGS while opening the DB after recovery, as my redo was intact, am doing complete recovery and I dont want to generate a new DB incarnation.

Thanks a lot!

Regards,
Swaorclser
Previous Topic: RMAN Duplicate set until time using wrong backup piece name to restore.
Next Topic: 10g Recovery on a different Server
Goto Forum:
  


Current Time: Mon Oct 15 16:04:36 CDT 2018