Forum Discussion

nawaminAIT's avatar
nawaminAIT
Level 2
13 years ago
Solved

RMAN CROSSCHECK EXPIRED EXISTING BACKUPPIECE.

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

7.1.x and Earlier
Backup and Recovery
NetBackup
Oracle RAC
Solaris
  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    13 years ago

    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

  • nawaminAIT's avatar
    nawaminAIT
    Level 2
    13 years ago

    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.

  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    Level 6
    13 years ago

    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