Disclaimer

Tuesday, 26 November 2024

Cloning from Tape

 

Below is the sample script , how tape channels are allocated at the time of Duplication:-

RUN
{
ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_CLIENT=oradbanmn04p,NSR_SERVER=demuhbcksrv,NSR_DATA_VOLUME_POOL=DB_AFTD1)';
ALLOCATE AUXILIARY CHANNEL CH2 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_CLIENT=oradbanmn04p,NSR_SERVER=demuhbcksrv,NSR_DATA_VOLUME_POOL=DB_AFTD1)';
ALLOCATE AUXILIARY CHANNEL CH3 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_CLIENT=oradbanmn04p,NSR_SERVER=demuhbcksrv,NSR_DATA_VOLUME_POOL=DB_AFTD1)';
ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_CLIENT=oradbanmn04p,NSR_SERVER=demuhbcksrv,NSR_DATA_VOLUME_POOL=DB_AFTD1)';
ALLOCATE AUXILIARY CHANNEL CH5 TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_CLIENT=oradbanmn04p,NSR_SERVER=demuhbcksrv,NSR_DATA_VOLUME_POOL=DB_AFTD1)';
duplicate database ORCLDB dbid 4209880105 to TESTDB
SPFILE
parameter_value_convert 'ORCLDB','TESTDB' 
set control_files='+DISKGROUP4','+DISKGROUP4','+DISKGROUP4'
set db_file_name_convert='+DATA01/ORCLDB','+DISKGROUP4/TESTDB'
set log_file_name_convert='+DATA01/ORCLDB','+DISKGROUP4/TESTDB','+ARCH/ORCLDB','+DISKGROUP4/TESTDB'
set db_create_file_dest='+DISKGROUP4'
set log_archive_dest_1='LOCATION=+DISKGROUP4'
set db_name='TESTDB'
set db_unique_name='TESTDB'
NOFILENAMECHECK;
release channel CH1;
release channel CH2;
release channel CH3;
release channel CH4;
release channel CH5;
} 

No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...