Oracle Backup Issue | NBU ver 6.5
Hi Guru's Recently had issue with an oracle backup, Sorry if the information given is insufficient but will try my best. As per what the structure is currently (Provided with the backup selection list in bracket): 1st DB Backup Runs (/usr/local/nb/scripts/oracle_rman_hot.uaedb1) 2nd RMAN Logs (Backup selection list is empty) 3rd DB Files ( / ) 4th OS Files ( / ) ========================= When a Oracle backup is triggered, the others gets triggered automaticly until it completes. And all these are in a different policy: e.g 1.DB Backup = (DB_ORA_UAE) 2.RMAN Logs = (UAE_RMAN_LOGS_DW) 3.DB Files = (DB_Files) 4.OS Files = (FS_UAE_UNIX_1) ========================== My concern is, how to make the rman log, db files and os files jobs to run automated upon triggering the DB backup? is it by script? On another note, DBA team informed me that all the backups in order, but i cant seem to see that in netbackup. Thank You Guru's1.1KViews2likes5CommentsBackup of really huge database using Netbackup 7
Hi I would like to have your valuable views and suggestions regarding Oracle backups. Oracle version : Oracle 11g R2 configured in 2 node RAC on RHEL 6 Number of DB instances : 2 DB size : Instance 1: 7 TB Instance 2: 12 TB I would like to know what will be the best way to backup these databases using Netbackup like RMAN or RMAN with Snapshot client or any other method like storage based snapshot using Snapshot client option and having it moved to tape. Thanks Giri B1.6KViews1like6CommentsNetBackup: Backing Up Oracle Exadata
Hi. We just ordered an Oracle Exadata (and when I say "we", I mean my managers), and am now being told that in order to back it up, we need to purchase a ZFS appliance. Is there another way to back up the data from the Oracle Exadata? We only back up RMAN dumps and logs, which are usually on a separate filesystem. I'm going to guess that these will still be on the Exadata, but I think you can still do these dumps to an NFS share and back it up on that NFS server. Has anyone found a solution to do this without paying $$$$$$$$$ to Oracle?4KViews1like3CommentsRestore SAP Backups using RMAN
Hi we are trying to do a desaster recovery test for SAP on Oracle. After having done successful backups the sap admin tries to recover the oracle database based on the backups we did with the brtools. When you to a list backup of database we get the correct output. When we try to do a validate or a restore command based on the tags, backup sets or timestamps we get the following issue: BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 581 Full 57.06G SBT_TAPE 00:14:26 08-MAR-11 BP Key: 581 Status: AVAILABLE Compressed: NO Tag: BEFJWXKQ Handle: MI1001_befjwxkq.700_1 Media: List of Datafiles in backup set 581 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata5/system_1/system.data1 2 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata6/undo_1/undo.data1 4 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata1/sr3_1/sr3.data1 6 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata3/sr3_3/sr3.data3 8 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata1/sr3700_1/sr3700.data1 10 Full 153016816 08-MAR-11 /oracle/db/MI1/sapdata3/sr3700_3/sr3700.data3 RMAN> validate backupset 581; using channel ORA_SBT_TAPE_1 using channel ORA_DISK_1 channel ORA_SBT_TAPE_1: starting validation of datafile backupset channel ORA_SBT_TAPE_1: reading from backup piece MI1001_befjwxkq.700_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of validate command on ORA_SBT_TAPE_1 channel at 03/08/2011 22:11:40 ORA-19870: error reading backup piece MI1001_befjwxkq.700_1 ORA-19507: failed to retrieve sequential file, handle="MI1001_befjwxkq.700_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <MI1001_befjwxkq.700_1> not found in NetBackup catalog During the rman restore of the SAP backup: RMAN> run { 2> allocate channel t1 type 'SBT_TAPE'; 3> allocate channel t2 type 'SBT_TAPE'; 4> send 'NB_ORA_POLICY=SAP_MI1_ORACLE, NB_ORA_SERV=przlnbm001'; 5> restore database from tag 'BEFITXUP'; 6> } allocated channel: t1 channel t1: sid=2492 instance=MI1001 devtype=SBT_TAPE channel t1: Veritas NetBackup for Oracle - Release 7.0 (2010010419) allocated channel: t2 channel t2: sid=2491 instance=MI1001 devtype=SBT_TAPE channel t2: Veritas NetBackup for Oracle - Release 7.0 (2010010419) sent command to channel: t1 sent command to channel: t2 Starting restore at 02-MAR-11 channel t1: starting datafile backupset restore channel t1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /oracle/db/MI1/sapdata5/system_1/system.data1 restoring datafile 00002 to /oracle/db/MI1/sapdata6/undo_1/undo.data1 restoring datafile 00004 to /oracle/db/MI1/sapdata1/sr3_1/sr3.data1 restoring datafile 00006 to /oracle/db/MI1/sapdata3/sr3_3/sr3.data3 restoring datafile 00008 to /oracle/db/MI1/sapdata1/sr3700_1/sr3700.data1 restoring datafile 00010 to /oracle/db/MI1/sapdata3/sr3700_3/sr3700.data3 channel t1: reading from backup piece MI1001_befitxup.604_1 channel t2: starting datafile backupset restore channel t2: specifying datafile(s) to restore from backup set restoring datafile 00003 to /oracle/db/MI1/sapdata5/sysaux_1/sysaux.data1 restoring datafile 00005 to /oracle/db/MI1/sapdata2/sr3_2/sr3.data2 restoring datafile 00007 to /oracle/db/MI1/sapdata4/sr3_4/sr3.data4 restoring datafile 00009 to /oracle/db/MI1/sapdata2/sr3700_2/sr3700.data2 restoring datafile 00011 to /oracle/db/MI1/sapdata4/sr3700_4/sr3700.data4 restoring datafile 00012 to /oracle/db/MI1/sapdata5/sr3usr_1/sr3usr.data1 restoring datafile 00013 to /oracle/db/MI1/sapdata6/undo_2/undo_2.data channel t2: reading from backup piece MI1001_befitxup.605_1 ORA-19870: error reading backup piece MI1001_befitxup.604_1 ORA-19507: failed to retrieve sequential file, handle="MI1001_befitxup.604_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <MI1001_befitxup.604_1> not found in NetBackup catalog ORA-19870: error reading backup piece MI1001_befitxup.605_1 ORA-19507: failed to retrieve sequential file, handle="MI1001_befitxup.605_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <MI1001_befitxup.605_1> not found in NetBackup catalog failover to previous backup Any idea Thanks PeterSolved3.8KViews1like9CommentsORACLE media needed - based on RMAN bk value
I know I can run a command to see what media I need to restore an oracle backup, using commands like this: bpimagelist -media -U -d 04/10/2010 -e 04/12/2010 -policy "RMAN.POLICY.NAME" | sort -k1n My oracle DBA want to find which media are needed for a specific RMAN piece designated in THEIR logs as this: bk_153767_1_660546245 I used to be able to run this command on the source client: bpclntcmd -ml /bk_153767_1_660546245 -ct Oracle -s 01/01/10 with output like this: 1 1 001328 Which would tell me that tape 001328 had the data. This command is not working for me anymore - does anyone have any thoughts on how to generate the media the data is on? Thanks! NBU 6.5.4 on Solaris 10 writing to EMC 4206 VTL duplicating to LTO2 in SL8500 ACSLS 7.3.0Solved1.3KViews1like4Comments