Unsolved

This post is more than 5 years old

4 Posts

1416

November 24th, 2014 06:00

Oracle rman crosscheck on Data Domain DDBoost

I would like to ask what is a good practice to run crosscheck   on two data domain nodes when one is primary and second is replication.

Whether I should run the script for first domain and for second? or just run one time for first node? 

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-01-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

CROSSCHECK BACKUP;

CROSSCHECK COPY;

CROSSCHECK BACKUP OF DATABASE;

CROSSCHECK BACKUP OF CONTROLFILE;

CROSSCHECK ARCHIVELOG ALL;

delete noprompt obsolete;

release channel;

Second

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-11-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

CROSSCHECK BACKUP;

CROSSCHECK COPY;

CROSSCHECK BACKUP OF DATABASE;

CROSSCHECK BACKUP OF CONTROLFILE;

CROSSCHECK ARCHIVELOG ALL;

delete noprompt obsolete;

release channel;

When

Primary DD

dd-01-eth1

Replication DD

dd-01-eth1

Rman scripts

run {

allocate channel dd1 type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-01-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

allocate channel dd2 type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-01-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

allocate channel dd3 type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-01-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

allocate channel dd4 type 'SBT_TAPE' PARMS 'BLKSIZE=1048576,SBT_LIBRARY=/u01/app/oracle/product/11.2.0/db_1/lib/libddobk.so, ENV=(STORAGE_UNIT=oracle, BACKUP_HOST=dd-01-eth1,ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)';

backup copies 2 incremental level=0 format 'cibakc_db_%d_%T_L0_%u_%p.bak','dd-11-eth0/cibakc_db_%d_%T_L0_%u_%p.bak' (database FILESPERSET 1 tag ='LEVEL_0_201446' INCLUDE CURRENT CONTROLFILE) PLUS ARCHIVELOG DELETE INPUT FILESPERSET 20;

BACKUP VALIDATE  CHECK LOGICAL DATABASE  ARCHIVELOG ALL;

REPORT SCHEMA;

release channel dd1;

release channel dd2;

release channel dd3;

release channel dd4;

}

No Responses!
No Events found!

Top