standby管理和维护.docVIP

standby 管理和维护  HYPERLINK /mon.php?action=viewspaceop=upitemid=631338uid上一篇 /  HYPERLINK /mon.php?action=viewspaceop=nextitemid=631338uid下一篇 ?2010-04-05 11:59:36 / 个人分类： HYPERLINK spacelist-blog-itemtypeid-79413 基础知识  HYPERLINK viewspace-631338 \l xspace-tracks 查看( 70 ) /  HYPERLINK viewspace-631338 \l xspace-itemreply 评论( 0 ) /  HYPERLINK viewspace-631338 \l xspace-itemform 评分( 0 / 0 )  HYPERLINK javascript:; \t _self standby  HYPERLINK javascript:; \t _self 管理和维护 查询库状态：??? SQLselect name,switchover_status,open_mode,protection_mode,database_role? from v$database; 验证archive log是否接收和applied.??? SQLalter session set nls_date_format=yyyy-mm-dd hh24:mi:ss;??? SQLselect sequence#,dest_id,archived,applied,deleted,status,first_time from v$archived_log order by sequence#; 启动到管理模式:??? SQL shutdown immediate;??? SQL startup nomount??? SQL alter database mount standby database;??? SQL recover managed standby database disconnect from session;??? ---------- ??? SQL alter database recover managed standby database disconnect from session; ???  HYPERLINK javascript:; \t _self 10g以后，采用联机日志的传递传递方式??? SQL recover managed standby database using current logfile disconnect from session; 启动到只读模式：??? SQL shutdown immediate;??? SQL startup nomount??? SQL alter database mount standby database??? SQL alter databae open read only; 在管理模式恢复到只读模式：??? SQL recover managed standby database cancel;??? SQL alter database open read only 在只读模式可以给 HYPERLINK javascript:; \t _self 数据库添加临时数据文件(在 HYPERLINK javascript:; \t _self rman HYPERLINK javascript:; \t _self 备份是没有备份的),想让standby提供只读服务或者切换成主库，最好先增加临时文件??? SQL alter tablespace temp add tempfile C:\oracle\product\10.2.0\oradata\dgtest\temp02.dbf size 100m; 只读模式到管理模式??? SQL recover managed standby database disconnect from session; 在备库进行备份??? 1.停止应用程序，跳转到 read only模式，同时用backup database命令来备份数据库，这样数据库处于一致性模式??? 2.备份完成后，备份控制文件??? SQL alter databa