Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

NetBackup 7.1 for Oracle with RMAN

Created: 06 Feb 2012 | 10 comments

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 

Comments 10 CommentsJump to latest comment

Marianne's picture

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

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Will Restore's picture

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

Will Restore -- where there is a Will there is a way

Rockey Wen's picture

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...
*------------------------------------------------------------------------------*
22:36:42 JOBFAILURE: oraredo COMPLETED WITH ERRORS RC=10

Will Restore's picture

Is that the database client host or the Master server? 

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

Will Restore -- where there is a Will there is a way

Rockey Wen's picture

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.

Marianne's picture

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.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Will Restore's picture

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

Will Restore -- where there is a Will there is a way

Altimate1's picture

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

Bernard

Andy_Benson's picture

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's picture

any update on this?

 

Will Restore -- where there is a Will there is a way