Duplicate the database using Rman from active database

Duplicate the database using Rman from active database

1. Configure or install oracle binary oracle_home in target system
2. Configure tns entries in both node(target and source). TNS entry should be pin-gable from the source and target system
3. Create password file in target system and source system using orapw utility. password should be same in target and source database

4. Start the target database in nomont point using pfile

    $sqlplus / as sysdba
    sqlplus>startup nomount pfile=temppfile.ora

-bash-4.4$ cat temppfile.ora
db_name                         = ERPDEV
compatible                      = 12.1.0
control_files                   = /erp_data/oradata/cntrl01.dbf,/erp_data/oradata/cntrl02.dbf,/erp_data/oradata/cntrl03.dbf
*.db_create_file_dest='/erp_data/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_1='/erp_data/oradata'
*.DB_CREATE_ONLINE_LOG_DEST_2='/erp_data/oradata'
*.memory_target=10G
*.remote_login_passwordfile='exclusive'
DB_FILES=2000

5. Connect to auxilary database

rman target sys/manager@source-tns  AUXILIARY sys/manager@target-tns

run

{

allocate channel d1 type disk maxpiecesize 20G;

allocate channel d2 type disk maxpiecesize 20G;

allocate channel d3 type disk maxpiecesize 20G;

allocate channel d4 type disk maxpiecesize 20G;

allocate channel d5 type disk maxpiecesize 20G;

allocate channel d6 type disk maxpiecesize 20G;

allocate channel d7 type disk maxpiecesize 20G;

allocate channel d8 type disk maxpiecesize 20G;

allocate auxiliary channel DUP1 type disk maxpiecesize 20G;

allocate auxiliary channel DUP2 type disk maxpiecesize 20G;

allocate auxiliary channel DUP3 type disk maxpiecesize 20G;

allocate auxiliary channel DUP4 type disk maxpiecesize 20G;

allocate auxiliary channel DUP5 type disk maxpiecesize 20G;

allocate auxiliary channel DUP6 type disk maxpiecesize 20G;

allocate auxiliary channel DUP7 type disk maxpiecesize 20G;

allocate auxiliary channel DUP8 type disk maxpiecesize 20G;

duplicate target database to 'ERPDEV'  from active database;

}

in case failed during rman restore command in last stage, please allocate one channel and one channel for auxiliary. its a bug. the restore will start from where it failed

run

{

allocate channel d1 type disk;

allocate auxiliary channel DUP1 type disk;

duplicate target database to 'ERPDEV'  from active database;

}