RMAN restore failing with ORA-27191: sbtinfo2 returned error
Hello, The DBAs are doing an RMAN restore which was taken on server 1 seprdu05. They are trying to restore on server 2 seppuu03. Both clients are Solaris 10 machines with oracle database 11.2.0. The master server is RHEL 5.9. The netbackup master server version is 7.5.0.7 The netbackup client version is 7.5.0.4 The error is as below: Oracle instance shut down RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/16/2015 06:57:26 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-27191: sbtinfo2 returned error Additional information: 3480 On the client, nothing is reported in the netbackup logs: /usr/openv/netbackup/logs/user_ops/dbext/logs/ It seems that the error "Additional information: 3480" would come from the MML (Media Manager Layer). Is there any logs on the master server that could give more details wether the RMAN job has interacted with netbackup so far? Any sugestion would be very helpful.27KViews0likes4Comments
Oracle restore: ORA-19573: cannot obtain exclusive enqueue for datafile
**** Moved to new discussion from:https://www-secure.symantec.com/connect/forums/reg-oracle-db-backup**** i am getting the below error when try to restore ...kindly help me com09:oracle # /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh com09:oracle # cat database_restore.sh.out Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== started on Sun Aug 17 16:39:17 UTC 2014 ==== RMAN: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0/bin/rman ORACLE_SID: plxdb ORACLE_USER: oracle ORACLE_HOME: /opt/PlexView/Oracle/ora01/app/oracle/product/11.2.0 Last login: Sun Aug 17 16:38:47 UTC 2014 Recovery Manager: Release 11.2.0.1.0 - Production on Sun Aug 17 16:39:17 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: PLXDB (DBID=3747984712) using target database control file instead of recovery catalog RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> allocated channel: ch00 channel ch00: SID=28 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2013061020) allocated channel: ch01 channel ch01: SID=129 device type=SBT_TAPE channel ch01: Veritas NetBackup for Oracle - Release 7.5 (2013061020) Starting restore at 17-AUG-14 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00005 to /opt/PlexView/Oracle/ora02/oradata/plxdb/audit_data.dbf channel ch00: restoring datafile 00006 to /opt/PlexView/Oracle/ora02/oradata/plxdb/cfma01.dbf channel ch00: restoring datafile 00008 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_indx.dbf channel ch00: restoring datafile 00009 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_data.dbf channel ch00: restoring datafile 00010 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es128k_indx.dbf channel ch00: reading from backup piece bk_84_1_855851605 channel ch01: starting datafile backup set restore channel ch01: specifying datafile(s) to restore from backup set channel ch01: restoring datafile 00001 to /opt/PlexView/Oracle/ora02/oradata/plxdb/system01.dbf channel ch01: restoring datafile 00002 to /opt/PlexView/Oracle/ora02/oradata/plxdb/sysaux01.dbf channel ch01: restoring datafile 00003 to /opt/PlexView/Oracle/ora02/oradata/plxdb/undotbs01.dbf channel ch01: restoring datafile 00004 to /opt/PlexView/Oracle/ora02/oradata/plxdb/users01.dbf channel ch01: restoring datafile 00007 to /opt/PlexView/Oracle/ora02/oradata/plxdb/tablespace_es4m_data.dbf channel ch01: reading from backup piece bk_85_1_855851606 released channel: ch00 released channel: ch01 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/17/2014 16:39:27 ORA-19870: error while restoring backup piece bk_84_1_855851605 ORA-19573: cannot obtain exclusive enqueue for datafile 6 RMAN> RMAN> Recovery Manager complete. Last login: Sun Aug 17 16:38:47 UTC 2014 Script /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh ==== ended in error on Sun Aug 17 16:39:27 UTC 2014 ==== com09:oracle # regards, GiriSolved13KViews2likes6Commentsbptestbpcd: EXIT status = 25 cannot connect on socket
I'm currently runnning NB 7.5.0.4. I'm getting the "bptestbpcd: EXIT status = 25 cannot connect on socket" error when running the commands as specified by Symantec. I'm able to resolve from the master/media server (which is the same) see below C:\Program Files\Veritas\NetBackup\bin>bpclntcmd -hn hcndc02 host hcndc02: hcndc02 at 192.168.100.226 aliases: hcndc02 192.168.100.226 However I get the following when running the command and checking the logs 16:35:39.583 [3948.3296] <2> bpcd main: accept sock = 380 16:35:39.598 [3660.3528] <2> setup_debug_log: switched debug log file for bpcd 16:35:39.598 [3660.3528] <2> bpcd main: VERBOSE = 0 16:35:39.598 [3660.3528] <2> logparams: C:\Program Files\Veritas\NetBackup\bin\bpcd.exe -standalone 16:35:39.598 [3660.3528] <2> process_requests: offset to GMT 18000 16:35:39.614 [3660.3528] <2> logconnections: BPCD ACCEPT FROM 192.168.100.226.61837 TO 192.168.100.226.13782 fd = 380 16:35:39.614 [3660.3528] <2> process_requests: setup_sockopts complete 16:35:39.614 [3660.3528] <2> bpcd peer_hostname: Connection from host HCNDC02.hcnetwork.org (192.168.100.226) port 61837 16:35:39.614 [3660.3528] <2> bpcd valid_server: comparing hcntape01 and HCNDC02.hcnetwork.org 16:35:39.614 [3660.3528] <4> bpcd valid_server: HCNDC02.hcnetwork.org is not a master server 16:35:39.614 [3660.3528] <16> bpcd valid_server: HCNDC02.hcnetwork.org is not a media server either 16:35:39.614 [3660.3528] <2> process_requests: output socket port number = 3291 16:35:39.614 [3660.3528] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1583] in failed file cache ERR=10109 NAME=NULL SVC=testdaemon 16:35:39.614 [3660.3528] <8> vnet_cached_get_service_port: [vnet_addrinfo.c:2387] vnet_cached_getaddrinfo failed STAT=6 RV=10109 NAME=testdaemon 16:35:39.614 [3660.3528] <8> is_pbxable_service: [vnet_connect.c:2159] vnet_cached_get_service_port() failed 6 0x6 16:35:39.614 [3660.3528] <8> is_pbxable_service: [vnet_connect.c:2160] service 3291 16:35:39.614 [3660.3528] <8> file_to_cache_item: [vnet_addrinfo.c:6555] fopen() failed ERRNO=2 FILE=C:\Program Files\Veritas\NetBackup\var\host_cache\189\fcd93f89+3291,1,400,2,1,0+192.168.100.226.txt 16:35:39.614 [3660.3528] <2> process_requests: <---- NetBackup 7.5 0 ------------initiated 16:35:39.614 [3660.3528] <2> process_requests: VERBOSE = 0 16:35:39.614 [3660.3528] <2> bpcd exit_bpcd: exit status 46 ----------->exiting 16:35:39.614 [3660.3528] <4> bpcd exit_bpcd: FTL - BPCD EXIT STATUS 46 16:35:39.614 [3660.3528] <16> process_requests: Server access denied 16:35:39.614 [3948.3296] <2> bpcd main: accept sock = 380 16:35:39.645 [2428.3596] <2> setup_debug_log: switched debug log file for bpcd 16:35:39.645 [2428.3596] <2> bpcd main: VERBOSE = 0 16:35:39.645 [2428.3596] <2> logparams: C:\Program Files\Veritas\NetBackup\bin\bpcd.exe -standalone 16:35:39.645 [2428.3596] <2> process_requests: offset to GMT 18000 16:35:39.645 [2428.3596] <2> logconnections: BPCD ACCEPT FROM 192.168.100.226.61839 TO 192.168.100.226.13782 fd = 380 16:35:39.645 [2428.3596] <2> process_requests: setup_sockopts complete 16:35:39.645 [2428.3596] <2> bpcd peer_hostname: Connection from host HCNDC02.hcnetwork.org (192.168.100.226) port 61839 16:35:39.645 [2428.3596] <2> bpcd valid_server: comparing hcntape01 and HCNDC02.hcnetwork.org 16:35:39.645 [2428.3596] <4> bpcd valid_server: HCNDC02.hcnetwork.org is not a master server 16:35:39.645 [2428.3596] <16> bpcd valid_server: HCNDC02.hcnetwork.org is not a media server either 16:35:39.645 [2428.3596] <2> process_requests: output socket port number = 1224 16:35:39.645 [2428.3596] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1583] in failed file cache ERR=10109 NAME=NULL SVC=testdaemon 16:35:39.645 [2428.3596] <8> vnet_cached_get_service_port: [vnet_addrinfo.c:2387] vnet_cached_getaddrinfo failed STAT=6 RV=10109 NAME=testdaemon 16:35:39.645 [2428.3596] <8> is_pbxable_service: [vnet_connect.c:2159] vnet_cached_get_service_port() failed 6 0x6 16:35:39.645 [2428.3596] <8> is_pbxable_service: [vnet_connect.c:2160] service 1224 16:35:39.645 [2428.3596] <8> file_to_cache_item: [vnet_addrinfo.c:6555] fopen() failed ERRNO=2 FILE=C:\Program Files\Veritas\NetBackup\var\host_cache\189\fcd93f89+1224,1,400,2,1,0+192.168.100.226.txt 16:35:39.645 [2428.3596] <2> process_requests: <---- NetBackup 7.5 0 ------------initiated 16:35:39.645 [2428.3596] <2> process_requests: VERBOSE = 0 16:35:39.645 [2428.3596] <2> bpcd exit_bpcd: exit status 46 ----------->exiting 16:35:39.645 [2428.3596] <4> bpcd exit_bpcd: FTL - BPCD EXIT STATUS 46 16:35:39.645 [2428.3596] <16> process_requests: Server access denied Any help with this will be highly appreciated ThanksSolved11KViews1like18Comments
ORACLE RMAN BACKUP Configuration
Hi I am trying to configure RMAN backup. Followed below mentioned steps: 1. Created Backup policy on master server for RMAN backup--- Shell script path is mentioned in Backup selection. And selected traget unit as LTO3 tape drive. 2. Shell script is prepared on client for RMAN backup But still I am getting Error (6). Sharing the script fyi: ORACLE_HOME=/oracle/product/10.2.0/db_1 PATH=$ORACLE_HOME/bin:$PATH ORACLE_SID=crm export ORACLE_HOME PATH ORACLE_SID rman << EOF connect target sys/sys run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; configure controlfile autobackup on; configure controlfile autobackup format for device type 'SBT_TAPE' ; backup database plus archivelog; BACKUP CURRENT CONTROLFILE ; release channel ch00; } EOF The problem here is this script run with oracle login perfectly and failed when trying to tun through backup policy. Also sharing logs i found in /usr/openv/netbackup/logs/bphdb cat obk_stdout.090610 Recovery Manager: Release 10.2.0.4.0 - Production on Mon Sep 6 14:31:07 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. RMAN> RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-01031: insufficient privileges RMAN> 2> 3> 4> 5> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "clear, to" RMAN-01007: at line 5 column 68 file: standard input RMAN> Starting backup at 06-SEP-10 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup plus archivelog command at 09/06/2010 14:31:08 RMAN-06171: not connected to target database RMAN> Starting backup at 06-SEP-10 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 09/06/2010 14:31:08 RMAN-03014: implicit resync of recovery catalog failed RMAN-06171: not connected to target database RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "identifier": expecting one of: ";" RMAN-01008: the bad identifier was: ch00 RMAN-01007: at line 1 column 17 file: standard input RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 1 column 21 file: standard input RMAN> RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate" RMAN-01007: at line 1 column 1 file: standard input RMAN> RMAN> Recovery Manager complete. and cat log.090610 14:31:07.247 [22299] <2> logparams: -sb -rdbms oracle -S backupmaster -to 1500 -c ORACLE-RMAN -s Full -clnt backupmedia01 -FULL -kl 28 -b backupmedia01_1283763604 -jobid 21671 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_POLICY=ORACLE-RMAN 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CLIENT=backupmedia01 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_MODE=B 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_POLICY=ORACLE-RMAN 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SCHED not defined. 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_SCHED=Full 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SERV=backupmaster 14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_BTYPE not set 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_FULL=1 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_INCR=0 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CINC=0 14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_SCHEDULED=1 14:31:07.252 [22299] <4> bphdb sync_server: INF - BACKUP START 14:31:07.319 [22299] <4> bphdb sync_server: INF - CONTINUE BACKUP message received. 14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: </oracle/script/FULLBKP-CRM.sh> 14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: <CONTINUE> 14:31:07.319 [22299] <4> bphdb do_backup: INF - Processing /oracle/script/FULLBKP-CRM.sh 14:31:07.322 [22299] <4> bphdb keepalive_timeout: INF - bphdb still working. 14:31:07.322 [22299] <2> bphdb keepalive_timeout: INF - bphdb- Sending a keepalive. 14:31:07.323 [22299] <4> bphdb do_backup: INF - Keepalives will be sent every 750 seconds. 14:31:07.323 [22299] <4> bphdb do_backup: INF - Waiting for the child status. 14:31:07.325 [22301] <4> bphdb do_backup: INF - Child executing /oracle/script/FULLBKP-CRM.sh 14:31:08.753 [22299] <16> bphdb do_backup: ERR - Script exited with status = 1 <the requested operation was partially successful> 14:31:08.765 [22299] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files 14:31:08.765 [22299] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files Pls post your valuable input. Thanks & Regards,Solved11KViews1like15Comments
The RMAN restores are failing with "Backup file not found in Netbackup catalog"
The RMAN restores are failing withthe below error: ========================= channel t5: ORA-19870: error while restoring backup piece PROD_17769_1 ORA-19507: failed to retrieve sequential file, handle="PROD_17769_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <PROD_17769_1> not found in NetBackup catalog ========================= I am using below scripts for restoring control files, Earlier these scripts were working fine but now having issue: ========================= RUN { set DBID 25331020; SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'ERPPROD%F'; allocate channel t1 type SBT_TAPE parms='ENV=(NB_ORA_POLICY=PROD_ERP_RMAN,NB_ORA_SERV=qfb00001,NB_ORA_CLIENT=qfa00025.qf.org.qa)'; restore controlfile from autobackup maxdays=3; release channel t1; } RUN { set DBID 25331020; allocate channel t1 type SBT_TAPE parms='ENV=(NB_ORA_POLICY=PROD_ERP_RMAN,NB_ORA_SERV=qfb00001,NB_ORA_CLIENT=QFA00025)'; restore controlfile from "ERPPRODc-25331020-20140917-01"; release channel t1; } ========================= The script used for backup is as below: ========================= run { sql 'alter session set optimizer_mode=RULE'; allocate channel t1 type SBT MAXPIECESIZE 50G; allocate channel c1 type SBT MAXPIECESIZE 50G; allocate channel t2 type SBT MAXPIECESIZE 50G; allocate channel c2 type SBT MAXPIECESIZE 50G; allocate channel t3 type SBT MAXPIECESIZE 50G; BACKUP DATABASE format'%d_%s_%p' TAG=PRODFULLBKP; sql 'alter system archive log current'; BACKUP ARCHIVELOG FROM TIME 'SYSDATE-2' UNTIL TIME 'SYSDATE' format 'arc_%d_%s_%p' TAG=PRODARCHIVELOG; BACKUP current controlfile format 'ERPPRODc%f' TAG=CTRLFILE; crosscheck backup; crosscheck archivelog all; delete noprompt archivelog all completed before 'sysdate-5'; release channel t1; release channel c1; release channel t2; release channel c2; release channel t3; } ========================= i am attaching the list backup of controlfile Can anyone help...? ThanksSolved8.8KViews0likes4Comments
Backups were failing with 84 & 87 error intermittently - Destination Storage is Pure Disk Pool
Backups were failing with 84 & 87 error intermittently - Destination Storage is Pure Disk Pool Again the same backup is getting suuccessful in the next successive using different job ID Error Code: 84 *************************************************************************************************************************************** 12/25/2014 00:10:07 - Info bpbrm (pid=13539) INF - Client read timeout = 1800 12/25/2014 00:10:07 - connecting 12/25/2014 00:10:08 - Info bpbrm (pid=13539) accepted connection from client 12/25/2014 00:10:08 - Info dbclient (pid=4951) Backup started 12/25/2014 00:10:08 - Info bpbrm (pid=13539) bptm pid: 13540 12/25/2014 00:10:08 - Info bptm (pid=13540) start 12/25/2014 00:10:08 - Info bptm (pid=13540) using 524288 data buffer size 12/25/2014 00:10:08 - Info bptm (pid=13540) setting receive network buffer to 524288 bytes 12/25/2014 00:10:08 - Info bptm (pid=13540) using 256 data buffers 12/25/2014 00:10:08 - connected; connect time: 0:00:00 12/25/2014 00:10:10 - Info bptm (pid=13540) start backup 12/25/2014 00:12:17 - Info bptm (pid=13540) backup child process is pid 16293 12/25/2014 00:12:17 - begin writing 12/25/2014 00:12:18 - Info dbclient (pid=4951) dbclient(pid=4951) wrote first buffer(size=262144) 12/25/2014 00:13:02 - Critical bptm (pid=13540) Storage Server Error: (Storage server: PureDisk:) mtstrm_write_segment: Fatal error occured in Multi-Threaded Agent: Cr_ErrnoException in void mtstrm::server::Cr_Send::ThreadSend(Pd_Thread<mtstrm::server::Cr_Send>*): CRSegmentBatchStreamPutComp V-454-95 12/25/2014 00:13:02 - Critical bptm (pid=13540) image write failed: error 2060001: one or more invalid arguments 12/25/2014 00:13:04 - Critical bptm (pid=13540) Storage Server Error: (Storage server: PureDisk:) mtstrm_close_write_channel: Fatal error occured in Multi-Threaded Agent: Cr_ErrnoException in void mtstrm::server::Cr_Send::ThreadSend(Pd_Thread<mtstrm::server::Cr_Send>*): CRSegmentBatchStreamPutComp V-454-96 12/25/2014 00:13:04 - Critical bptm (pid=13540) sts_close_handle failed: 2060001 one or more invalid arguments 12/25/2014 00:13:16 - Error bptm (pid=13540) cannot write image to disk, Invalid argument 12/25/2014 00:13:16 - Info bptm (pid=13540) EXITING with status 84 <---------- 12/25/2014 00:13:16 - Info dbclient (pid=4951) done. status: 6 12/25/2014 00:13:16 - Info (pid=13540) StorageServer=PureDisk:; Report=PDDO Stats (multi-threaded stream used) for (): scanned: 49667 KB, CR sent: 0 KB, CR sent over FC: 0 KB, dedup: 100.0%, cache disabled 12/25/2014 00:13:17 - Info dbclient (pid=4951) done. status: 84: media write error 12/25/2014 00:13:17 - end writing; write time: 0:01:00 media write error (84) *************************************************************************************************************************************** Error Code: 87 *************************************************************************************************************************************** 12/25/2014 00:12:23 - Info bpbrm (pid=7499) INF - Client read timeout = 1800 12/25/2014 00:12:23 - Info bpbrm (pid=7499) accepted connection from client 12/25/2014 00:12:24 - Info dbclient (pid=736) Backup started 12/25/2014 00:12:24 - connected; connect time: 0:00:00 12/25/2014 00:12:24 - Info bpbrm (pid=7499) bptm pid: 7500 12/25/2014 00:12:24 - Info bptm (pid=7500) start 12/25/2014 00:12:24 - Info bptm (pid=7500) using 524288 data buffer size 12/25/2014 00:12:24 - Info bptm (pid=7500) using 256 data buffers 12/25/2014 00:12:26 - Info bptm (pid=7500) start backup 12/25/2014 00:17:02 - Info bptm (pid=7500) backup child process is pid 17130 12/25/2014 00:17:02 - begin writing 12/25/2014 00:17:03 - Info dbclient (pid=736) dbclient(pid=736) wrote first buffer(size=65536) 12/25/2014 00:17:04 - Info dbclient (pid=736) done. status: 0 12/25/2014 00:18:56 - Info bptm (pid=7500) waited for full buffer 1 times, delayed 71 times 12/25/2014 00:18:59 - Critical bptm (pid=7500) Storage Server Error: (Storage server: PureDisk:) mtstrm_close_write_channel: Fatal error occured in Multi-Threaded Agent: Close Write Channel command failed: Cr_ErrnoException: dref model has not been initialized yet V-454-96 12/25/2014 00:19:00 - Critical bptm (pid=7500) sts_close_handle failed: 2060017 system call failed 12/25/2014 00:19:00 - Error bptm (pid=7500) cannot write image to disk, media close failed with status 2060017 12/25/2014 00:19:05 - Info bptm (pid=7500) EXITING with status 87 <---------- 12/25/2014 00:19:05 - Info (pid=7500) StorageServer=PureDisk:; Report=PDDO Stats (multi-threaded stream used) for (): scanned: 4835 KB, CR sent: 0 KB, CR sent over FC: 0 KB, dedup: 100.0%, cache disabled 12/25/2014 00:20:13 - Info dbclient (pid=736) done. status: 87: media close error 12/25/2014 00:20:13 - end writing; write time: 0:03:11 media close error (87) *************************************************************************************************************************************** Also attached the error part in the bptm log from media server Client Read & Connect timeout for the respective Media servers - 1800 sec IS it due to any DPS/Timeout polling time out issue or any other issue ?Solved8.7KViews0likes5CommentsCan't restore from RMAN backup
Hi Everyone! I can't restore from my RMAN backups. RMAN> run 2> { 3> host "date"; 4> allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NB_ORA_CLIENT=vs-oa00-01b.hosting.local,NB_ORA_POLICY=Oracle_Prod_Policy,NB_ORA_SERV=ps-bcp00-01a.hosting.local,NB_ORA_SCHED=Default-Application-Backup)"; 5> restore controlfile to '/u01/app/control01.ctl' from tag 'TAG20120926T053022'; 6> release channel t1 ; host "date"; 7> 8> } Wed Sep 26 17:32:27 MSK 2012 host command complete allocated channel: t1 channel t1: SID=551 instance=skdbse2 device type=SBT_TAPE channel t1: Veritas NetBackup for Oracle - Release 7.5 (2012020807) Starting restore at 26-SEP-12 channel t1: starting datafile backup set restore channel t1: restoring control file output file name=/u01/app/control01.ctl channel t1: reading from backup piece c-1341750022-20120926-02 channel t1: ORA-19870: error while restoring backup piece c-1341750022-20120926-02 ORA-19507: failed to retrieve sequential file, handle="c-1341750022-20120926-02", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <c-1341750022-20120926-02> not found in NetBackup catalog failover to previous backup released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 09/26/2012 17:32:41 RMAN-06026: some targets not found - aborting restore RMAN-06024: no backup or copy of the control file found to restore RMAN>Solved6.9KViews1like7Comments
Error bprd (pid=23535) Unable to write progress log </C/ProgramÀ Files/Veritas/NetBackup/Logs/user_ops/dbext/logs/....
Hi, I have a problem trying a Oracle Data Base backup. The error message the backup takes is: 19-nov-2010 11 - Error bprd (pid=23535) Unable to write progress log </C/ProgramÀFiles/Veritas/NetBackup/Logs/user_ops/dbext/logs/4804.0.1290163054> on client xxxxxxx Policy=xxx-xxx.xxx.xxx.xxxxxxxx Sched=xxx-xxx.xxx I have checked allcommandto find problems whit the network buteverything works fine. The master serverand media server connect with the client correctly. The automatic scheduler starts the script and so the RMAN function : connected to target database: ORCL (DBID=1023686199) using target database controlfile instead of recovery catalog RMAN> old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> allocated channel: ch00 channel ch00: sid=12 devtype=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 6.5 (20070723) sent command to channel: ch00 Starting backup at 2010-11-19:12:03:03 channel ch00: starting incremental level 0 datafile backupset channel ch00: specifying datafile(s) in backupset including current controlfile in backupset input datafile fno=00001 name=E:\ORADATA\ORCL\SYSTEM01.DBF input datafile fno=00006 name=E:\ORADATA\ORCL\SYSTEM02.DBF input datafile fno=00007 name=E:\ORADATA\ORCL\USERDATA01.DBF input datafile fno=00008 name=E:\ORADATA\ORCL\INDEX01.DBF input datafile fno=00009 name=E:\ORADATA\ORCL\UNDOTBS02.DBF input datafile fno=00002 name=E:\ORADATA\ORCL\UNDOTBS01.DBF input datafile fno=00003 name=E:\ORADATA\ORCL\INDX01.DBF input datafile fno=00005 name=E:\ORADATA\ORCL\USERS01.DBF input datafile fno=00004 name=E:\ORADATA\ORCL\TOOLS01.DBF channel ch00: starting piece 1 at 2010-11-19:12:03:04 The policy uses full backup because oracle is a Standard edition and incremental is not supported. For me netbackup finds a bad character (A) in folder</C/ProgramÀFiles/.... I've already checked the folder permissions on the logs folder and Everyone has full control. We are running netbackup client6.5 and netbackup master server 7.0.1 thanks to all will help me.Solved6.6KViews0likes12Comments
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.3KViews0likes7Comments
Backing up Oracle databases configured using Data Guard
Ok, so I'm not huge into Netbackup (NBU), or Oracle, but our backup group has been dragged into issue, and I have been recruited to help solve it. We are running NetBackup 7.6.0.1. Its going mostly well. We are doing file level backups successfully, and oracle backups successfully using our RMAN catalog and such. However, we have recently been tasked to back up an Oracle database that has been configured with data guard. This means this: There are two databases, with two different SIDs The databases are identical, configured as such that if one database fails, the other database covers as a failover database One database is the Primary database, and one is set as the Standby database We have NetBackup set up to backup both databases. When the backups run, the Primary database succeeds with no issues. The secondary database fails with (5407) Database is in the wrong state (must be OPEN) for the requested action So, here are the difficulties: Netbackup requires an instance name when setting up a oracle instance for backup - which should be equal to the SID. We could just rely on our TNSNAMES.ora file to connect to the proper instance, but since NBU requires the SID when setting up the instance, and the primary and standby databases have different SIDs we cannot rely on the TNSNAME alone We don't manage the databases set up in the data guard configuration, so there is no way to tell if a failover event occurs until we get a failed backup on the main backup, which is not ideal There should be a way to have one policy in NetBackup that covers this Oracle DB setup. We should be able to back up whatever database is currently the "Primary" without worrying about ORACLE_SIDs. Let me know if I need to provide more info for this issue to be discussed.Solved5.9KViews1like8Comments
RMAN restore failing with ORA-27191: sbtinfo2 returned error
Hello, The DBAs are doing an RMAN restore which was taken on server 1 seprdu05. They are trying to restore on server 2 seppuu03. Both clients are Solaris 10 machines with oracle database 11.2.0. The master server is RHEL 5.9. The netbackup master server version is 7.5.0.7 The netbackup client version is 7.5.0.4 The error is as below: Oracle instance shut down RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/16/2015 06:57:26 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-27191: sbtinfo2 returned error Additional information: 3480 On the client, nothing is reported in the netbackup logs: /usr/openv/netbackup/logs/user_ops/dbext/logs/ It seems that the error "Additional information: 3480" would come from the MML (Media Manager Layer). Is there any logs on the master server that could give more details wether the RMAN job has interacted with netbackup so far? Any sugestion would be very helpful.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. Thanks