准备工作
iptables -L
setenforce 0
lsnrctl start
备库启动遇到问题
SQL> startup
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/orcl/system01.dbf‘
原因是由于某些redo没有传输到备库,可能落后了很多归档文件
处理:
1)备库查询:SQL>select process,client_process,sequence#,status from v$managed_standby;//定位正在应用的日志文件
select max(sequence#) from v$archived_log;
2)主库查询:SQL> select process,client_process,sequence#,status from v$managed_standby;//查询主库当前写到的日志文件
select max(sequence#) from v$archived_log;
3)对比备库与主库之间的待传输应用日志文件,从主库拷贝到备库归档路径
4)备库注册
ALTER DATABASE REGISTER PHYSICAL LOGFILE ‘/u01/app/oracle/archivelog/xxx.dbf‘ ;
5)备库应用redo
alter database recover managed standby database disconnect from session;