cancel
Showing results for 
Search instead for 
Did you mean: 

NetBackup 7.1 for Oracle with RMAN

Rockey_Wen
Level 4

Does anyone know what can be backed up by using NetBackup client for Oracle?

Basically, what we try to achieve is backing up the database content (database, archive logs, control files) and the database related text files (SPFILEs and control file traces) in one policy, so that we can get the consistent restores later.  However, if we set the policy type to Oracle and schedule type to "Application Backup", it can backup the database content but not the text files.  If we set the policy type to Standard and the schedule type to "User Backup", the text files are backed up but the database content backup failed.

We know by using the RMAN scripts to backup to local disk, it works actually.  But if we using the same scripts to backup to NetBackup, it keeps failing with the error message "Exit Status 245: the specified policy is not of the correct client type".

Can anyone explain why this happens?  Is there any workaround solution?

 

Many thanks,

Rockey 

10 REPLIES 10

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Policy type must be Oracle.

You need to have Database and Application pack license on the Master to enable the policy type.

See NBU for Oracle Admin Guide for UNIX, Windows, and Linux  http://www.symantec.com/docs/DOC3672

Will_Restore
Level 6

DOCUMENTATION: How to back up and restore the Oracle control file and SPFILE using NetBackup for Oracle with Oracle's autobackup feature

"Oracle's autobackup feature was introduced at Oracle 9i (specifically 9.2) as a method to easily and automatically capture the critical information in the control file and SPFILE to be used for disaster recovery"

 

for details in setting this up, go to the link:

 URL http://www.symantec.com/docs/TECH36428

Rockey_Wen
Level 4
Here're the logs when we set the policy type to Oracle and schedule type to "Application Backup". We were using ORAHOT and ORAREDO feature to backup the Oracle databases through NetBackup. Every time when it starts to backup the control file trace, it returns error message "EXIT STATUS 245: the specified policy is not of the correct client type". Is there anything we need to configure on the NetBackup side or Oracle side to get it work? =============================================================================== 22:26:18 Module: /depot/BT_UTILITY/RCS/ORABACKUP/oraredo Version: 6.0.1.69 Version Date: 2011/07/20 22:26:18 /u02/dboracle/tools/oracle/backup/bin/oraredo started on 02/02/2012 on host unx-syd-findev.ap.bt.com 22:26:18 Output log is /u02/dboracle/tools/oracle/backup/log/VFINUAT/oraredo/r20120202.log.006 22:26:18 Issue dummy bplist command to check Netbackup availability 22:26:28 Netbackup server daemon is responding 22:26:28 Query Netbackup Server Version 22:26:29 Netbackup Server Version is 7.1 22:26:29 Netbackup Extension Library /usr/openv/netbackup/bin/libobk.so is 32-bit 22:26:29 Oracle binary /u012/dboracle/orabase/product/9.2.0/bin/oracle is 32-bit 22:26:29 No alert file validation as ERRORCODELIST=none or is null 22:26:29 Add details to lock file 22:26:30 Database Role : PRIMARY, Database Mode : READ_WRITE 22:26:30 TNS_ADMIN set to /var/opt/oracle -------------------------------------------------------------------------------- Runtime Parameter Settings Volume Manager : Backup copies : 2 Backup tool : netbackup Backup type : rman Backup parameters : -c Oracle-VFINUAT-HB -s Default-Application-Backup Backup Timeout : 7200 Checksum : N Compress : N Delete logs archived before last full backup : Y Log Retention Days : 3 Override Log Archive Dir : Degree of Parallelism : 1 Fail on Log Seq Error : FALSE Logfile : /u02/dboracle/tools/oracle/backup/log/VFINUAT/oraredo/r20120202.log.006 Log Switch : Y Log Switch Scope : all instances Netbackup Failure Codes : 25 Offline Backup : Y ORACLE_SID : VFINUAT Parameter Directory : /u02/dboracle/tools/oracle/backup/parameter/VFINUAT/oraredo Parameter File : oraredo_parmfile_01 PCT Used Limit : 0 Pfile : /u012/dboracle/orabase/product/9.2.0/dbs/initVFINUAT.ora Testrun : Use environment variables: N Verbose : Y Error Code Alert List : none Alert File : -------------------------------------------------------------------------------- RMAN Settings Database ID : 3473343092 RMAN Catalog : FALSE Backup Tape IO Slaves : Y Control File Keep Time : 40 Tag : VFINUAT_20120202222629_A Format : /VFINUAT_20120202222629_A_3473343092_%s_%p_%c_%t Duplex : OFF Buffer Block Size : 262144 Maxopenfiles : RMAN default Maxpiecesize : RMAN default Maxsetsize : RMAN default Autobackup Controlfile : Y Backup Controlfile : Y Snapshot Controlfile : RMAN default Backup using SCN : N Filesperset : RMAN default Max Corrupt Blocks : 0 Validate Check Logical : FALSE Crosscheck : Y Crosscheck Backups Completed Before : 25/01/2012 Delete Expired : Y Use rule-based optimizer : N -------------------------------------------------------------------------------- Netbackup Settings Netbackup Class : Oracle-VFINUAT-HB Netbackup Schedule : Default-Application-Backup Netbackup Keyword : dba_VFINUAT_al20120202222629 Netbackup Server : srv-syd-bk11.ap.bt.com Client Version : 6.5.6 Server Version : 7.1 Netbackup Query Client : unx-syd-findev.ap.bt.com Netbackup RMAN Class : Oracle-VFINUAT-HB Netbackup RMAN Schedule : Default-Application-Backup -------------------------------------------------------------------------------- 22:26:30 User login name: oracle 22:26:30 Get log parameters from database -------------------------------------------------------------------------------- Archived Log Database Settings Log archive dest : /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01 Log archive directory : /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01 Log archive file : Log archive format : finlog%s.arc Log full format : finlog%s.arc Log archive start : TRUE Log mode : ARCHIVELOG -------------------------------------------------------------------------------- 22:26:31 Table ARCHREDO_BACKUP_LOG exists -------------------------------------------------------------------------------- Shared Pool Memory Validation SGA Pool used by RMAN : SHARED_POOL SGA Pool Free Memory : 808605K RMAN Block Size : 256K RMAN Buffer Size : 1056K = (4*Block Size)+32K RMAN SGA Memory Reqd : 1056K = (Parallelism*Buffer Size) Max Parallelism Available : 765 -------------------------------------------------------------------------------- 22:26:31 Thread number of current instance is 1 -------------------------------------------------------------------------------- Log archive filesystem statistics: Log Archive Directory : /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01 Space Allocated : 15117.97MB Space Used : 3841.75MB Space Free : 11276.22MB %Used : 22% Daily archived redo log peak rate : 799.99MB Daily archived redo log average rate : 399.99MB -------------------------------------------------------------------------------- 22:26:35 Command: ALTER SYSTEM ARCHIVE LOG CURRENT; 22:26:35 Log archival completed successfully 22:26:35 Identify last successfully archived redo log 22:26:35 Last archived redo log on current thread 1 was log number 1985 22:26:35 Last archived redo log created over 3 days ago on thread 1 was log number 29 22:26:35 Oracle Streams : Archived log check 22:26:35 Get details of last archived log before last full database backup 22:26:35 No details of last pre-backup archived logs found 22:26:35 Identify archived redo logs in archived log directory 22:26:36 Query v$archived_log view to obtain completion time 22:26:36 Query v$archived_log to identify logs registered as deleted 22:26:36 Begin backup of archived redo logs 22:26:36 First file date is 02/02/2012 (mm/dd/yyyy) 22:26:36 Identifying backed up files since 02/02/2012 (mm/dd/yyyy) 22:26:36 Process archived log list 22:26:39 Sorting archived logs by thread and sequence numbers 22:26:40 finuatlog1978.arc: Backup copies 1 < limit; Not deleted 22:26:40 FINUATLog1979.arc: Backup copies 1 < limit; Not deleted 22:26:40 FINUATLog1980.arc: Backup copies 1 < limit; Not deleted 22:26:40 FINUATLog1981.arc: Backup copies 0 < limit; Not deleted 22:26:40 finlog1982.arc: Backup copies 0 < limit; Not deleted 22:26:41 finlog1983.arc: Backup copies 0 < limit; Not deleted 22:26:41 finlog1984.arc: Backup copies 0 < limit; Not deleted 22:26:41 finlog1985.arc: Backup copies 0 < limit; Not deleted 22:26:42 RMAN backup tag VFINUAT_20120202222629_A 22:26:42 RMAN BACKUP SESSION STARTED ------------------------------ RMAN command file ------------------------------- run{ CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' TO 'VFINUAT_CTL_%F' ; CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR ; ALLOCATE CHANNEL CH01 TYPE 'sbt_tape' ; SEND 'NB_ORA_POLICY=Oracle-VFINUAT-HB,NB_ORA_SCHED=Default-Application-Backup' ; BACKUP ARCHIVELOG FROM SEQUENCE = 1978 UNTIL SEQUENCE = 1985 THREAD = 1 TAG = 'VFINUAT_20120202222629_A' FORMAT = 'VFINUAT_20120202222629_A_3473343092_%s_%p_%c_%t' ; BACKUP CURRENT CONTROLFILE TAG = 'VFINUAT_20120202222629_A' FORMAT = 'VFINUAT_20120202222629_A_c-3473343092-20120202-222642' ; } --------------------------- End of RMAN command file --------------------------- 22:26:42 Netbackup Log Directory: /usr/openv/netbackup/logs/user_ops/dbext/logs 22:26:42 Wait for RMAN to complete - to check progress, see RMAN log: /tmp/orabackup.work.oracle/oraredo.9857.temp6 22:26:42 Map Netbackup logs to Oracle Processes, RMAN PID is 10662. 22:27:03 To check Netbackup progress, see Netbackup logs: /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182010 /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182184 /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182246 22:33:04 RMAN BACKUP SESSION COMPLETED -------------------------------------------------------------------------------- Netbackup Log /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182010: Backup started Thu Feb 2 22:26:50 2012 22:26:53 Initiating backup 22:26:59 INF - Starting bpbrm 22:27:07 INF - Data socket = srv-syd-bk11.IPC:/tmp/vnet-10732328182023972154000000000-X0xzMQ;4bb161aa9337fa541f8a74af16086723;4;600 22:27:07 INF - Name socket = srv-syd-bk11.IPC:/tmp/vnet-10733328182024972495000000000-2r6QDT;ed745a6d63fdcf694f951a5ab23c531b;4;600 22:27:07 INF - Job id = 202509 22:27:07 INF - Backup id = unx-syd-findev_1328182016 22:27:07 INF - Backup time = 1328182016 22:27:07 INF - Policy name = Oracle-VFINUAT-HB 22:27:07 INF - Snapshot = 0 22:27:07 INF - Frozen image = 0 22:27:07 INF - Backup copy = 0 22:27:07 INF - Master server = srv-syd-bk11 22:27:07 INF - Media server = srv-syd-bk11 22:27:07 INF - Multiplexing = 0 22:27:07 INF - New data socket = srv-syd-bk11.IPC:/tmp/vnet-10711328182022879784000000000-eYLwIG;54726ffeb931b3b95b7f81e6c9939824;4;600 22:27:07 INF - Encrypt = 0 22:27:07 INF - Use shared memory = 0 22:27:07 INF - Compression = 0 22:27:07 INF - Encrypt = 0 22:27:08 INF - Keep logs = 28 22:27:08 INF - Client read timeout = 600 22:27:08 INF - Media mount timeout = 0 22:27:16 INF - Waiting for mount of media id 0012L3 on server srv-syd-bk11 for writing 22:27:50 INF - Mounted media id 0012L3 22:29:15 INF - Beginning backup on server srv-syd-bk11 of client unx-syd-findev 22:29:32 INF - Server status = 0 22:29:35 INF - Backup by oracle on client unx-syd-findev using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the requested operation was successfully completed -------------------------------------------------------------------------------- Netbackup Log /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182184: Backup started Thu Feb 2 22:29:45 2012 22:29:47 Initiating backup 22:29:51 INF - Starting bpbrm 22:30:01 INF - Data socket = srv-syd-bk11.IPC:/tmp/vnet-11100328182197695471000000000-tH0XqH;4d3e39eb85c5100c878a2b7fbd30acac;4;600 22:30:01 INF - Name socket = srv-syd-bk11.IPC:/tmp/vnet-11101328182198788422000000000-B88crR;4eee758913147f7f07540506ca9eefb0;4;600 22:30:01 INF - Job id = 202510 22:30:01 INF - Backup id = unx-syd-findev_1328182190 22:30:01 INF - Backup time = 1328182190 22:30:01 INF - Policy name = Oracle-VFINUAT-HB 22:30:01 INF - Snapshot = 0 22:30:01 INF - Frozen image = 0 22:30:01 INF - Backup copy = 0 22:30:01 INF - Master server = srv-syd-bk11 22:30:01 INF - Media server = srv-syd-bk11 22:30:01 INF - Multiplexing = 0 22:30:01 INF - New data socket = srv-syd-bk11.IPC:/tmp/vnet-11099328182196711877000000000-19Z9qD;b2258fb1b9e9412f63b2f4dad1ef939e;4;600 22:30:01 INF - Encrypt = 0 22:30:01 INF - Use shared memory = 0 22:30:02 INF - Compression = 0 22:30:02 INF - Encrypt = 0 22:30:02 INF - Keep logs = 28 22:30:02 INF - Client read timeout = 600 22:30:02 INF - Media mount timeout = 0 22:30:12 INF - Mounted media id 0012L3 22:30:14 INF - Beginning backup on server srv-syd-bk11 of client unx-syd-findev 22:30:26 INF - Server status = 0 22:30:29 INF - Backup by oracle on client unx-syd-findev using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the requested operation was successfully completed -------------------------------------------------------------------------------- Netbackup Log /usr/openv/netbackup/logs/user_ops/dbext/logs/10692.0.1328182246: Backup started Thu Feb 2 22:30:46 2012 22:30:49 Initiating backup 22:32:03 INF - Starting bpbrm 22:32:11 INF - Data socket = srv-syd-bk11.IPC:/tmp/vnet-11428328182328196957000000000-kPNa5e;e1dc7ae7263f897d4db7e6fcd92e03a3;4;600 22:32:11 INF - Name socket = srv-syd-bk11.IPC:/tmp/vnet-11433328182329167870000000000-MhXjkf;ed2d34c10cb6dfd911f917d9ea553484;4;600 22:32:11 INF - Job id = 202514 22:32:11 INF - Backup id = unx-syd-findev_1328182321 22:32:11 INF - Backup time = 1328182321 22:32:11 INF - Policy name = Oracle-VFINUAT-HB 22:32:11 INF - Snapshot = 0 22:32:11 INF - Frozen image = 0 22:32:11 INF - Backup copy = 0 22:32:11 INF - Master server = srv-syd-bk11 22:32:11 INF - Media server = srv-syd-bk11 22:32:11 INF - Multiplexing = 0 22:32:11 INF - New data socket = srv-syd-bk11.IPC:/tmp/vnet-11397328182327097486000000000-GFa601;74cd8c9d7fe8090f6c4ff654674b250e;4;600 22:32:12 INF - Encrypt = 0 22:32:12 INF - Use shared memory = 0 22:32:12 INF - Compression = 0 22:32:12 INF - Encrypt = 0 22:32:12 INF - Keep logs = 28 22:32:12 INF - Client read timeout = 600 22:32:12 INF - Media mount timeout = 0 22:32:24 INF - Mounted media id 0012L3 22:32:26 INF - Beginning backup on server srv-syd-bk11 of client unx-syd-findev 22:32:38 INF - Server status = 0 22:32:41 INF - Backup by oracle on client unx-syd-findev using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the requested operation was successfully completed -------------------------------------------------------------------------------- RMAN Log File: Recovery Manager: Release 9.2.0.8.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: VFINUAT (DBID=3473343092) using target database controlfile instead of recovery catalog RMAN> run{ 2> CONFIGURE CONTROLFILE AUTOBACKUP ON; 3> 4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'sbt_tape' TO 'VFINUAT_CTL_%F' ; 5> 6> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR ; 7> 8> ALLOCATE CHANNEL CH01 TYPE 'sbt_tape' ; 9> SEND 'NB_ORA_POLICY=Oracle-VFINUAT-HB,NB_ORA_SCHED=Default-Application-Backup' ; 10> 11> BACKUP ARCHIVELOG 12> FROM SEQUENCE = 1978 13> UNTIL SEQUENCE = 1985 14> THREAD = 1 15> TAG = 'VFINUAT_20120202222629_A' 16> FORMAT = 'VFINUAT_20120202222629_A_3473343092_%s_%p_%c_%t' 17> ; 18> 19> BACKUP CURRENT CONTROLFILE 20> TAG = 'VFINUAT_20120202222629_A' 21> FORMAT = 'VFINUAT_20120202222629_A_c-3473343092-20120202-222642' 22> ; 23> 24> } 25> old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'VFINUAT_CTL_%F'; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'VFINUAT_CTL_%F'; new RMAN configuration parameters are successfully stored RMAN configuration parameters are successfully reset to default value allocated channel: CH01 channel CH01: sid=12 devtype=SBT_TAPE channel CH01: Veritas NetBackup for Oracle - Release 6.5 (2010042404) sent command to channel: CH01 Starting backup at 02/02/2012 22:26:48 channel CH01: starting archive log backupset channel CH01: specifying archive log(s) in backup set input archive log thread=1 sequence=1978 recid=30 stamp=774207484 input archive log thread=1 sequence=1979 recid=31 stamp=774217035 input archive log thread=1 sequence=1980 recid=32 stamp=774219708 input archive log thread=1 sequence=1981 recid=33 stamp=774222022 input archive log thread=1 sequence=1982 recid=34 stamp=774223282 input archive log thread=1 sequence=1983 recid=35 stamp=774223999 input archive log thread=1 sequence=1984 recid=36 stamp=774224520 input archive log thread=1 sequence=1985 recid=37 stamp=774224795 channel CH01: starting piece 1 at 02/02/2012 22:26:49 channel CH01: finished piece 1 at 02/02/2012 22:29:44 piece handle=VFINUAT_20120202222629_A_3473343092_13_1_1_774224808 comment=API Version 2.0,MMS Version 5.0.0.0 channel CH01: backup set complete, elapsed time: 00:02:56 Finished backup at 02/02/2012 22:29:44 Starting backup at 02/02/2012 22:29:44 channel CH01: starting full datafile backupset channel CH01: specifying datafile(s) in backupset including current controlfile in backupset channel CH01: starting piece 1 at 02/02/2012 22:29:44 channel CH01: finished piece 1 at 02/02/2012 22:30:39 piece handle=VFINUAT_20120202222629_A_c-3473343092-20120202-222642 comment=API Version 2.0,MMS Version 5.0.0.0 channel CH01: backup set complete, elapsed time: 00:00:55 Finished backup at 02/02/2012 22:30:39 Starting Control File Autobackup at 02/02/2012 22:30:39 piece handle=VFINUAT_CTL_c-3473343092-20120202-04 comment=API Version 2.0,MMS Version 5.0.0.0 Finished Control File Autobackup at 02/02/2012 22:32:55 released channel: CH01 Recovery Manager complete. -------------------------------------------------------------------------------- 22:33:04 RMAN call completed successfully. 22:33:13 RMAN Autobackup Controlfile Name : VFINUAT_CTL_c-3473343092-20120202-04 22:33:43 /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01: completed save 22:33:43 USER_DUMP_DEST is /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump 22:33:43 Process id for controlfile trace is 11647 22:33:43 Database controlfile backup calls completed successfully 22:33:43 Backup controlfile /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak 22:33:43 Trace controlfile /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc 22:33:43 Execute backup of file /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak 22:33:44 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak: start backup 22:33:44 Execute backup of file /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc 22:33:44 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc: start backup EXIT STATUS 245: the specified policy is not of the correct client type EXIT STATUS 245: the specified policy is not of the correct client type Backup started 02/02/2012 22:33:44 22:33:46 Initiating backup 22:33:51 INF - Server status = 245 22:33:52 INF - Server status = 245 22:33:52 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:34:22 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak: save attempt 1 failed, status 245, retrying Backup started 02/02/2012 22:33:44 22:33:47 Initiating backup 22:33:51 INF - Server status = 245 22:33:52 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:33:52 INF - Server status = 245 22:34:22 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc: save attempt 1 failed, status 245, retrying EXIT STATUS 245: the specified policy is not of the correct client type EXIT STATUS 245: the specified policy is not of the correct client type Backup started 02/02/2012 22:34:22 22:34:25 Initiating backup 22:34:27 INF - Server status = 245 22:34:27 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:34:30 INF - Server status = 245 22:35:00 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak: save attempt 2 failed, status 245, retrying 22:35:00 More than 1 save attempt, sleep 30 secs before retry Backup started 02/02/2012 22:34:22 22:34:25 Initiating backup 22:34:27 INF - Server status = 245 22:34:28 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:34:30 INF - Server status = 245 22:35:00 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc: save attempt 2 failed, status 245, retrying 22:35:00 More than 1 save attempt, sleep 30 secs before retry EXIT STATUS 245: the specified policy is not of the correct client type EXIT STATUS 245: the specified policy is not of the correct client type Backup started 02/02/2012 22:35:30 22:35:33 Initiating backup 22:35:37 INF - Server status = 245 22:35:37 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:35:38 INF - Server status = 245 22:36:08 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak: save failed 3 times 22:36:08 JOBFAILURE: /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak: save failed, status 245 22:36:08 JOBFAILURE: Save of /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak failed Backup started 02/02/2012 22:35:30 22:35:33 Initiating backup 22:35:38 INF - Server status = 245 22:35:38 INF - Backup by oracle on client unx-syd-findev.ap.bt.com using policy Oracle-VFINUAT-HB, sched Default-Application-Backup:the specified policy is not of the correct client type 22:35:39 INF - Server status = 245 22:36:09 /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc: save failed 3 times 22:36:09 JOBFAILURE: /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc: save failed, status 245 22:36:09 JOBFAILURE: Save of /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.trc failed 22:36:14 Identifying backed up files since 02/02/2012 (mm/dd/yyyy) 22:26:17 22:36:15 Query Netbackup for backup expiry date for keyword stub dba_VFINUAT_al20120202222629 22:36:15 Backup expiry date not found, defaulting to 20120202 22:36:15 Identify archived redo logs in archived log directory 22:36:15 Query v$archived_log view to obtain completion time 22:36:15 Query v$archived_log to identify logs registered as deleted 22:36:15 Identifying backed up files since 02/02/2012 (mm/dd/yyyy) 22:36:16 Process archived log list 22:36:19 Sorting archived logs by thread and sequence numbers 22:36:22 finuatlog1978.arc: Backed up; Backup copies 2 >= limit; PCT limit exceeded, 22 > 0; Log retention days not exceeded; Deleted; 22:36:26 FINUATLog1979.arc: Backed up; Backup copies 2 >= limit; PCT limit exceeded, 22 > 0; Log retention days not exceeded; Deleted; 22:36:29 FINUATLog1980.arc: Backed up; Backup copies 2 >= limit; PCT limit exceeded, 21 > 0; Log retention days not exceeded; Deleted; 22:36:29 FINUATLog1981.arc: Backed up; Backup copies 1 < limit; 22:36:30 finlog1982.arc: Backed up; Backup copies 1 < limit; 22:36:30 finlog1983.arc: Backed up; Backup copies 1 < limit; 22:36:30 finlog1984.arc: Backed up; Backup copies 1 < limit; 22:36:30 finlog1985.arc: Backed up; Backup copies 1 < limit; 22:36:30 Updating redo log history file : /u02/dboracle/tools/oracle/backup/log/VFINUAT/oraredo/oraredo.VFINUAT.redologlist 22:36:30 Updating ARCHREDO_BACKUP_LOG with successful backup details 22:36:32 Delete 0 old rows from ARCHREDO_BACKUP_LOG 22:36:32 Crosscheck backups completed before 25/01/2012 22:36:32 No active backups older than 25/01/2012 found for crosscheck 22:36:32 Delete expired backups completed before 25/01/2012 22:36:32 No expired backups not deleted older than 25/01/2012 found for deletion *------------------------------------------------------------------------------* * RMAN Crosscheck Summary Report * *------------------------------------------------------------------------------* Sts : X = Expired, A = Available Del : D = Deleted **** No files found to be crosschecked **** 22:36:32 Query RMAN controlfile tables 22:36:32 Query Netbackup for RMAN backup files 22:36:34 JOBFAILURE: No Netbackup record found for some RMAN backup sets. 22:36:35 Identify completed RMAN backups to KEEP 22:36:35 Execute RMAN change KEEP commands for files other than archived logs Recovery Manager: Release 9.2.0.8.0 - Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: VFINUAT (DBID=3473343092) using target database controlfile instead of recovery catalog RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' ; 2> 3> CHANGE BACKUP OF CONTROLFILE TAG '' KEEP UNTIL TIME = 'SYSDATE+40' LOGS; 4> CHANGE BACKUP OF CONTROLFILE TAG 'VFINUAT_20120202222629_A' KEEP UNTIL TIME = 'SYSDATE+40' LOGS; 5> allocated channel: ORA_MAINT_SBT_TAPE_1 channel ORA_MAINT_SBT_TAPE_1: sid=19 devtype=SBT_TAPE channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 6.5 (2010042404) Recovery Manager complete. 22:36:41 RMAN call completed successfully. *------------------------------------------------------------------------------* * Backup Success Report * *------------------------------------------------------------------------------* **** RMAN Backups **** Set Set Media Backup Size Backup Rate Elapsed Backup Backup Stamp Count Id (MBytes) (MBytes/sec) Time Start End ---------- ----- -------- ------------ ------------ --------- -------- -------- No successful backups *------------------------------------------------------------------------------* * Backup Success Report * *------------------------------------------------------------------------------* **** Non-RMAN Backups **** File File File Size Backup Rate Elapsed Backup Backup Id Type/Name (MBytes) (MBytes/sec) Time Start End ---- --------------------- ------------ ------------ --------- -------- -------- No successful backups *------------------------------------------------------------------------------* * Backup Failure Report * *------------------------------------------------------------------------------* **** Non-RMAN Backups **** No Failures *------------------------------------------------------------------------------* * Archived Redolog Backup Report * * ------------------------------ * * * * Details of logs processed on 02/02/12 at 22:36:16. * * * * Column Key: % - percentage filesystem used * * C - Number of offline copies * * D - Deleted, log no longer on disk * * Z - Compressed * * B - Log backed up in last run * * Warnings - Warning messages: * * NoSequence - Log file sequence not undetermined * * NoCopies - Log file deleted, no offline copies found* * LogMissing - Gap found in log file sequence * * * *------------------------------------------------------------------------------* Log Name % C D Z B Warnings --------------------------------------------------------- --- -- - - - --------- /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/finuatlog1978.arc 22 2 Y N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/FINUATLog1979.arc 21 2 Y N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/FINUATLog1980.arc 21 2 Y N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/FINUATLog1981.arc 21 1 N N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/finlog1982.arc 21 1 N N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/finlog1983.arc 21 1 N N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/finlog1984.arc 21 1 N N Y /u06/dborafiles/VFINUAT_SD/VFINUAT/oraarch01/finlog1985.arc 21 1 N N Y *------------------------------------------------------------------------------* * Archived Redolog Backup Failure Report * * -------------------------------------- * * * * (Details of log backup failures on 02/02/12 at 22:36:16). * *------------------------------------------------------------------------------* Log Name - no backup found from current run ----------------------------------------------------------------- No Failures. 22:36:42 Write summary record to /u02/dboracle/tools/oracle/backup/log/backup_job_completion_history 22:36:42 Write summary record to /u02/dboracle/tools/oracle/backup/log/VFINUAT/oraredo/backup_job_completion_history 22:36:42 Daily backup record transfer already done *------------------------------------------------------------------------------* Look on Oracle Data Integrity Domain Site for further error details: http://oracle.intra.bt.com/oracle-infra/dba_domain/di/orabackup_troubleshooting.htm *------------------------------------------------------------------------------* 22:36:42 JOBFAILURE: oraredo COMPLETED WITH ERRORS RC=10

Will_Restore
Level 6

Is that the database client host or the Master server? 

I don't think unix client version 7.1 supports 32-bit Oracle.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Can we just go back to basics - please tell us more about your environment:

NBU version on server is 7.1 - same on Oracle client?

OS on Oracle client?

Please post your policy config (to try and see what is causing the status 245):

bppllist Oracle-VFINUAT-HB -U

Also tell us more about this' ORAHOT and ORAREDO feature'? As a NetBackup administrator I am only familiar with the 'normal' rman scripts and templates mentioned in the NBU for Oracle manual.

 

Please also tell us what is /u04/dborafiles/VFINUAT_SD/VFINUAT/admin/udump/control.bak.

If this is a local dump to disk, it cannot be backed up with Oracle type policy.

Oracle control files, databases, redo logs can be backed up with Oracle policy.

Rockey_Wen
Level 4

This is the database client.  The NBU master server is on version 7.1.0.3 and the Oracle client is using NetBackup Client for Oracle version 6.5.6.  The oracle database server is on RHEL 5 x86.

Will_Restore
Level 6

I presume you're talking about this script: http://www.unixlabplus.com/unix-prog/bk.oracle/hot/orahot.html

 

Better to use the standard RMAN script which are known to work as Marianne says.   Sample scripts located under  /usr/openv/netbackup/ext/db_ext/oracle/samples/rman

Altimate1
Level 6
Partner Accredited

Hi,

I don't know either or not it can help but I would like to tell that I made a video explaining how to backup an Oracle database using RMAN from NetBackup.

Here is the link : http://connect.distrilogie.com/p73607318/

Regards

Andy_Benson
Level 2

Pretty sure if you want to use the DB options/agents using a mix of 7.1 master with 6.5.6 client is not such a good idea. I would get your oracle server onto 7.1 at the same patch level as the master.

Will_Restore
Level 6

any update on this?