This discussion is archived
9 Replies Latest reply: Dec 10, 2012 11:49 PM by 951027 RSS

rman restore failure

951027 Newbie
Currently Being Moderated
Hello all,

I've taken rman full backup and it was successful but when im trying to restore and recover im getting tis errors



ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: 'E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\APP\JASAF\ORADATA\ORCL\SYSTEM01.DBF'


im using windows 7 pro with 11.2.0.1.0
  • 1. Re: rman restore failure
    hitgon Expert
    Currently Being Moderated
    ORA-01152: file 1 was not restored from a sufficiently old backup

    Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.

    Action: Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.

    ORA-01152: file 1 was not restored from a sufficiently old backup

    http://oraware.blogspot.in/2008/05/ora-01152-file-1-was-not-restored-from.html
  • 2. Re: rman restore failure
    951027 Newbie
    Currently Being Moderated
    I've taken backup using

    Rman> backup database plus archivelog;


    then from the point backup has been taken there are few changes in few tables
    which i want to ignore.

    i did shutdown

    deleted oradata files

    then

    rman> startup nomount;

    rman> resotre control file from ' location of backup piece';


    rman> alter database mount;


    rman> restore database;

    restore complete

    rman> recover database;

    and then i get that error file is inconsistent
  • 3. Re: rman restore failure
    951027 Newbie
    Currently Being Moderated
    ALTER DATABASE OPEN RESETLOGS;
    ORA-01152: file 2 was not restored from a sufficiently old backup
    ORA-01110: data file 2: 'E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF'
  • 4. Re: rman restore failure
    951027 Newbie
    Currently Being Moderated
    C:\Users\ORACLE>rman target /

    Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 11 10:42:09 2012

    Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

    connected to target database: ORCL (not mounted)

    RMAN> restore controlfile from 'E:\datapump\2012_11_26\O1_MF_NCSNF_TAG20121126T1
    60404_8C6PR17J_.BKP'
    2> ;

    Starting restore at 11-DEC-12
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=241 device type=DISK

    channel ORA_DISK_1: restoring control file
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
    output file name=E:\APP\ORACLE\ORADATA\ORCL\CONTROL01.CTL
    output file name=E:\APP\ORACLE\ORADATA\ORCL\CONTROL02.CTL
    output file name=E:\APP\ORACLE\ORADATA\ORCL\CONTROL03.CTL
    output file name=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL
    Finished restore at 11-DEC-12

    RMAN> restore database;

    Starting restore at 11-DEC-12
    using channel ORA_DISK_1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 12/11/2012 10:42:41
    ORA-01507: database not mounted

    RMAN> alter database mount;

    database mounted
    released channel: ORA_DISK_1

    RMAN> restore database;

    Starting restore at 11-DEC-12
    Starting implicit crosscheck backup at 11-DEC-12
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=241 device type=DISK
    Crosschecked 7 objects
    Finished implicit crosscheck backup at 11-DEC-12

    Starting implicit crosscheck copy at 11-DEC-12
    using channel ORA_DISK_1
    Finished implicit crosscheck copy at 11-DEC-12

    searching for all files in the recovery area
    cataloging files...
    cataloging done

    List of Cataloged Files
    =======================
    File Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2012_11_26\O1_MF_S_8
    00382231_8C6QTQYH_.BKP
    File Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2012_11_26\O1_MF_S_8
    00383078_8C6RO7Q4_.BKP
    File Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O1_MF_ANNN
    N_TAG20121126T160522_8C6PR2X8_.BKP
    File Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O1_MF_NCSN
    F_TAG20121126T160404_8C6PR17J_.BKP
    File Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O1_MF_NNND
    F_TAG20121126T162315_8C6QSN6G_.BKP

    using channel ORA_DISK_1

    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 E:\APP\ORACLE\ORADATA\ORCL\SYSTEM
    01.DBF
    channel ORA_DISK_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\ORCL\UNDOTB
    S01.DBF
    channel ORA_DISK_1: restoring datafile 00004 to E:\APP\ORACLE\ORADATA\ORCL\USERS0
    1.DBF
    channel ORA_DISK_1: restoring datafile 00005 to E:\APP\ORACLE\ORADATA\ORION1.DBF
    channel ORA_DISK_1: reading from backup piece E:\APP\ORACLE\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_NNNDF_TAG20121126T160404_8C6PONY6_.BKP
    channel ORA_DISK_1: piece handle=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET
    \2012_11_26\O1_MF_NNNDF_TAG20121126T160404_8C6PONY6_.BKP tag=TAG20121126T160404
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
    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 00002 to E:\APP\ORACLE\ORADATA\ORCL\SYSAUX
    01.DBF
    channel ORA_DISK_1: reading from backup piece E:\APP\ORACLE\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_NNNDF_TAG20121126T162315_8C6QSN6G_.BKP
    channel ORA_DISK_1: piece handle=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET
    \2012_11_26\O1_MF_NNNDF_TAG20121126T162315_8C6QSN6G_.BKP tag=TAG20121126T162315
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
    Finished restore at 11-DEC-12

    RMAN> recover database;

    Starting recover at 11-DEC-12
    using channel ORA_DISK_1

    starting media recovery

    channel ORA_DISK_1: starting archived log restore to default destination
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=31
    channel ORA_DISK_1: reading from backup piece E:\APP\ORACLE\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_ANNNN_TAG20121126T160522_8C6PR2X8_.BKP
    channel ORA_DISK_1: piece handle=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET
    \2012_11_26\O1_MF_ANNNN_TAG20121126T160522_8C6PR2X8_.BKP tag=TAG20121126T160522
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
    archived log file name=E:\ARCHIVE\ARC0000000031_0800292330.0001 thread=1 sequenc
    e=31
    unable to find archived log
    archived log thread=1 sequence=32
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 12/11/2012 10:44:54
    RMAN-06054: media recovery requesting unknown archived log for thread 1 with seq
    uence 32 and starting SCN of 20652706

    RMAN> alter database open;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of alter db command at 12/11/2012 10:45:08
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    RMAN> alter database open resetlogs;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of alter db command at 12/11/2012 10:45:13
    ORA-01152: file 2 was not restored from a sufficiently old backup
    ORA-01110: data file 2: 'E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF'

    RMAN> alter databaseopen resetlogs;7

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01009: syntax error: found "identifier": expecting one of: "database"
    RMAN-01008: the bad identifier was: databaseopen
    RMAN-01007: at line 1 column 7 file: standard input
  • 5. Re: rman restore failure
    KuljeetPalSingh Guru
    Currently Being Moderated
    Rman> backup database plus archivelog;
    then from the point backup has been taken there are few changes in few tables
    which i want to ignore.
    i did shutdown
    deleted oradata files
    perform point in time recovery as you've to recover the database before the time when this dbf file got removed.
  • 6. Re: rman restore failure
    951027 Newbie
    Currently Being Moderated
    RMAN> list backup;

    using target database control file instead of recovery catalog

    List of Backup Sets
    ===================


    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    4 7.21M DISK 00:00:00 25-NOV-12
    BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20121125T141027
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_25\O
    1_MF_ANNNN_TAG20121125T141027_8C3VNN2R_.BKP

    List of Archived Logs in backup set 4
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 95 20127108 25-NOV-12 20137097 25-NOV-12

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    5 Full 1.15G DISK 00:01:05 25-NOV-12
    BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20121125T141029
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_25\O
    1_MF_NNNDF_TAG20121125T141029_8C3VNON8_.BKP
    List of Datafiles in backup set 5
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 20137103 25-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
    2 Full 20137103 25-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
    3 Full 20137103 25-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
    4 Full 20137103 25-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    6 29.00K DISK 00:00:00 25-NOV-12
    BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20121125T141147
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_25\O
    1_MF_ANNNN_TAG20121125T141147_8C3VQ3LZ_.BKP

    List of Archived Logs in backup set 6
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 96 20137097 25-NOV-12 20137174 25-NOV-12

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    7 Full 9.36M DISK 00:00:00 25-NOV-12
    BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20121125T141029
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_25\O
    1_MF_NCSNF_TAG20121125T141029_8C3VQ1X4_.BKP
    SPFILE Included: Modification time: 25-NOV-12
    SPFILE db_unique_name: ORCL
    Control File Included: Ckp SCN: 20137168 Ckp time: 25-NOV-12

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    8 7.24M DISK 00:00:00 26-NOV-12
    BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20121126T160306
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_ANNNN_TAG20121126T160306_8C6PMV9D_.BKP

    List of Archived Logs in backup set 8
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 95 20127108 25-NOV-12 20137097 25-NOV-12
    1 96 20137097 25-NOV-12 20137174 25-NOV-12

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    9 912.88M DISK 00:00:54 26-NOV-12
    BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20121126T160306
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_ANNNN_TAG20121126T160306_8C6PMX3O_.BKP

    List of Archived Logs in backup set 9
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 1 20137175 25-NOV-12 20183911 26-NOV-12
    1 2 20183911 26-NOV-12 20206901 26-NOV-12
    1 3 20206901 26-NOV-12 20209798 26-NOV-12
    1 4 20209798 26-NOV-12 20210020 26-NOV-12
    1 5 20210020 26-NOV-12 20210114 26-NOV-12
    1 6 20210114 26-NOV-12 20210220 26-NOV-12
    1 7 20210220 26-NOV-12 20213782 26-NOV-12
    1 8 20213782 26-NOV-12 20244375 26-NOV-12
    1 9 20244375 26-NOV-12 20274519 26-NOV-12
    1 10 20274519 26-NOV-12 20301411 26-NOV-12
    1 11 20301411 26-NOV-12 20318403 26-NOV-12
    1 12 20318403 26-NOV-12 20332459 26-NOV-12
    1 13 20332459 26-NOV-12 20346052 26-NOV-12
    1 14 20346052 26-NOV-12 20361799 26-NOV-12
    1 15 20361799 26-NOV-12 20402356 26-NOV-12
    1 16 20402356 26-NOV-12 20414042 26-NOV-12
    1 17 20414042 26-NOV-12 20414241 26-NOV-12
    1 18 20414241 26-NOV-12 20414358 26-NOV-12
    1 19 20414358 26-NOV-12 20414460 26-NOV-12
    1 20 20414460 26-NOV-12 20416222 26-NOV-12
    1 21 20416222 26-NOV-12 20450040 26-NOV-12
    1 22 20450040 26-NOV-12 20484075 26-NOV-12
    1 23 20484075 26-NOV-12 20500674 26-NOV-12
    1 24 20500674 26-NOV-12 20519214 26-NOV-12
    1 25 20519214 26-NOV-12 20533682 26-NOV-12
    1 26 20533682 26-NOV-12 20547935 26-NOV-12
    1 27 20547935 26-NOV-12 20584750 26-NOV-12
    1 28 20584750 26-NOV-12 20626326 26-NOV-12
    1 29 20626326 26-NOV-12 20651854 26-NOV-12
    1 30 20651854 26-NOV-12 20652587 26-NOV-12

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    10 Full 1.15G DISK 00:01:06 26-NOV-12
    BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20121126T160404
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_NNNDF_TAG20121126T160404_8C6PONY6_.BKP
    List of Datafiles in backup set 10
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 20652645 26-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
    2 Full 20652645 26-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
    3 Full 20652645 26-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
    4 Full 20652645 26-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\USERS01.DBF
    5 Full 20652645 26-NOV-12 E:\APP\ORACLE\ORADATA\ORION1.DBF

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    11 46.00K DISK 00:00:00 26-NOV-12
    BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20121126T160522
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_ANNNN_TAG20121126T160522_8C6PR2X8_.BKP

    List of Archived Logs in backup set 11
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 31 20652587 26-NOV-12 20652706 26-NOV-12

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    12 Full 9.61M DISK 00:00:00 26-NOV-12
    BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20121126T160404
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_NCSNF_TAG20121126T160404_8C6PR17J_.BKP
    SPFILE Included: Modification time: 26-NOV-12
    SPFILE db_unique_name: ORCL
    Control File Included: Ckp SCN: 20652700 Ckp time: 26-NOV-12

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    13 Full 442.28M DISK 00:00:00 26-NOV-12
    BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20121126T162315
    Piece Name: E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_11_26\O
    1_MF_NNNDF_TAG20121126T162315_8C6QSN6G_.BKP
    List of Datafiles in backup set 13
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    2 Full 20674737 26-NOV-12 E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
  • 7. Re: rman restore failure
    hitgon Expert
    Currently Being Moderated
    Refer the link

    Incomplete Recovery (until point in time)
    Incomplete Recovery (until log sequence)

    http://gavinsoorma.com/recovery-scenarios/
  • 8. Re: rman restore failure
    MahirM.Quluzade Guru
    Currently Being Moderated
    Hi,

    Did you backed up archivelogs?
    Please try, after RMAN>RESTORE DATABASE;
     RMAN> RESTORE ARCHIVELOG ALL;
     RMAN> RECOVER DATABASE; 
     RMAN> SQL 'alter database open';
     
    Please paste here results.


    Regards
    Mahir M. Quluzade
    www.mahir-quluzade.com
  • 9. Re: rman restore failure
    951027 Newbie
    Currently Being Moderated
    YES I did

    rman > backup database plus archivelog;


    after that archvie logs and oradata files have been deleted



    I HAVE PERFROMED THE STEPS BUT STILL THE SAME below are the results


    RMAN> RESTORE ARCHIVELOG ALL;

    Starting restore at 11-DEC-12
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=123 device type=DISK

    archived log for thread 1 with sequence 31 is already on disk as file E:\ARCHIVE
    \ARC0000000031_0800292330.0001
    channel ORA_DISK_1: starting archived log restore to default destination
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=95
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=96
    channel ORA_DISK_1: reading from backup piece E:\APP\ORACLE\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_ANNNN_TAG20121126T160306_8C6PMV9D_.BKP
    channel ORA_DISK_1: piece handle=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET
    \2012_11_26\O1_MF_ANNNN_TAG20121126T160306_8C6PMV9D_.BKP tag=TAG20121126T160306
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
    channel ORA_DISK_1: starting archived log restore to default destination
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=1
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=2
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=3
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=4
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=5
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=6
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=7
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=8
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=9
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=10
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=11
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=12
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=13
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=14
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=15
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=16
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=17
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=18
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=19
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=20
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=21
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=22
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=23
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=24
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=25
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=26
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=27
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=28
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=29
    channel ORA_DISK_1: restoring archived log
    archived log thread=1 sequence=30
    channel ORA_DISK_1: reading from backup piece E:\APP\ORACLE\FLASH_RECOVERY_AREA\O
    RCL\BACKUPSET\2012_11_26\O1_MF_ANNNN_TAG20121126T160306_8C6PMX3O_.BKP
    channel ORA_DISK_1: piece handle=E:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\BACKUPSET
    \2012_11_26\O1_MF_ANNNN_TAG20121126T160306_8C6PMX3O_.BKP tag=TAG20121126T160306
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
    Finished restore at 11-DEC-12

    RMAN> recover database;

    Starting recover at 11-DEC-12
    using channel ORA_DISK_1

    starting media recovery

    unable to find archived log
    archived log thread=1 sequence=32
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 12/11/2012 11:48:27
    RMAN-06054: media recovery requesting unknown archived log for thread 1 with seq
    uence 32 and starting SCN of 20652706

    RMAN> alter database open;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of alter db command at 12/11/2012 11:48:34
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    RMAN> alter database open resetlogs;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of alter db command at 12/11/2012 11:48:41
    ORA-01152: file 2 was not restored from a sufficiently old backup
    ORA-01110: data file 2: 'E:\APP\ORACLE\ORADATA\ORCL\SYSAUX01.DBF'

    RMAN>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points