Oracle Restore

Posted on 2006-04-04
Last Modified: 2012-05-05
Our SAP Production environment is a clustered environment:
BSRPR3100 - Windows Cluster
BSRPR3101 - Node IP
BSRPR3102 - Node IP (oracle is installed here)
BSRPR3200 - Oracle Cluster
BSRPR3300 - SAP Cluster
When you shutdown (place offline) and restart (place online) the database in a clustered environment you have to use ORACLE FAIL SAFE MANAGER.
When I ran the restore I ran it from BSRPR3102. The brrestore -d util_file -b last -m full -c force completed successfully.
 I received this oracle error:
ORA-01589 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.

When you restore the control files and one or more database files or in my case restore the entire database I would need to open the database with resetlogs, which puts the database back to how it existed as of the restore:

My question is: If the database is already shutdown and the only way to open the database is to use ORACLE FAIL SAFE MANAGER were do you enter


I tried logging on with sqlplus but it would not allow me

Thanks for your help

Question by:algotube

    Author Comment

    Hello I was able to log into sqlplus:

    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.

    C:\Documents and Settings\pr3adm.ALGOMA>sqlplus /nolog

    SQL*Plus: Release - Production on Tue Apr 4 15:36:43 2006

    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

    SQL> connect / as sysdba;
    Connected to an idle instance.
    SQL> alter database open resetlogs;
    alter database open resetlogs
    ERROR at line 1:
    ORA-01034: ORACLE not available


    as you can see I have connected as sys and received ORA-01034 when I used alter database open resetlogs.........what command should I have used before the alter database open resetlogs...............
    LVL 29

    Expert Comment


    startup mount;

    Accepted Solution

    Closed, 100 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now