Forum Discussion

AICT-IT's avatar
AICT-IT
Level 3
12 years ago

Oracle 10g incomplete recovery does not recover data to specific date

 

I had a problem when restore an incomplete recovery the job was successful however no data recovered

RESTORE

    DATABASE

    UNTIL TIME "TO_DATE('05-15-2013:13:00:00', 'MM-DD-YYYY:HH24:MI:SS')"

    CHECK READONLY;

 

RECOVER

    DATABASE

    UNTIL TIME "TO_DATE('05-15-2013:13:00:00', 'MM-DD-YYYY:HH24:MI:SS')"

    DELETE ARCHIVELOG,

    CHECK READONLY;

the data is not recoveed to 05/15/2013 however teh job status is 0

 

Master Server : 7.5.0.4 /Windows

Mediaserver(and Oracle agent) : 6.5 /RHEL 4.3(32bits)

 

 

Thanks,

3 Replies

  •  

    NF - Begin progress logging for process: (10174)
    INF - Putting the database in mount state.
    INF - Using: /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus
    INF - Connection info: 'connect sys/*****@xxxxx as SYSDBA'.
    INF - Start of SQLPLUS output.
    INF - SQL*Plus: Release 10.2.0.2.0 - Production on Mon May 20 11:04:15 2013
    INF - Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    INF - SQL> Connected.
    INF - SQL> ORA-01109: database not open
    INF - Database dismounted.
    INF - ORACLE instance shut down.
    INF - SQL> ORACLE instance started.
    INF - Database mounted.
    INF - SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    INF - End of SQLPLUS output.
    INF - Starting Oracle Recovery Manager.
    INF - Using: /u01/app/oracle/product/10.2.0/db_1/bin/rman 
    INF - Connection info: target 'sys/*****@xxxxx' nocatalog
    INF - Start of Recovery Manager input.
    INF - # -----------------------------------------------------------------
    INF - # RMAN command section
    INF - # -----------------------------------------------------------------
    INF - RUN {
    INF - ALLOCATE CHANNEL ch00 
    INF -     TYPE 'SBT_TAPE';
    INF - ALLOCATE CHANNEL ch01 
    INF -     TYPE 'SBT_TAPE';
    INF - ALLOCATE CHANNEL ch02 
    INF -     TYPE 'SBT_TAPE';
    INF - ALLOCATE CHANNEL ch03 
    INF -     TYPE 'SBT_TAPE';
    INF - SEND 'NB_ORA_SERV=d-s-nbu-01.aict.com.eg';
    INF - RESTORE
    INF -     DATABASE
    INF -     UNTIL TIME "TO_DATE('05-15-2013:13:00:00', 'MM-DD-YYYY:HH24:MI:SS')"
    INF -     CHECK READONLY;
    INF - RECOVER
    INF -     DATABASE
    INF -     UNTIL TIME "TO_DATE('05-15-2013:13:00:00', 'MM-DD-YYYY:HH24:MI:SS')"
    INF -     DELETE ARCHIVELOG,
    INF -     CHECK READONLY;
    INF - RELEASE CHANNEL ch00;
    INF - RELEASE CHANNEL ch01;
    INF - RELEASE CHANNEL ch02;
    INF - RELEASE CHANNEL ch03;
    INF - }
    INF - End of Recovery Manager input.
    INF - Start of Recovery Manager output.
    INF - Recovery Manager: Release 10.2.0.2.0 - Production on Mon May 20 11:04:40 2013
    INF - connected to target database: xxxxx (DBID=2321274682, not open)
    INF - using target database control file instead of recovery catalog
    INF - allocated channel: ch00
    INF - allocated channel: ch01
    INF - allocated channel: ch02
    INF - allocated channel: ch03
    INF - Starting restore at 20-MAY-13
    INF - channel ch00: starting datafile backupset restore
    INF - restoring datafile 00001 to /data/oradata/xxxxx/system01.dbf
    INF - restoring datafile 00002 to /data/oradata/xxxxx/undotbs01.dbf
    INF - restoring datafile 00003 to /data/oradata/xxxxx/sysaux01.dbf
    INF - restoring datafile 00004 to /data/oradata/xxxxx/users01.dbf
    INF - restoring datafile 00005 to /data/oradata/xxxxx/xxxxx_tbs_01.dbf
    INF - restoring datafile 00006 to /data/oradata/xxxxx/xxxxx_tbs_02.dbf
    INF - restoring datafile 00007 to /data/oradata/xxxxx/xxxxx_tbs_03.dbf
    INF - restoring datafile 00008 to /data/oradata/xxxxx/xxxxx_tbs_04.dbf
    INF - Begin progress logging for process: (10314)
    INF - Start restore of backup piece: (bk_uvno9fm5n_s1015_p1_t815257783)
    INF - Backup id: DKH-S-UAT-01_1368380422
    INF - Policy: Ora_test
    INF - Master server: d-s-nbu-01
    INF - Restore id: 109305.001
    INF - Server status = 0
    INF - End restore of backup piece: (bk_uvno9fm5n_s1015_p1_t815257783)
    INF - restoring datafile 00009 to /data/oradata/xxxxx/gdr_tbs_01.dbf
    INF - restoring datafile 00010 to /data/oradata/xxxxx/oms_tbs_01.dbf
    INF - restoring datafile 00011 to /data/oradata/xxxxx/web_tbs_01.dbf
    INF - restoring datafile 00012 to /data/oradata/xxxxx/XDB_tbs_01.dbf
    INF - restoring datafile 00013 to /data/oradata/xxxxx/xxxxx_tbs_05.dbf
    INF - restoring datafile 00014 to /data/oradata/xxxxx/system02.dbf
    INF - channel ch00: reading from backup piece bk_uvno9fm5n_s1015_p1_t815257783
    INF - channel ch00: restored backup piece 1
    INF - piece handle=bk_uvno9fm5n_s1015_p1_t815257783 tag=TAG20130512T202943
    INF - channel ch00: restore complete, elapsed time: 00:10:47
    INF - Finished restore at 20-MAY-13
    INF - Starting recover at 20-MAY-13
    INF - starting media recovery
    INF - channel ch00: starting archive log restore to default destination
    INF - channel ch01: starting archive log restore to default destination
    INF - channel ch01: restoring archive log
    INF - archive log thread=1 sequence=1558
    INF - Begin progress logging for process: (10314)
    INF - Begin progress logging for process: (10316)
    INF - Start restore of backup piece: (arch_u6coa1hoi_s1228_p1_t815843090)
    INF - Start restore of backup piece: (arch_u69oa1hoi_s1225_p1_t815843090)
    INF - Backup id: DKH-S-UAT-01_1368965145
    INF - Backup id: DKH-S-UAT-01_1368965147
    INF - Policy: xxxxx-DB
    INF - Policy: xxxxx-DB
    INF - Master server: d-s-nbu-01
    INF - Master server: d-s-nbu-01
    INF - Restore id: 109306.001
    INF - Restore id: 109307.001
    INF - Beginning restore from server d-s-nbu-02.aict.com.eg to client DKH-S-UAT-01.
    INF - Server status = 0
    INF - Server status = 0
    INF - End restore of backup piece: (arch_u6coa1hoi_s1228_p1_t815843090)
    INF - End restore of backup piece: (arch_u69oa1hoi_s1225_p1_t815843090)
    INF - channel ch01: reading from backup piece arch_u69oa1hoi_s1225_p1_t815843090
    INF - channel ch00: restoring archive log
    INF - archive log thread=1 sequence=1559
    INF - channel ch00: restoring archive log
    INF - archive log thread=1 sequence=1560
    INF - channel ch00: restoring archive log
    INF - archive log thread=1 sequence=1561
    INF - channel ch00: reading from backup piece arch_u6coa1hoi_s1228_p1_t815843090
    INF - channel ch00: restored backup piece 1
    INF - piece handle=arch_u6coa1hoi_s1228_p1_t815843090 tag=TAG20130519T150449
    INF - channel ch00: restore complete, elapsed time: 00:00:55
    INF - channel ch01: restored backup piece 1
    INF - piece handle=arch_u69oa1hoi_s1225_p1_t815843090 tag=TAG20130519T150449
    INF - channel ch01: restore complete, elapsed time: 00:00:55
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1558_8smpyf89_.arc thread=1 sequence=1558
    INF - channel default: deleting archive log(s)
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1558_8smpyf89_.arc recid=1236 stamp=815915778
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1559_8smpycsg_.arc thread=1 sequence=1559
    INF - channel default: deleting archive log(s)
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1559_8smpycsg_.arc recid=1234 stamp=815915771
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1560_8smpyco7_.arc thread=1 sequence=1560
    INF - channel default: deleting archive log(s)
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1560_8smpyco7_.arc recid=1237 stamp=815915779
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1561_8smpycpx_.arc thread=1 sequence=1561
    INF - channel default: deleting archive log(s)
    INF - archive log filename=/u01/app/oracle/product/10.2.0/flash_recovery_area/xxxxx/archivelog/2013_05_20/o1_mf_1_1561_8smpycpx_.arc recid=1235 stamp=815915777
    INF - media recovery complete, elapsed time: 00:00:09
    INF - Finished recover at 20-MAY-13
    INF - released channel: ch00
    INF - released channel: ch01
    INF - released channel: ch02
    INF - released channel: ch03
    INF - Recovery Manager complete.
    INF - End of Recovery Manager output.
    INF - End Oracle Recovery Manager.
    INF - Putting the database in open state.
    INF - Using: /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus
    INF - Connection info: 'connect sys/*****@xxxxx as SYSDBA'.
    INF - Start of SQLPLUS output.
    INF - SQL*Plus: Release 10.2.0.2.0 - Production on Mon May 20 11:17:01 2013
    INF - Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    INF - SQL> Connected.
    INF - SQL> 
    INF - Database altered.
    INF - SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
    INF - End of SQLPLUS output.

     

     

  • I look like Netbackup did what it was asked by RMAN. So it's not a Netbackup issues.

    I am not Oracle Expert but try to change:

    RECOVER

    DATABASE

    UNTIL TIME "TO_DATE('05-15-2013:13:00:00', 'MM-DD-YYYY:HH24:MI:SS')"

    to

    recover database until time  'YYYY-MM-DD:HH24:MI:SS

    I think RMAN am missing the "until time" if that statement is in 3 lines.

    http://www.symantec.com/docs/TECH8030