个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2020-11-20 15:45:23
-
rman target sys/oracle@orcl auxiliary sys/oracle@orcl_dg <<eof
-
run {
-
allocate channel prmy1 type disk;
-
allocate channel prmy2 type disk;
-
allocate channel prmy3 type disk;
-
allocate channel prmy4 type disk;
-
allocate auxiliary channel stby1 type disk;
-
allocate auxiliary channel stby2 type disk;
-
allocate auxiliary channel stby3 type disk;
-
allocate auxiliary channel stby4 type disk;
-
allocate auxiliary channel stby5 type disk;
-
duplicate target database for standby from active database nofilenamecheck
-
spfile
-
set db_unique_name='orcl_dg'
-
set db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_dg'
-
set log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl_dg'
-
set control_files='/u01/app/oracle/oradata/orcl_dg/control01.ctl'
-
set fal_client='orcl_dg'
-
set fal_server='orcl'
-
set standby_file_management='auto'
-
set log_archive_config='dg_config=(orcl,orcl_dg)'
-
set log_archive_dest_1='location=/arch valid_for=(all_logfiles,all_roles) db_unique_name=orcl_dg'
-
set log_archive_dest_2='service=orcl lgwr async compression=enable valid_for=(online_logfile,primary_role) db_unique_name=orcl'
-
set audit_file_dest='/u01/app/oracle/admin/orcl_dg/adump'
-
set diagnostic_dest='/u01/app/oracle'
-
set cluster_database='false'
-
reset remote_listener
-
reset local_listener
-
reset db_create_file_dest
-
set undo_tablespace='undotbs1'
-
;
-
release channel prmy1;
-
release channel prmy2;
-
release channel prmy3;
-
release channel prmy4;
-
release channel stby1;
-
release channel stby2;
-
release channel stby3;
-
release channel stby4;
-
release channel stby5;
-
}
- eof
给主人留下些什么吧！~~