Wednesday, March 10, 2010

rman disk backup from test server to another server

ON TEST

$ cd /tmp
$ ln -s /oracle/systemTEST/oraexport kloon

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
'/tmp/kloon/kloon_set_test';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
'/oracle/systemTEST/oraexport/kloon_set_test';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/tmp/kloon/kloon_set_test';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> backup database include current controlfile ;


channel ORA_DISK_1: starting piece 1 at 05-FEB-10
channel ORA_DISK_1: finished piece 1 at 05-FEB-10
piece handle=/tmp/kloon/kloon_set_test tag=TAG20100205T131237
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 05-FEB-10


TRANSFER THIS FILE TO DVL system

then on DVL

1. create an initDVL.ora
include
*.compatible='10.2.0.4.0'
*.control_files='/oracle/systemDVL/control................adjust this
line
*.db_block_size=16384
*.db_domain='x.x.nl'
*.db_name='dvl'
*.job_queue_processes=10
*.local_listener='(ADDRESS=(protocol=tcp)(host=systemDVL)(PORT=1521))'
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=200M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.DB_FILE_NAME_CONVERT='/oracle/systemTEST/oradata01/test/','/oracle/sys
temDVL/oradata01/dvl/'
*.LOG_FILE_NAME_CONVERT='/oracle/systemTEST/oraredo/test/','/oracle/syst
emDVL/oraredo/dvl/',


$ cd /tmp
$ ln -s /oracle/systemDVL/oraexport kloon

RMAN >
connect auxiliary sys/password
connect target sys/password@//TEST/db_on_test
run {
ALLOCATE auxiliary CHANNEL ch1 DEVICE TYPE disk format
'/tmp/kloon/kloon_set_test' ;
DUPLICATE TARGET DATABASE TO db_on_dvl ;
}