Home » RDBMS Server » Backup & Recovery » ORA-01589: must use RESETLOGS or NORESETLOGS option for database (Windows XP 10g 10.0.2.0.1)
ORA-01589: must use RESETLOGS or NORESETLOGS option for database [message #453030] Mon, 26 April 2010 15:05 Go to next message
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
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] [] []

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 Go to previous message
Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

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


Current Time: Sun Sep 24 06:22:14 CDT 2023