Oracle

78 Topics

Netbackup Questions for level 1 and level 2
Hi All, Kindly share the netbackup administrator interview questions for L1 and L2 engineer. If any one have link kindly share. Netbackup 6.5 and 7.0 And also, share the all documetns link for netbackup7.0 Thanks and Regds, Sagar
Solved
Sagar_Kolhe
13 years ago Place NetBackup
22KViews
3likes
7Comments
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,
Solved
Anish
14 years ago Place NetBackup
11KViews
1like
15Comments
Netbackup does not clean expired images
Hello everyone. We have Netbackup7.0 installed on Redhat 5.5. For this moment we are only using NB to perform Oracle database backups. The everyday backup works good but we have problem with removing expired images. I have retention set to 1 week but I have images older than 2 week. At first the image cleanup did not start itself than I tried thishttp://www.symantec.com/business/support/index?page=content&id=TECH125429and now I can see cleanup job running automatically in activity monitor, but it doesn't delete the expired ones I guess for some reasons cleanup job thinks it's not expired. 02/10/2012 15:50:36 - Info bpdbm (pid=4078) image catalog cleanup 02/10/2012 15:50:36 - Info bpdbm (pid=4078) Cleaning up tables in the relational database 02/10/2012 15:50:36 - Info bpdbm (pid=4078) deleting images which expire before Fri Feb 10 15:50:36 2012 (1328874636) 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test1 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test2 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test3 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test4 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test5 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test6 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test7 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test8 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test9 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test10 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test11 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test12 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test13 02/10/2012 15:50:36 - Info bpdbm (pid=4078) processing client test14 02/10/2012 15:50:36 - Info bpdbm (pid=4078) deleted 0 expired records, compressed 0, tir removed 0, deleted 0 expired copies the requested operation was successfully completed (0) This particular log created when I manually initiate image cleanup job (/usr/openv/netbackup/bin/admincmd/bpimage -cleanup -allclients) I just did it and I have 8 days of backup for now. Can someone tell me how can I see the list of backups that netbackup considers that It's expired ? Thanks for you'r time P.s I will provide additional information Ifnecessary
Solved
freax
13 years ago Place NetBackup
8.8KViews
1like
11Comments
Rman - bphdb exit status = 29: failed trying to exec a command
Hello, i have a problem with Oracle Rman (Oracle 11G R2) backup with Netbackup 7.1.0.3. I created a template with the wizard (Backup , archive, restore) on the client. When i launch a Manual Backup from my master server i have this : 20/09/2012 17:13:38 - Info nbjm(pid=9652) started backup job for client ora11g-rman.*****.com, policy Oracle, schedule SCH_FULL on storage unit ****** 20/09/2012 17:13:41 - started process bpbrm (4948) 20/09/2012 17:13:54 - Info bpbrm(pid=4948)ora11g-rman.*****.comis the host to backup data from 20/09/2012 17:13:54 - Info bpbrm(pid=4948) reading file list from client 20/09/2012 17:13:54 - connecting 20/09/2012 17:13:57 - connected; connect time: 00:00:03 20/09/2012 17:13:58 - Info bpbrm(pid=4948) starting bphdb on client 20/09/2012 17:13:59 - Info bphdb(pid=1580) Backup started 20/09/2012 17:13:59 - Info bphdb(pid=1580) Database validation buffer = :DBNAME:ORACLE:DBHOME:d:\oracle\product\11.2.0\dbhome_1:DBNETNAME:oracle 20/09/2012 17:13:59 - Info bphdb(pid=1580) DBNAME=ORACLE DBHOME=d:\oracle\product\11.2.0\dbhome_1 DBNETNAME=oracle DBTEMPLATENAME=fullbackuptest1.tpl 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - failed executing command <"C:\Program Files\Veritas\NetBackup\bin\bpdbsbora.exe" -backup -rw -t "fullbackuptest1.tpl"> 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - exit status: <1> 20/09/2012 17:15:34 - Error bpbrm(pid=4948) from clientora11g-rman.*****.com: ERR - bphdb exit status = 29: failed trying to exec a command 20/09/2012 17:15:36 - end writing failed trying to exec a command(29) This is my scriptfullbackuptest1.tpl : #^oracle template configuration file <<MUST BE FIRST IN FILE, DO NOT REMOVE>> # ----------------------------------------------------------------- # Veritas NetBackup for oracle: Backup Configuration Template # $VRTScprght: Copyright 1993 - 2011 Symantec Corporation, All Rights Reserved $ # # Description: test # Template level: 1.9.0 # Generated on: 09/19/12 15:29:07 # ----------------------------------------------------------------- TEMPLATE_ID1=16973 TEMPLATE_ID2=1605 TEMPLATE_OWNER=aasif # ----------------------------------------------------------------- # BACKUP_TYPE is derived from the schedule type when this script # is used in a NetBackup scheduled backup. For example, when: # schedule type is BACKUP_TYPE is # ---------------- -------------- # Automatic Full INCREMENTAL LEVEL=0 # Automatic Differential Incremental INCREMENTAL LEVEL=1 # Automatic Cumulative Incremental INCREMENTAL LEVEL=1 CUMULATIVE # # For a non-proxy user initiated backup, BACKUP_TYPE is defined as shown. # ----------------------------------------------------------------- BACKUP_TYPE=INCREMENTAL LEVEL=0 ORACLE_HOME=d:\oracle\product\11.2.0\dbhome_1 ORACLE_SID=ORACLE TARGETDB_LOGIN=SYS as sysdba TARGETDB_PASSWD=000a333eb56d86*****************64cadc37449028c9f61234a28b91592ab35b42155e3e40a********ed3366874ab TARGETDB_TNSNAME=oracle CATALOG_LOGIN=rman CATALOG_PASSWD=3d151364860bd4d8dfe741035b33****************2e48969a32ce1f1e142e11176fec5*********09e82d09159 CATALOG_TNSNAME=oracle # ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=ora11g-rman.*****.com,NB_ORA_SID=ORACLE,NB_ORA_POLICY=Oracle,NB_ORA_SERV=mymasterserver.*****.com,NB_ORA_SCHED=Oracle'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'BACKUP_%T-%s-%U' DATABASE; RELEASE CHANNEL ch00; } Mybphdb log is attached on this topic Please can you help me? Thank you
Aasif75
12 years ago Place NetBackup
7.4KViews
0likes
13Comments
Can'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>
Solved
Alex_al
12 years ago Place NetBackup
6.9KViews
1like
7Comments
bplist shows control file backup but rman "restore controlfile" fails with file not found
OK, I am trying to restore an Oracle database froma TOTALLY complicated setup and really need some help. Overview: My production Oracle database server is actually a pair of Solaris servers running Symantec HA with one node active and one node in standby. My backups are scheduled through NetBackup which calls an OracleRMAN script to backup the databases. Full database backups are generated every night and archive log backups are run at noon and 6:00 PM. Backups go to a pair of DataDomain devices, one in my primary datacenter and one at my disaster recovery site. At my disaster recovery site, I have a single Solaris server as a database server. Finally, I have an Oracle RMAN catalog that runs on a Windows server. This catalog is shut down twice a day and a Windows backup of just the RMAN directory is made, again to the DataDomain devices. Now, I am testing my disaster recovery. We have stopped the replication between the local and remote DataDomain devices. I connect to the Unix server at the DR site and am attempting to recover the databases from backup. We have added entries to the hosts files and created a No.Restrictions file so that the server at the DR site has access to the NetBackup backups. When I run "bplist -C st31bora01 -t 4 -l -R /" at the DR database server, I see several backup files including the catalog backup I want (database files removed from the list for brevity). /u01/app/oraprod> /usr/openv/netbackup/bin/bplist -C st31bora01 -t 4 -l -R / -rw-rw---- oraprod dbaprod 24379392 Oct 14 12:55 /PASPROD_c-1968089396-20121014-02 -rw-rw---- oraprod dbaprod 24379392 Oct 14 02:01 /PASPROD_c-1968089396-20121014-01 -rw-rw---- oraprod dbaprod 24379392 Oct 14 01:56 /PASPROD_c-1968089396-20121014-00 -rw-rw---- oraprod dbaprod 24379392 Oct 13 12:04 /PASPROD_c-1968089396-20121013-00 -rw-rw---- oraprod dbaprod 22544384 Oct 12 17:05 /PASPROD_c-1968089396-20121012-03 -rw-rw---- oraprod dbaprod 22544384 Oct 12 12:05 /PASPROD_c-1968089396-20121012-02 I then try and use the following commands to recover the controlfile: rman set dbid = 1968089396 connect catalog rman10@RMANdb connect target backup_dba list backup of controlfile; RUN { ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE'; SEND 'NB_ORA_CLIENT=st31bbl01,NB_ORA_POLICY=ORA_PASPROD'; restore controlfile; } Unfortunately, this does not work and I get the following failure: Starting restore at 17-Oct-12 15:27:36 channel CH1: starting datafile backupset restore channel CH1: restoring control file channel CH1: reading from backup piece PASPROD_c-1968089396-20121014-01 ORA-19870: error reading backup piece PASPROD_c-1968089396-20121014-01 ORA-19507: failed to retrieve sequential file, handle="PASPROD_c-1968089396-20121014-01", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <PASPROD_c-1968089396-20121014-01> not found in NetBackup catalog failover to previous backup I don't understand why it's not working. The only thing I can see is that when I "list backup ofcontrolfile", I see media ID's that are at the primary site as indicated by "Media: @aaaac". RMAN> list backup of controlfile; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ------------------ 5327585 Full 23.25M SBT_TAPE 00:01:03 14-Oct-12 02:02:28 BP Key: 5327593 Status: AVAILABLE Compressed: NO Tag: TAG20121014T020125 Handle: PASPROD_c-1968089396-20121014-01 Media: @aaaac Control File Included: Ckp SCN: 10909224447 Ckp time: 14-Oct-12 02:01:25 But when I go into the NetBackup Administration Console (at the DR site) and select NetBackup Management --> Catalog in the treeview on the left, I see all the Media ID's are "@aaaae". Any help you can offer would be greatly appreciated. Ken
Solved
khemmerl
12 years ago Place NetBackup
6.1KViews
1like
3Comments
Oracle Intelligent Policy - OS Credentials
Hi, we are currently evaluating the use of OIP for our Oracle backups. Reading the documentation, I am under the impression that I absolutely need OS credentials, whiledatabase credentials are optional. The problem with that is that the OS oracle users (Solaris/Linux) do not have passwords and can only be used by being root first and using su. Will we still be able to use OIP somewhow?
Solved
Thorsten_Jens
7 years ago Place NetBackup
4.4KViews
0likes
14Comments
VxBSACreateObject: Failed with error
Hi all, I need your help, my manager Netbackup on a Windows 2008 operating system and Netbackup 7. We have an integration with RMAN but when I run the backup sguente send us the error. The owner forOracle engine is ORACLE and the NetBackup with another user named NetBackup, and integrate the same group of DBA but still sends me the same error. INF - Begin progress logging for process: (14464.15088) INF - Using policy BMB_SMCHFMPROD4_HFM_Ora_Onl_D to perform a user directed Oracle Stream Based backup. INF - Starting Oracle Recovery Manager. INF - Using: "f:\app\hfm\product\11.2.0\dbhome_1\bin\rman.exe" INF - Connection info: target 'netbackup/*****@HFM' rcvcat 'RMANHFM/*****@rmanbm' INF - Start of Recovery Manager input. INF - # ----------------------------------------------------------------- INF - # RMAN command section INF - # ----------------------------------------------------------------- INF - RUN { INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - INCREMENTAL LEVEL=0 INF - FORMAT 'bk_u%u_s%s_p%p_t%t' INF - TAG 'rl_t%t_s%s_p%p' INF - DATABASE; INF - RELEASE CHANNEL ch00; INF - # Backup Archived Logs INF - sql 'alter system archive log current'; INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - FORMAT 'arch_u%u_s%s_p%p_t%t' INF - ARCHIVELOG INF - ALL INF - DELETE INPUT; INF - RELEASE CHANNEL ch00; INF - # Control file backup INF - ALLOCATE CHANNEL ch00 INF - TYPE 'SBT_TAPE'; INF - SEND 'NB_ORA_CLIENT=SMCHFMPROD4,NB_ORA_SID=HFM,NB_ORA_POLICY=BMB_SMCHFMPROD4_HFM_Ora_Onl_D,NB_ORA_SERV=mxqrsbur,NB_ORA_SCHED=Diario'; INF - BACKUP INF - FORMAT 'ctrl_u%u_s%s_p%p_t%t' INF - CURRENT CONTROLFILE; INF - RELEASE CHANNEL ch00; INF - } INF - End of Recovery Manager input. INF - Start of Recovery Manager output. INF - Recovery Manager: Release 11.2.0.1.0 - Production on Fri Feb 3 23:27:50 2012 INF - connected to target database: HFM (DBID=1249472717) INF - connected to recovery catalog database INF - allocated channel: ch00 INF - channel ch00: SID=696 device type=SBT_TAPE INF - channel ch00: starting incremental level 0 datafile backup set INF - input datafile file number=00012 name=I:\HFM\DATAFILE\CISFM.DMP INF - input datafile file number=00014 name=H:\HFM\DATAFILE\CISODIWORK.DMP INF - input datafile file number=00015 name=I:\HFM\DATAFILE\CISFM01.DMP INF - input datafile file number=00016 name=I:\HFM\DATAFILE\CISFM02.DMP INF - input datafile file number=00017 name=I:\HFM\DATAFILE\CISFM03.DMP INF - input datafile file number=00019 name=G:\HFM\DATAFILE\CISEA01.ORA INF - input datafile file number=00020 name=G:\HFM\DATAFILE\CISEA02.ORA INF - input datafile file number=00021 name=G:\HFM\DATAFILE\CISEA03.ORA INF - input datafile file number=00022 name=G:\HFM\DATAFILE\CISEA04.ORA INF - Begin progress logging for process: (2436.13472) INF - Start backup of backup piece: (bk_u0vn2e6rs_s31_p1_t774314876) INF - Server status = 241 ERR - Server exited with status 241: the specified schedule is the wrong type for this request INF - input datafile file number=00007 name=H:\HFM\DATAFILE\CISEPMA.DMP INF - input datafile file number=00018 name=H:\HFM\DATAFILE\CISODIWORK2.DMP INF - input datafile file number=00003 name=E:\HFM\DATAFILE\O1_MF_UNDOTBS1_78OBHVV8_.DBF INF - input datafile file number=00013 name=H:\HFM\DATAFILE\CISODI.DMP INF - input datafile file number=00001 name=E:\HFM\DATAFILE\O1_MF_SYSTEM_78OBH3V0_.DBF INF - input datafile file number=00002 name=E:\HFM\DATAFILE\O1_MF_SYSAUX_78OBHK1G_.DBF INF - input datafile file number=00005 name=J:\HFM\DATAFILE\CISHSS.DMP INF - input datafile file number=00008 name=J:\HFM\DATAFILE\CISHBI.DMP INF - input datafile file number=00011 name=E:\HFM\DATAFILE\CISFDM.DMP INF - input datafile file number=00004 name=E:\HFM\DATAFILE\O1_MF_USERS_78OBJ9N7_.DBF INF - released channel: ch00 INF - RMAN-00571: =========================================================== INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== INF - RMAN-00571: =========================================================== INF - RMAN-03009: failure of backup command on ch00 channel at 02/03/2012 23:28:12 INF - ORA-19506: failed to create sequential file, name="bk_u0vn2e6rs_s31_p1_t774314876", parms="" INF - ORA-27028: skgfqcre: sbtbackup returned error INF - ORA-19511: Error received from media manager layer, error text: INF - VxBSACreateObject: Failed with error: INF - Server Status: the specified schedule is the wrong type for this request INF - Recovery Manager complete. INF - End of Recovery Manager output. INF - End Oracle Recovery Manager.
Korio
13 years ago Place NetBackup
4.2KViews
1like
3Comments
NetBackup: 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?
AlanTLR
13 years ago Place NetBackup
3.9KViews
1like
3Comments
Oracle backups doing very slow, potentionally failing with status 13
Hello Netbackup experts! I'm facing couple of weeks to problem with one client. There is running a oracle online backup to tape via sbt_tape Oracle version is 10.2. running on solaris 10 client, netbackup version 6.5.6 Netbackup MS is 6.5.6 version, media server also, both arerunning on Solaris 10.. Problem is that backup is runnng very slow, but in strange way. For example small control file with size 10MB...it is running in netbackup 3 minutes (wih mounting of tape it is perfectly fine)..job is finished successfully.. Problem seems to be on oracle site...there is job very slow on exit..and it takes 2,5 hour to finish.. I dont know for what it is waiting..According to oracle support it is waiting for netbackup...Try to guess what is a casue according to netbackup support ;) If we are trying to backup oracle archive logs then we have problem with filling up archive log destination..Thing is that we are running archive jobs with a script from a client and every backup peace is starting twice...(in two schedules, intwo jobs)..it is managed by script..That means two jobs are starting paralell and one of them is finished in netbackup successully, but second one is many time running very long time and failed wtih status 13.. I think it is becasue of that script which is starting them is waiting till job is closed also on oracle side and then close second job also on netbackup side...I'm not sure how is it working here but I asusme from test with controlfile backup that (above) it is becasue oracle cannot close the backup job... I found this technote: http://www.symantec.com/business/support/index?page=content&id=TECH130209 According this, we try to make backup of control file to sbt_disk and it rans perfectly well in few second.. However, control file with size 10 MB cannot be preallocated so I dont think that there is described real cause of problem Filesystem backup is runnig there fine..CPU on the client is not overloaded, also disk and NIC seems to be ok.. We try to reinstall netbackup client software, netbackup agent...withouth help.. Symantec support recomends update to version 7.1 and make a clone of database to different client...and see how is it ding there..not possible due to customer rules... Strange is that from netbackup side it looks perfectly well (expect of those archive jobs) and finishing with status 0 in time...But oracle has problem with close the backup...according the debug log it is waiting on netbackup... In netbackup dbclient log is nothing to see for jobs which fisnihed in time...for archive logs there is somethine status 13..I cna attach logs if is somebody interesting.. Can somebody advice where should I look to or where can be a problem? THX!
Solved
frena
12 years ago Place NetBackup
3.8KViews
0likes
6Comments