Tuesday 13 March 2012

Backup & Recovery Area

ORA-27206: requested file not found in media management catalog

During take backup through Veritas netbackup, it shows below errors

channel ch00: starting piece 1 at 2011-10-31:10:13:48
RMAN-03009: failure of backup command on ch01 channel at 10/31/2011 10:14:23
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog
The problem has occurred If you are added your client ip address in master netbackup server while configure backup policy.
So change client hostname with domain name instead of ip address of client.

RMAN-03009 ORA-19506 ORA-27028 ORA-19511 error while configure oracle backup in veritas netbackup

When i’m trying configure oracle backup on veritas netbackup, it showing the below errors 

RMAN> 
allocated channel: ch00
channel ch00: sid=125 devtype=SBT_TAPE
channel ch00: Symantec/BackupExec/1.1.0

allocated channel: ch01
channel ch01: sid=90 devtype=SBT_TAPE
channel ch01: Symantec/BackupExec/1.1.0

Starting backup at 2011-10-30:14:34:49
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00005 name=H:\BROKER\PACE01.DBF
input datafile fno=00002 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\UNDOTBS01.DBF
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSAUX01.DBF
input datafile fno=00014 name=H:\BROKER\PACE04.DBF
input datafile fno=00012 name=D:\CIGNATBS\CCIDATA01.DBF
input datafile fno=00004 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\USERS01.DBF
input datafile fno=00007 name=D:\ORACLE\CATALOG\BROKER\RMAN01.DBF
channel ch00: starting piece 1 at 2011-10-30:14:34:50
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00006 name=H:\BROKER\FACE01.DBF
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\BROKER\SYSTEM01.DBF

channel ch01: starting piece 1 at 2011-10-30:14:34:51
RMAN-03009: failure of backup command on ch00 channel at 10/30/2011 14:34:52
ORA-19506: failed to create sequential file, name="bk_uhsmqdf8a_s1596_p1_t765902090", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   BEError(0x80004005) Unspecified error  
Cause :
The problem has occured because I have already configured symantec backup exec agent software on particular database server, So it has created own orasbt.dll file in c:\windows\system32 directory and that particular database sbt device is configured with symantec backup exec . While the existing system running,  I installed veritas netbackup client  agent also on the same server without removing symantec backup exec and removed orasbt.dll file.
If symantec backup exec is already install on the same server, and if we are trying to install netbackup then it does not overwrite on orasbt.dll file.
This is the reason when i take backup, the allocated channel showing symantec backup exec not veritas oracle netbackup.
 
Solution :
Uninstall Both client software (Symantec Backup exec and Vertias ntbackup)
delete orasbt.dll file from  ”C:\windows\system32\”
Install again Veritas Oracle netbackup.  Now Its works fine.
RMAN> run {
   ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
   SEND 'NB_ORA_SERV=xxxxxx.ace-ins.com,NB_ORA_CLIENT=yyyyyy.ace-ins.com,N
B_ORA_POLICY=dbtest';
  BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_u%u_s%s_p%p_t%t' DATABASE;
  }

allocated channel: ch00
channel ch00: sid=147 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (20100104)

sent command to channel: ch00

Starting backup at 31-OCT-11
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSTEM01.D
BF
input datafile fno=00003 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\TESTDB\SYSAUX01.D
BF

RMAN-06091: no channel allocated for maintenance (of an appropriate type)

When I tried to delete obsolete backup, it shows following error.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 05/16/2011 14:41:39
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

We need to find out whether tape device or disk type using list backup command.

and then if you want to delete disk type backup files, you can use following command.
RMAN> allocate channel for maintenance type disk;

allocated channel: ORA_MAINT_DISK_2
channel ORA_MAINT_DISK_2: sid=68 devtype=DISK

RMAN> delete obsolete device type disk;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           816    01-MAY-11
  Backup Piece       816    01-MAY-11          J:\BROKER\RMAN\BROKER749986431_S8
28_S1
Backup Set           817    01-MAY-11
  Backup Piece       817    01-MAY-11          J:\BROKER\RMAN\BROKER749986548_S8
29_S1
Backup Set           818    01-MAY-11
  Backup Piece       818    01-MAY-11          J:\BROKER\RMAN\BROKER749986664_S8
30_S1
Backup Set           819    01-MAY-11
  Backup Piece       819    01-MAY-11          J:\BROKER\RMAN\BROKER749986782_S8
31_S1
Backup Set           822    01-MAY-11
  Backup Piece       822    01-MAY-11          D:\ORACLE\PRODUCT\FLASHRECOVERY\B
ROKER\AUTOBACKUP\2011_05_01\O1_MF_S_749988140_6VT1CXPZ_.BKP
Backup Set           829    03-MAY-11
  Backup Piece       829    03-MAY-11          J:\BROKER\RMAN\BROKER750185116_S8
42_S1
Backup Set           830    03-MAY-11
  Backup Piece       830    03-MAY-11          J:\BROKER\RMAN\BROKER750185233_S8
43_S1
Backup Set           831    03-MAY-11
  Backup Piece       831    03-MAY-11          J:\BROKER\RMAN\BROKER750185349_S8
44_S1
Backup Set           859    11-MAY-11
  Backup Piece       859    11-MAY-11          J:\BROKER\RMAN\BROKER750868262_S8
72_S1
Backup Set           860    11-MAY-11
  Backup Piece       860    11-MAY-11          J:\BROKER\RMAN\BROKER750868389_S8
73_S1
Backup Set           863    11-MAY-11
  Backup Piece       863    11-MAY-11          J:\BROKER\RMAN\BROKER750868770_S8
76_S1

Do you really want to delete the above objects (enter YES or NO)?
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER749986431_S828_S1 recid=816 stamp=74998
6432
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER749986548_S829_S1 recid=817 stamp=74998
6549
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER749986664_S830_S1 recid=818 stamp=74998
6666
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER749986782_S831_S1 recid=819 stamp=74998
6783
deleted backup piece
backup piece handle=D:\ORACLE\PRODUCT\FLASHRECOVERY\BROKER\AUTOBACKUP\2011_05_01
\O1_MF_S_749988140_6VT1CXPZ_.BKP recid=822 stamp=749988141
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750185116_S842_S1 recid=829 stamp=75018
5118
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750185233_S843_S1 recid=830 stamp=75018
5234
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750185349_S844_S1 recid=831 stamp=75018
5351
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750868262_S872_S1 recid=859 stamp=75086
8264
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750868389_S873_S1 recid=860 stamp=75086
8391
deleted backup piece
backup piece handle=J:\BROKER\RMAN\BROKER750868770_S876_S1 recid=863 stamp=75086
8772
Deleted 11 objects

RMAN>

or If you want TAPE,
rman>allocate channel for maintenance device type 'sbt_tape' PARMS '
Change your tape parms.

Reference:Oracle Doc 567555.1
By at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)