cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle DB backup script showing error

Sushil_0488
Level 2

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?

2 REPLIES 2

Michael_G_Ander
Level 6
Certified

I suggest you start with going through this post:

https://www.veritas.com/community/app#!/forums/general-database-backup-error-troubleshooting

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue

Marianne
Level 6
Partner    VIP    Accredited Certified

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?