Monday, November 9, 2020

Command to do active duplicate for Oracle Database

1. First login to target server
2. Validate tns connectivity between Source DB and Target DB
3. Prepare and validate space availability
4. Startup mount the target and source database ( If not done already)
5. Use the below command to do active duplicate

rman auxiliary sys/PASS@target_DB target sys/PASS@source_DB log=/tmp/active_duplicate.log <<EOF
run {
allocate channel ch1 type disk;
allocate auxiliary channel stby1 type disk;
DUPLICATE TARGET DATABASE TO 'newdb' FROM ACTIVE DATABASE nofilenamecheck noredo;
}
EOF

How to change ASM rebalance Power in Oracle Database

 How to change ASM rebalance Power in Oracle Database?

1. Login to ASM 

2. Use the below query to find ASM Rebalance power for all current operations.

select * from v$asm_operation;

3. Use the below query to change ASM rebalance power.

alter diskgroup DATA rebalance power 8; 

4. Use the below query to find changed ASM Rebalance power for all current operations.

select * from v$asm_operation;

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...