|
- select s. username , s.SID ,s.SERIAL# ,s.SQL_ID , s.SQL_HASH_VALUE
- from v_$session s
- where s.TERMINAL='pts/1' ;
复制代码 Mon Mar 12 19:23:56 2018
ALTER SYSTEM SET log_checkpoints_to_alert=TRUE SCOPE=BOTH;
Mon Mar 12 19:26:27 2018
Incremental checkpoint up to RBA [0x6c.440d.0], current log tail at RBA [0x6c.4a79.0]
Mon Mar 12 19:57:31 2018
Incremental checkpoint up to RBA [0x6c.6318.0], current log tail at RBA [0x6c.6657.0]
Mon Mar 12 20:00:34 2018
Beginning log switch checkpoint up to RBA [0x6d.2.10], SCN: 1836090
Thread 1 advanced to log sequence 109 (LGWR switch)
Current log# 1 seq# 109 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
Current log# 1 seq# 109 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
Mon Mar 12 20:00:34 2018
Archived Log entry 100 added for thread 1 sequence 108 ID 0x501b221c dest 1:
Mon Mar 12 20:05:47 2018
Completed checkpoint up to RBA [0x6d.2.10], SCN: 1836090
- 1) Incremental 1831497(<1833000要做增量检查点) RBA ->(想把检查点位置移动到这里)0x6c.440d.0(0x6c.4a79.0)
- 不写了的原因fast_start_mttr_target
- 2)1831497 Incremental(<1835000) RDB->0x6c.6318.0(0x6c.6657.0)
- 不写了的原因fast_start_mttr_target
- 0x6d.2.10 1836090
- 1+2+日志切换(助力), 的结果0x6d.2.10 1836090
复制代码- select d.RESETLOGS_CHANGE#,
- d.CHECKPOINT_CHANGE#,
- d.CURRENT_SCN
- from v_$database d;
-
- select d.CHECKPOINT_CHANGE# ,d.NAME
- from v_$datafile d;
-
- select * from v$log;
-
- alter system switch logfile;
-
- alter system switch logfile;
-
-
- alter system checkpoint;
-
- alter database drop logfile group 1;
-
- alter database add logfile group 1 size 50M;
-
- select * from v$log;
-
- select * from v$logfile;
-
- alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02c.log' to group 2 ;
-
- alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo02c.log';
-
- alter system switch logfile;
-
- alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo02c.log';
-
- select * from v$logfile;
复制代码
|
|