Video Screencast Help

RMAN CROSSCHECK EXPIRED EXISTING BACKUPPIECE.

Created: 16 Jan 2013 • Updated: 16 Jan 2013 | 2 comments
This issue has been solved. See solution.

Hi expert,

I already search this forum and cannot find topic matching this case.

Recently we have found the problem that some of backuppiece was expired after running weekly crosscheck script.

Environment

Master Server: netbackup

Media Server: cvgdb01_back, cvgdb02_back

Oracle Client: cvgdb01_back, cvgdb02_back

Option Used: SSO, OracleClient, Online backup using rman archivelog mode and remote recovery catalog

Retention: level9 infinite for netbackup , recovery window of 90 days for rman recovery catalog

We use 'Failover VIP is not available and backup is load balanced, simple script with manual policy failover' from Symantec Document to protect the RAC database.

I already open case (03367265) to support but no luck.

Weekly Crosscheck script is below.

$RMAN target $constr catalog $cat msglog $RMAN_LOG_FILE append << EOF
allocate channel for maintenance type 'sbt_tape';
delete noprompt obsolete;
delete noprompt obsolete orphan;
crosscheck backupset of database;
crosscheck backupset of controlfile;
crosscheck backupset of archivelog all;
EOF
"

Some backup piece that was expired.

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1167774 2.00M      SBT_TAPE    00:00:50     16-JAN-13
        BP Key: 1167782   Status: EXPIRED  Compressed: NO  Tag: TAG20130116T222337
        Handle: al_10324_1_804897076   Media:

  List of Archived Logs in backup set 1167774
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  2    4326    166048694612 16-JAN-13 166048827449 16-JAN-13
 

Used bplist to search backupid.

/usr/openv/netbackup/bin/bplist -C cvgdb02_back -Listpolicy -Listseconds -t 4 /al_10324_1_804897076 | awk '{print $14}'
1358350282

Used bpimagelist to search mediaid.

/usr/openv/netbackup/bin/admincmd/bpimagelist  -media -l -option COMPLETE_COPIES -backupid cvgdb02_back_1358350282 | awk '/FRAG/ {print $9}'

000125

 

This is occur on production database when I try to redirect restore production RAC database to development database server so please help us!!!

Thanks,

Nawamin

Comments 2 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

Weekly Crosscheck script is below.

$RMAN target $constr catalog $cat msglog $RMAN_LOG_FILE append << EOF
allocate channel for maintenance type 'sbt_tape';
delete noprompt obsolete;
delete noprompt obsolete orphan;
crosscheck backupset of database;
crosscheck backupset of controlfile;
crosscheck backupset of archivelog all;
EOF
"

Channels are not configured as in backup script. How about configure channels in a manner same with backup script?

Reference: http://www.symantec.com/docs/HOWTO69221

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

SOLUTION
nawaminAIT's picture

Thank you Yasuhisa you solution is work!!

My 4 channel for backup script is

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb01_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod1';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb02_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod2';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb01_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod1';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb02_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod2';

 

So I allocate 4 channel for maintenance too like this

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' parms 'ENV=(NB_ORA_CLIENT=cvgdb01_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod1';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb02_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod2';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb01_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod1';
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE'parms 'ENV=(NB_ORA_CLIENT=cvgdb02_back,NB_ORA_SERV=netbackup)'CONNECT='rman/rman@totprod2';

 

Thank you verymuch.