checkpoint触发的条件1)手工触发当手工发出alter system checkpoint 等命令时触发(实际上alter system flush buffer chache 也会触发)一般我们在进行重大操作的时,可以手工触发检查点,然后多切换几次redo logfile,再去shutdown.这样可以保证数据库的脏块尽可能的都完全写入到disk中,同时也能保证实例open时,能尽...【阅读全文】
create table t1 as select object_id,object_name from dba_objects where object_id<10;alter system switch logfile;SQL> select member from v$logfile;MEMBER--------------------------------------------------------------------------------/home/oracle/app/oradata/oracleogg/redo03.log/home/oracle/ap...【阅读全文】
1.cmd命令窗口使用sqlplus连接到sql,用archive log list命令查询是否开启归档模式,我这里已开了归档模式;C:\Users\Administrator>sqlplusSQL*Plus: Release 11.2.0.1.0 Production on 星期三 9月 13 11:14:02 2017Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: system/oracl...【阅读全文】
DG BROKER关闭DG以及打开DG步骤1.进入dgmgrl管理oracle@oratest:~> dgmgrl /DGMGRL for Linux: Version 11.2.0.4.0 - 64bit ProductionCopyright (c) 2000, 2009, Oracle. All rights reserved.Welcome to DGMGRL, type "help" for information.Connected.2.检查DG状态DGMGRL> show configuration verbose;Co...【阅读全文】