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

Index rebuild online in Oracle - shell script

  [oracle@rac10p reorg]$ cat index_rebuild_EMP.sh #!/bin/ksh export ORACLE_HOME=/oracle/K12/19 export ORACLE_SID=K12 export PATH=$PATH:/$ORA...