physical standby

一、手动创建数据库
------------------------------------------------------
二、dataguard
---------------------------
1、primary database设置
---------------------------
startup mount
alter database force logging
alter database archivelog;
orapwd file=/home/oracle/app/oracle/product/db_1/dbs/orapworadg1 password=password force=y
---------------------------
2、primary database创建standby log
alter database create standby logfile group 4('/u01/app/oracle/oradata/oradg1/stdby_redo04.log') size 50m;
alter database create standby logfile group 5('/u01/app/oracle/oradata/oradg1/stdby_redo05.log') size 50m;
alter database create standby logfile group 6('/u01/app/oracle/oradata/oradg1/stdby_redo06.log') size 50m;
alter database create standby logfile group 7('/u01/app/oracle/oradata/oradg1/stdby_redo07.log') size 50m;
---------------------------
3、网络配置
---------------------------
primary database tnsnames.ora
---------------------------
net_oradg2 =
(DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 139.0.0.21)(PORT = 1521))
  )
 (CONNECT_DATA =
  (SERIVCE_NAME = oradg2)
  )
)
---------------------------
primary database listener.ora
---------------------------
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
   (ORACLE_HOME = /home/oracle/app/oracle/product/db_1)
   (SID_NAME = oradg1)
LISTENER =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 139.0.0.20)(PORT = 1521)
    )
   )
  )
---------------------------
standby database tnsnames.ora
---------------------------
net_oradg1 =
(DESCRIPTION =
 (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 139.0.0.20)(PORT = 1521))
  )
 (CONNECT_DATA =
  (SERIVCE_NAME = oradg1)
  )
)
---------------------------
standby database listener.ora
---------------------------
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
   (ORACLE_HOME = /home/oracle/app/oracle/product/db_1)
   (SID_NAME = oradg2)
LISTENER =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 139.0.0.21)(PORT = 1521)
    )
   )
  )
---------------------------
4、参数设置
---------------------------
primary database
---------------------------
db_name=oradg
db_unique_name=oradg1
instance_name=oradg1
log_archive_config='db_config=oradg1,oradg2'
log_archive_dest_1='location=/u01/arch/ db_unique_name=oradg1'
log_archive_dest_2='service=net_oradg2 db_unique_name=oradg2'
log_archive_dest_state_1=enable
log_archive_dest_state_2=defer
remote_login_passwordfile=exclusive

fal_server=net_oradg2
fal_client=net_oradg1
db_file_name_convert='/u01/app/oracle/oradata/oradg2/,/u01/app/oracle/oradata/oradg1/'
log_file_name_convert='/u01/app/oracle/oradata/oradg2/,/u01/app/oracle/oradata/oradg1/'
standby_file_management=auto
---------------------------
standby database
---------------------------
db_name=oradg
db_unique_name=oradg2
instance_name=oradg2
control_files='/u01/app/oracle/oradata/oradg2/standby.ctl'
log_archive_config='db_config=oradg1,oradg2'
log_archive_dest_1='location=/u01/arch/ db_unique_name=oradg2'
log_archive_dest_2='service=net_oradg1 db_unique_name=oradg1'
log_archive_dest_state_1=enable
log_archive_dest_state_2=defer
remote_login_passwordfile=exclusive

fal_server=net_oradg1
fal_client=net_oradg2
db_file_convert_name='/u01/app/oracle/oradata/oradg1/,/u01/app/oracle/oradata/oradg2/'
log_file_convert_name='/u01/app/oracle/oradata/oradg1/,/u01/app/oracle/oradata/oradg2/'
standby_file_management=auto
---------------------------
5、备份恢复
---------------------------
primary database登陆
sqlplus / as sysdba
alter database create standby controlfile as '/u01/app/oracle/oradata/oradg1/standby.ctl';
alter database begin backup;
复制数据文件（包括undo和temp）和standby.ctl到备库/u01/app/oracle/oradata/oradg2/目录下
---------------------------
6、启动数据库
---------------------------
登陆到备库
export ORACLE_SID=oradg2
orapwd file=/home/oracle/app/oracle/product/db_1/dbs/orapworadg2 password=password force=y
sqlplus / as sysdba

create spfile from pfile;
startup mount
recover managed standby database disconnect from session;
---------------------------
7、同步实验
---------------------------
主库操作

alter database end backup;
conn magy/magy
create table t1 (a number,b number);
begin
for i in 1..5000
loop
insert into t1 values(i,i);
end loop;
commit;
end;
/
conn / as sysdba
alter system switch logfile;

备库操作
recover managed standby database cancel;
alter database open;
conn magy/magy
select count(1) from t1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23382569/viewspace-747148/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23382569/viewspace-747148/