Oracle dataguard的配置(二)
.启动备库
Conn /as sysdba
Create pfile from pfile
Startup nomount
Alter database mount standby database;
Select name,database_role from v$database;
Alter database recover managed standby database disconnect from session;
16.可以建表测试
主库create table a (id1 number,id2 number);
Insert into a values(1,1);
Commit;
Alter system switch logfile;
Alter system switch logfile;
Alter system switch logfile;
备库 select sequence#,first_name,next_time from v$archive_log orader by sequence#;
Select sequence#,applied from v$archived_log order by sequence#;
Alter database recover managed standby database cancel;
Alter database open read only;
Select * from a;
Alter database recover managed standby database disconnect from session; 启动redo应用
17.主备库切换
www.2cto.com
更改主数据库为备用状态
Alter database commit to switchover to physical standby;
关闭主
数据库
Shutdown immediate;
在备用模式启动主数据库
Startup nomount;
alter database mount standby database;
select name,open_mode,protection_mode,database_role from v$database;
alter database recover managed stanby database disconnect from session;
www.2cto.com
打开备用数据库
Conn / sysdba
Alter database commit to switchover primary;
Shutdown immediate;
Startup
Alter system switch logfile;
18.failover
在standby 上
Alter database recover managed standby database finish;
Alter database recover managed standby database skip standby logfile;
Alter database commit to switchover to primary;
Shutdown immediate;
Startup;
www.2cto.com
19. Alter database recover managed standby database cancel;
Alter database open read only;
如果直接切换到主库
alter database commit to switchover to primary;会报错
ORA-16139: media recovery required
必须执行
alter database recover managed stanby database disconnect from session;
alter database commit to switchover to primary;