RMAN Database Duplication

1. Creating a Password File for the Auxiliary Instance, When you create a standby database by using RMAN duplication, password files are always copied.
2. Add Net Services for primary and standby databases in the tnsnames.ora file.
3. Adding Static Service to Listener in the listener.ora file.
4. Create an Initialization Parameter File for the Auxiliary Instance.
5. Start the auxiliary instance in NOMOUNT mode.
6. Duplication database.

rman target sys/oracle@Matrix auxiliary sys/oracle@Matrix_DR0

run {
   allocate channel ch00 type disk;
   allocate channel ch01 type disk;
   allocate auxiliary channel ch10 type disk;
   allocate auxiliary channel ch11 type disk;
   duplicate target database for standby from active database
   spfile
      parameter_valume_convert 'Matrix','Matrix_DR0'
      set db_unique_name='Matrix_DR0'
      set control_files='+DATA/Matrix_DR0/control1.ctl'
      set db_create_file_dest='+DATA'
      set db_create_online_log_dest_1='+FLASH'
      set db_recovery_file_dest_1='+FLASH'
      set DB_RECOVERY_FILE_DEST_SIZE='10G'
   nofilenamecheck;
   release channel ch00;
   release channel ch01;
   release channel ch10;
   release channel ch11;
}

Use the NOFILENAMECHECK clause to indicate that RMAN must not display an error when the names of the database files are the same in the source and duplicate database.

If the source database uses a server parameter file, then including the SPFILE option in the DUPLICATE command directs RMAN to use the server parameter file from the source database for the auxiliary instance.