一定要先在主库建standby日志组
配置网络监听:
sqlplus sys/oracle@PROD1 as sysdba
sqlplus sys/oracle@SBDB1 as sysdba
修改参数文件:
根据修改好的参数文件创建相应的目录
create spfile from pfile;
startup nomount
用rman duplicate 复制数据库:
rman target sys/oracle@to_pd auxiliary sys/oracle@to_sd nocatalog;
RMAN> duplicate target database for standby from active database;
--如果从库的数据库的位置和主库的位置一样要添加nofilenamecheck文件名不检查
RMAN> duplicate target database for standby from active database nofilenamecheck;
完毕后从库回自动到mount状态
alter database open;
--启动mrp服务
SQL> alter database recover managed standby database disconnect from session;
--停止mrp服务
SQL> alter database recover managed standby database cancel;
测试:
主库
SQL> create table dg_test as select * from scott.emp;
SQL> insert into dg_test select * from dg_test;
SQL> commit;
SQL> alter system switch logfile;
从库
SQL> select sequence#,applied from v$archived_log;
SQL> select * from dg_test;