Shulou(Shulou.com)06/01 Report--

1. Set relevant parameters on primary

Alter system set log_archive_config='dg_config= (orcl,orcla,orclb) 'scope=both sid='*'

Alter system set log_archive_dest_1='LOCATION=+ARCH/ORCL/ARCHIVELOG valid_for= (all_logfiles,all_roles) db_unique_name=orcl' scope=both sid='*'

Alter system set log_archive_dest_2='service=orcla valid_for= (online_logfiles,primary_role) db_unique_name=orcla lgwr async 'scope=both sid='*'

Alter system set log_archive_dest_3='service=orclb valid_for= (online_logfiles,primary_role) db_unique_name=orclb lgwr async' scope=both sid='*'

Alter system set log_archive_dest_state_2='defer' scope=both sid='*'

Alter system set log_archive_dest_state_3='defer' scope=both sid='*'

Alter system set log_archive_max_processes=30 sid='*'

Alter system set fal_server='orcla,orclb' scope=both sid='*'

Alter system set fal_client='orcl' scope=both sid='*'

Alter system set standby_file_management='auto'

Alter system set db_file_name_convert='+ORADATA','+ORADATA' scope=spfile

Alter system set log_file_name_convert='+ORADATA','+ORADATA' scope=spfile

2. Add standby redo

Alter database add standby logfile thread 1 group 4 ('/ data0/u01/app/oracle/oradata/ora11g/standby_redo04.log') size 50m; alter database add standby logfile thread 1 group 5 ('/ data0/u01/app/oracle/oradata/ora11g/standby_redo05.log') size 50m; alter database add standby logfile thread 1 group 6 ('/ data0/u01/app/oracle/oradata/ora11g/standby_redo06.log') size 50m Alter database add standby logfile thread 1 group 7 ('/ data0/u01/app/oracle/oradata/ora11g/standby_redo07.log') size 50m alter database add standby logfile thread 1 group 5 size 50m, group 6 size 50m, group 7 size 50m alter database add standby logfile thread 2 group 8 size 50m, group 9 size 50m, group 10 size 50m

3. Prepare the library

Install software, configure environment variables

Configure listening files listener.ora and tnsnames.ora

Note that the SID_NAME in linstener.ora specifies $ORACLE_SID.

DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET "db_unique_name" = "orcla" SET LOG_ARCHIVE_DEST_2= "service=orcla ASYNC REGISTER VALID_FOR= (online_logfile,primary_role)" SET FAL_CLIENT= "orcla" SET FAL_SERVER= "orcl" NOFILENAMECHECK For the above process, rman automatically copies the parameter files on the server side to the standby side, then starts to the nomount state, restores the control files, and copies all data files, temporary tablespaces and archived logs to the standby database. And then recovery.

4. Log in to rman on both sides of the standby.

Rman target sys/oracle@orcl auxiliary sys/oracle@orcla nocatalogduplicate target database for standby from active database nofilenamecheckALTER DATABASE OPEN READ ONLY;RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;SQL > col DEST_NAME format a30SQL > col DESTINATION format a30SQL > SELECT dest_name, status, destination FROM vault archivedestination; reference-- http://www.cnblogs.com/Bccd/p/6362786.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.