β02-14-2016 11:19 PM
I am using NB 7.6.1 on RHEL 6.5 64-bit operating system hosted on IBM X3650M4 server.
This serve is used as Master as well as Media server. It is connected to IBM TS3100 tape using FC cable. (Direct connection)
Currently I am testing a Oracle DB backup script. The script is as attached.
When I ran the script, I see below error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 02/12/2016 20:02:29
ORA-19506: failed to create sequential file, name="orabk_NGMDB_20160212_15_1_903642274", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: extended error status has been encountered, check logs
I am taking the backup directly on tape. I have already configured oracle lib on DB server (client)
$ ll $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx 1 ora112 dba 36 Feb 7 02:05 /opt/oracle/11.2.0/lib/libobk.so -> /usr/openv/netbackup/bin/libobk.so64
RMAN configuration for DB is as follows:
connected to target database: NGMDB (DBID=1958636150)
connected to recovery catalog database
RMAN> show all;
RMAN configuration parameters for database with db_unique_name NGMDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/11.2.0/dbs/snapcf_NGMDB.f'; # default
Any suggestions please?
β02-14-2016 11:33 PM
I suggest you start with going through this post:
https://www.veritas.com/community/app#!/forums/general-database-backup-error-troubleshooting
β02-14-2016 11:47 PM
You have not told us anything about the client.
OS/NBU/Oracle versions (looks like Oracle 11g R2)?
Are normal filesystem backups working?
Have you confirmed and tested comms between client and master/media server?
Forward and reverse name lookup in both directions, port connectivity in both directions?
Have you created dbclient log folder on the client with 777 permissions?
Are you running the script directly from the client as oracle user?
Or script via NBU policy on the master?
If kicked off from the master, does the script have a section to check user id and 'su - <oracle-user>'?
Have you checked and confirmed that policy is configured correctly on the master?
Does the backup attempt appear in Activity Monitor?
What is the error in NBU?