Unsolved
This post is more than 5 years old
4 Posts
0
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;
}


