Home > Oracle > DUPLICATE FROM ACTIVE DATABASE RMAN command

DUPLICATE FROM ACTIVE DATABASE RMAN command

run {
   allocate channel prmy1 type disk;
   	allocate channel prmy2 type disk;
   	allocate channel prmy3 type disk;
   	allocate channel prmy4 type disk;
   	allocate auxiliary channel stby type disk;
   	duplicate target database for standby from active database
   	spfile
   		parameter_value_convert 'testorac','standby1'
   		set db_unique_name='standby1'
   		set db_file_name_convert='/testorac/','/standby1/'
   		set log_file_name_convert='/testorac/','/standby1/'
   		set control_files='+DATA'
   		set log_archive_max_processes='5'
   		set fal_client='standby1'
   		set fal_server='testorac	'
   		set standby_file_management='AUTO'
   		set log_archive_config='dg_config=(testorac,standby1)'
   		set log_archive_dest_1='service=testorac ASYNC
	valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=testorac';
     }

On primary


SELECT sequence#, first_time, next_time
FROM v$archived_log
ORDER BY sequence#
/

On standby

select sequence#,applied from v$archived_log
order by sequence#;
Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: