Cannot restore from hot full backup(ORA-01152 RMAN-06053)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Cannot restore from hot full backup(ORA-01152 RMAN-06053)

  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Cannot restore from hot full backup(ORA-01152 RMAN-06053)

    Hi all,
    I want to make a recovery practice before we move to another building,but i met a problem which i canot resolve:
    a.production machine
    b.test machine
    c.catalog machine


    1. I did a hot backup via Veritas, and it was finished at 22-APR 12:45
    2. I have a test machine which i have configure all the enviroment already(including spfile,tnsnames.ora .etc..)
    3. Catalog is on the third machine.
    4. i run rman on the test machine(rman target / catalog rman/rman@aaa)
    5. RMAN>startup nomount
    6. run {
    allocate channel c1 type sbt;
    send 'NB_ORA_CLIENT=db';
    restore controlfile;
    }
    7. RMAN>alter database mount;
    8. list backup of controlfile;

    List of Backup Sets
    ===================
    ............
    ............
    ............
    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    74053 Incr 0 5.75M SBT_TAPE 00:01:38 22-APR-09
    BP Key: 74063 Status: AVAILABLE Compressed: NO Tag: TAG20090422T182046
    Handle: full_FIMASYS_4400_1_684873116.bak Media: 0050L2
    Control File Included: Ckp SCN: 153914435 Ckp time: 22-APR-09

    9. host;sqlplus ...
    10. SQL> select controlfile_change# from v$database;

    CONTROLFILE_CHANGE#
    -------------------
    153914435

    11.exit to RMAN
    12.RMAN> run {
    2> set until time "to_date('2009/04/22 13:00','yyyy/mm/dd hh24:mi:ss')";
    3> allocate channel c1 type sbt;
    4> send 'NB_ORA_CLIENT=db';
    5> restore database;
    6> recover database;
    7> }

    Finished restore at 22-APR-09

    Starting recover at 22-APR-09

    starting media recovery

    Oracle Error:
    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: '/oradata/FIMASYS10G/undotbs1.dbf'

    released channel: c1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 04/22/2009 20:02:50
    RMAN-06053: unable to perform media recovery because of missing log
    RMAN-06025: no backup of log thread 1 seq 4346 lowscn 150296436 found to restore

    13. Go to Sqlplus to check the latest v$log
    SQL> select thread#,sequence# from v$log;

    THREAD# SEQUENCE#
    ---------- ----------
    1 4474
    1 4472
    1 4473

    SQL> select controlfile_change# from v$database;

    CONTROLFILE_CHANGE#
    -------------------
    153914435

    SQL> select archivelog_change# from v$database;

    ARCHIVELOG_CHANGE#
    ------------------
    153912062
    SQL> select checkpoint_change# from v$datafile;

    CHECKPOINT_CHANGE#
    ------------------
    153913134
    153913863
    153913659
    153913659
    153913863
    153913134
    153913659
    153913133
    153913133
    153913133
    153913863

    CHECKPOINT_CHANGE#
    ------------------
    153913134
    153913659
    153913133
    153913863
    153913134
    153913659
    153913133

    18 rows selected.
    SQL> select * from v$backup
    2 ;

    FILE# STATUS CHANGE# TIME
    ---------- ------------------------------------ ---------- ------------
    1 NOT ACTIVE 0
    2 NOT ACTIVE 0
    3 NOT ACTIVE 0
    4 NOT ACTIVE 0
    5 NOT ACTIVE 0
    6 NOT ACTIVE 0
    7 NOT ACTIVE 0
    8 NOT ACTIVE 0
    9 NOT ACTIVE 0
    10 NOT ACTIVE 0
    11 NOT ACTIVE 0

    FILE# STATUS CHANGE# TIME
    ---------- ------------------------------------ ---------- ------------
    12 NOT ACTIVE 0
    13 NOT ACTIVE 0
    14 NOT ACTIVE 0
    15 NOT ACTIVE 0
    16 NOT ACTIVE 0
    17 NOT ACTIVE 0
    18 NOT ACTIVE 0

    18 rows selected.


    I firstly thought that i may delete the archlog accidently, so i go to rman and run
    "crosscheck archivelog all",then made a hot full backup again, then make a restore exercise, but failed again.

    So, could anyone give me some suggestions ??
    Thanks a lot ~~~~

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Talking Pit

    You may need to do Point In Time recovery.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    ...
    RMAN-03002: failure of recover command at 04/22/2009 20:02:50
    RMAN-06053: unable to perform media recovery because of missing log
    RMAN-06025: no backup of log thread 1 seq 4346 lowscn 150296436 found to restore
    ...
    SQL> select thread#,sequence# from v$log;

    THREAD# SEQUENCE#
    ---------- ----------
    1 4474
    1 4472
    1 4473
    You don't have archive for log seq 4346; you need to do a PITR. You said you did a full hot backup but couldn't restore with the same, is your db in archivelog mode?

  4. #4
    Join Date
    Apr 2009
    Posts
    2
    It was kinda strange...
    It works if i use "recover database ... " in sqlplus but not rman....

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
  •  



Click Here to Expand Forum to Full Width