Error bpbrm: listen for client timeout during accept from data listen socket after 60 seconds
I keep receiving the error message in the title even though I have gone through and set my timeout settings to at least 900 seconds. I have also run all the bpclntcmd commands and all of them return appropriately. Is the 60 second timeout referred to in the error message a client side OS setting? I am running Red-Hat 5. Thanks6.4KViews0likes7CommentsRMAN CROSSCHECK EXPIRED EXISTING BACKUPPIECE.
Hi expert, I already search this forum and cannot find topic matching this case. Recently we have found the problem that some of backuppiece was expired after running weekly crosscheck script. Environment Master Server: netbackup Media Server: cvgdb01_back, cvgdb02_back Oracle Client: cvgdb01_back, cvgdb02_back Option Used: SSO, OracleClient, Online backup using rman archivelog mode and remote recovery catalog Retention: level9 infinite for netbackup , recovery window of 90 days for rman recovery catalog We use 'Failover VIP is not available and backup is load balanced, simple script with manual policy failover' from Symantec Document to protect the RAC database. I already open case (03367265) to support but no luck. Weekly Crosscheck script is below. $RMAN target $constr catalog $cat msglog $RMAN_LOG_FILE append << EOF allocate channel for maintenance type 'sbt_tape'; delete noprompt obsolete; delete noprompt obsolete orphan; crosscheck backupset of database; crosscheck backupset of controlfile; crosscheck backupset of archivelog all; EOF " Some backup piece that was expired. BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 1167774 2.00M SBT_TAPE 00:00:50 16-JAN-13 BP Key: 1167782 Status: EXPIRED Compressed: NO Tag: TAG20130116T222337 Handle: al_10324_1_804897076 Media: List of Archived Logs in backup set 1167774 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 4326 166048694612 16-JAN-13 166048827449 16-JAN-13 Used bplist to search backupid. /usr/openv/netbackup/bin/bplist -C cvgdb02_back -Listpolicy -Listseconds -t 4 /al_10324_1_804897076 | awk '{print $14}' 1358350282 Used bpimagelist to search mediaid. /usr/openv/netbackup/bin/admincmd/bpimagelist -media -l -option COMPLETE_COPIES -backupid cvgdb02_back_1358350282 | awk '/FRAG/ {print $9}' 000125 This is occur on production database when I try to redirect restore production RAC database to development database server so please help us!!! Thanks, NawaminSolved6.3KViews0likes2CommentsNetBackup: 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.8KViews1like9CommentsUpgrade 6.5 to NETBACKUP 7.5
In my LIVE Env, i have SUN machine SPARC Entry Server. NetBackup 6.5 master/media on it. Requirement is to upgrade it to 7.5 Master/Media and clients ORACLE RMAN Backups on solaris machines. kindly correct me if i am wrong. the steps i will follow are: 1) Download NBU 7 media 2) down NBU Services on live machine 3) Apply 7.0, up Netbackup services. 4) download 7.5 media 5) Apply 7.5 and up services. ------------------------------------------------ Master Media upgraded. now to upgrade the client for 7.5. steps needed. HOT backups are configured for ORACLE RMAN. Does linking again needed to be performed ? ? ?Solved2KViews0likes6CommentsCopilot for oracle rac
I tried with unsuccessful attempts to put Copilot to work, I have a single Appliance 5230 2.7.3(Netbackup 7.7.3) whose role is both master,media the scenario is I wanted to configure DUMP and Sweep function mounting nfs share on one of 2 Oracle RAC node (11.2.0.4) run into issues "Database is in the wrong state (must be OPEN) for the requested action" however that is not the case. I tried many things to make it work with no success . I am at verge of giving this up, the documentation around this ok but there no white papers or case study with troubleshooting contents published. I had an idea wanted the SME to shed some insight on this, if this strategy is ok or lame. As I have nfs share from appliance mounted on one of the Oracle RAC node, the scheduled Rman script backs up the database to the nfs share , next I will creat standard policy for File system backup from nfs share. I know the essence of Oracle Copilot is lost with No SLP configured, however I will have something to work with until I fix this. Let me know what you folks feedback on this. Thanks much in advance for your time. Regard/Hissam EX: RAC1 node with nfs share 1 TB mounted on /oracle mp.1.8KViews0likes5CommentsBackup 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.6KViews1like6CommentsBackups for Oracle RAC running twice
Hi All, We having issues with Oracle RAC invirovment backups, it's always dublicating. It was working, and did load balance between nodes, but i did created new policy with same configuration and now it's running twice. Client and server running on 8.0 NetBackup version. Attaching script and configuration screenshotsSolved1.3KViews0likes4CommentsORACLE 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.3KViews1like4CommentsOracle 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.1KViews2likes5Comments