Clone using RMAN backup - Target on different server ( Source PROD11 , Target TEST ) - Oracle 11g

Clone using RMAN backup - Target on different server ( Source PROD11 , Target TEST ) - Oracle 11g

******************* Start ******************

**** SOURCE

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u04/app/oracle/oradata/prod11/prod11/users01.dbf
/u04/app/oracle/oradata/prod11/prod11/undotbs01.dbf
/u04/app/oracle/oradata/prod11/prod11/sysaux01.dbf
/u04/app/oracle/oradata/prod11/prod11/system01.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u04/app/oracle/oradata/prod11/prod11/redo03.log
/u04/app/oracle/oradata/prod11/prod11/redo02.log
/u04/app/oracle/oradata/prod11/prod11/redo01.log

SQL> select NAME,db_unique_name from v$database;

NAME      DB_UNIQUE_NAME
--------- ------------------------------
PROD11    prod11

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
prod11


**** TAKE RMAN FULL BACKUP

rman target /
connected to target database: PROD11 (DBID=4142957128)

RMAN> sql "alter session set nls_date_format=''dd.mm.yyyy hh24:mi:ss''";
RUN
{
configure controlfile autobackup on;
set command id to 'DBPROD11FULL';
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;

backup AS COMPRESSED BACKUPSET full database
tag PROD_FULL
format '/u01/backup/%d_%T_%s_%p_FULL' ;

backup archivelog all
tag PROD_FULL
format '/u01/backup/%d_%T_%s_%p_ARCHIVE' ;

backup current controlfile
tag PROD_FULL
format '/u01/backup/%d_%T_%s_%p_CONTROL';

release channel c1;
release channel c2;
}

**** COPY THE BACKUP PIECES on TEST SERVER

[oracle@prod backup]$ ls -ltr
total 324396
-rw-r----- 1 oracle oinstall  74383360 Feb 07 20:58 PROD11_20200212_2_1_FULL
-rw-r----- 1 oracle oinstall 185679872 Feb 07 20:58 PROD11_20200212_1_1_FULL
-rw-r----- 1 oracle oinstall  38057984 Feb 07 20:58 PROD11_20200212_4_1_ARCHIVE
-rw-r----- 1 oracle oinstall  23897088 Feb 07 20:58 PROD11_20200212_3_1_ARCHIVE
-rw-r----- 1 oracle oinstall   9797632 Feb 07 20:58 PROD11_20200212_5_1_CONTROL

[oracle@prod backup]$ scp PROD* oracle@stand.som.com:/u01/backup/



**** ON TARGET NOW ..........

**** ENV FILE

[oracle@stand ~]$ cat test.env
export ORACLE_SID=test
export ORACLE_HOME=/u04/app/oracle/11g
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH


**** DBS file ( init and password files ) and then NOMOUNT TEST DATABASE

[oracle@stand dbs]$ cat inittest.ora
test.__db_cache_size=251658240
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__oracle_base='/u04/app/oracle'#ORACLE_BASE set from environment
test.__pga_aggregate_target=130023424
test.__sga_target=381681664
test.__shared_io_pool_size=0
test.__shared_pool_size=113246208
test.__streams_pool_size=0
*.audit_file_dest='/u04/app/oracle/admin/test/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u04/app/oracle/oradata/test/control01.ctl','/u04/app/oracle/oradata/test/control02.ctl'
*.db_file_name_convert='/u04/app/oracle/oradata/prod11/prod11','/u04/app/oracle/oradata/test'
*.log_file_name_convert='/u04/app/oracle/oradata/prod11/prod11','/u04/app/oracle/oradata/test'
*.db_block_size=8192
*.db_domain=''
*.db_name='test'
*.diagnostic_dest='/u04/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
##*.local_listener='LISTENER_TEST'
*.log_archive_dest_1='LOCATION=/u04/app/oracle/oraarch'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=126877696
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=380633088
*.undo_tablespace='UNDOTBS1'

[oracle@stand dbs]$ ls -ltr orapwtes*
-rw-r----- 1 oracle oinstall 1536 Feb 07 21:04 orapwtest


SQL> startup nomount pfile='inittest.ora'
ORACLE instance started.

Total System Global Area  379965440 bytes
Fixed Size                  2213576 bytes
Variable Size             121637176 bytes
Database Buffers          251658240 bytes
Redo Buffers                4456448 bytes
SQL> exit



**** RMAN SCRIPT:
=========================================

[oracle@stand dbs]$ rman

RMAN> connect auxiliary /

connected to auxiliary database: TEST (not mounted)

RMAN> run
{
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
DUPLICATE DATABASE TO "TEST" BACKUP LOCATION '/u01/backup/';
}2> 3> 4> 5> 6>

...
.....
......

database opened
Finished Duplicate Db at 07-FEB-19
released channel: aux1
released channel: aux2

RMAN>

=========================================


**** VALIDATION :


[oracle@stand dbs]$ ps -ef|grep pmon
oracle    16879      1  0 21:35 ?        00:00:00 ora_pmon_test


SQL> select NAME,db_unique_name from v$database;

NAME      DB_UNIQUE_NAME
--------- ------------------------------
TEST

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u04/app/oracle/oradata/test/system01.dbf
/u04/app/oracle/oradata/test/sysaux01.dbf
/u04/app/oracle/oradata/test/undotbs01.dbf
/u04/app/oracle/oradata/test/users01.dbf

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u04/app/oracle/oradata/test/redo03.log
/u04/app/oracle/oradata/test/redo02.log
/u04/app/oracle/oradata/test/redo01.log

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
test

******************* END ******************

Thanks,