检查日志的同步状态和应用日志序列号
关库、删除备库文件、启动到nomount
shutdown immediate
sqlplus / as sysdba
startup nomount
拷贝口令文件,并设置密码
orapwd file=?/dbs/orapwtestdb password=oracle entries=10 force=y ignorecase=Y
同步文件,时间有点久
rman target sys/oracle@db1 auxiliary sys/oracle@db2
duplicate target database for standby from active database nofilenamecheck;
(相同路径目录使用 nofilenamecheck )
启动同步
shutdown immediate;
startup nomount;
alter database mount standby database;
alter database open read only;
alter database recover managed standby database using current logfile disconnect from session;
检查同步状态
select open_mode,protection_mode,database_role,switchover_status from v$database;
select max(sequence#) from v$log;--检查两边的序列好,是否一致
主库切换日志,查看备库应用状态
select thread#,sequence#,standby_dest,archived,applied,status from v$archived_log;
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3/24'; ---删除归档
附:using current logfile 实时应用日志
SQL> set line 180 pagesize 1000
SQL> select process,status,GROUP#,thread#,sequence# from v$managed_standby;
MRP两次状态的差异,当未使用“using current logfile”时,MRP0的STATUS状态是【WAIT_FOR_LOG】;
当使用“using current logfile”,MRP0的STATUS状态是【APPLYING_LOG】
注意:使用 using current logfile
在maxmize pretection,maxmize availability中必须
要有standby logfile,为了避免数据的损失最少,maxmize performance 也最好创建standby logfile,考虑角色切换
primary库也要创建standby logfile,
standby logfile创建的要求, 与primary的redo logfile的大小相同,个数要至少多一个
select member from v$logfile;
alter database recover managed standby database cancel;
alter database add standby logfile group 6 '/oradata/lngrid/stdredo01.log' size 500m;
alter database add standby logfile group 7 '/oradata/lngrid/stdredo02.log' size 500m;
alter database recover managed standby database using current logfile disconnect from session;
Oracle 11g 使用duplicate from active database 创建物理ADG
https://blog.csdn.net/fffygapl/article/details/8603115