OraFAQ Forum: Backup & Recovery » ORA-01589: must use RESETLOGS or NORESETLOGS option for database

Home » RDBMS Server » Backup & Recovery » ORA-01589: must use RESETLOGS or NORESETLOGS option for database (Windows XP 10g 10.0.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01589: must use RESETLOGS or NORESETLOGS option for database [message #453030]

Mon, 26 April 2010 15:05

keekee
Messages: 19
Registered: April 2010

Junior Member

I have windows XP.
C:\oracle\product\10.2.0\db_1\orcl\usr>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 26 15:32:06 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available

SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 184552324 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> select count(*) from v$instance;

COUNT(*)
1

Report message to a moderator

Re: ORA-01589: must use RESETLOGS or NORESETLOGS option for database [message #453031 is a reply to message #453030]

Mon, 26 April 2010 15:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

I hope you have good backup.

01589, 00000, "must use RESETLOGS or NORESETLOGS option for database open"
// *Cause:  Either incomplete or backup control file recovery has been
//          performed. After these types of recovery you must specify either
//          the RESETLOGS option or the NORESETLOGS option to open your
//          database.
// *Action: Specify the appropriate option.

Report message to a moderator

Re: ORA-01589: must use RESETLOGS or NORESETLOGS option for database [message #453078 is a reply to message #453031]

Tue, 27 April 2010 02:05

keekee
Messages: 19
Registered: April 2010

Junior Member

I have windows XP and use Oracle 10g 10.2.0.1.0

Would you please let me know how to check
incomplete or backup control file recovery is performed.
And how to specify the appropriate option.
This is the first time I do rman duplicate backup.
Please help.

And got errors as below:

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/26/2010 16:07:20
RMAN-03015: error occurred in stored script Memory Script
RMAN-00600: internal error, arguments [7002] [0] [9314] [] []

Report message to a moderator

Re: ORA-01589: must use RESETLOGS or NORESETLOGS option for database [message #453080 is a reply to message #453078]

Tue, 27 April 2010 02:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RMAN-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Report message to a moderator

Previous Topic:	ASM issue during RMAN backkup
Next Topic:	asm

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 04:28:22 CST 2025