Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2016
    Posts
    3

    Unanswered: recover oracle using rman

    Hello.
    Please help.
    I do a backup database in archivelog mode is used rman.
    OS Linux OEL 6.6
    DB: Oracle 11g Enterprise
    rman script:

    run
    {
    allocate channel ch1 device type disk format '/u01/db/full_%d_%s_%T.bkp';
    allocate channel ch2 device type disk format '/u01/db/full_%d_%s_%T.bkp';
    allocate channel ch3 device type disk format '/u01/db/full_%d_%s_%T.bkp';
    allocate channel ch4 device type disk format '/u01/db/full_%d_%s_%T.bkp';
    crosscheck backup device type disk;
    crosscheck archivelog all device type disk;
    backup as compressed backupset full database;
    sql'alter system switch logfile';
    backup archivelog all format '/u01/db/arch_%d_%s_%T.bkp';
    backup current controlfile format '/u01/db/ctl_%d_%s_%T.bkp';
    crosscheck backup device type disk;
    crosscheck archivelog all device type disk;
    delete noprompt obsolete device type disk;
    delete noprompt archivelog until time 'sysdate-2';
    }
    backups ready;

    restore database;

    run{
    restore database;
    recover database;
    alter database open;
    }

    error: open database Resetlogs or Noresetlogs mode;

    I need to open the database without resetlogs options.
    without clearing redo log and create a new database incarnation.

    How to do it.

  2. #2
    Join Date
    Jun 2004
    Posts
    793
    Provided Answers: 1
    I'm not sure you can do it without resetting the logs as the error you're getting points to an incomplete recovery. Read this, from another site:

    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.

    The ORA-01589 error indicates that you have an incomplete recovery and you need to recover the incomplete recovery and then reset the logs before going to open the database.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •