Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- VOX
- Data Protection
- NetBackup
- Oracle 10g incomplete recovery does not recover da...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Oracle 10g incomplete recovery does not recover data to specific date
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2013 06:11 AM
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,
Labels:
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2013 06:20 AM
Can you post the recovery logs?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2013 06:51 AM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2013 09:09 AM
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
Related Content
- NetBackup 10.4 MPA and MFA Enhancements --- Modern Security for Modern Times in NetBackup
- Reporting Now Available for Veritas Alta Recovery Vault! in NetBackup
- DR procedures with duplicated backup images in NetBackup
- mssql with transactions logs be truncated in Backup Exec
- Veritas Introduces New Recovery Options for IaaS Virtual Machines! in NetBackup
