Bo's Oracle Station

查看: 2020|回复: 0

课程第13/14次(2018-03-07星期三,2018-03-12星期一)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2018-3-7 20:31:00 | 显示全部楼层 |阅读模式
  1. select s. username , s.SID ,s.SERIAL# ,s.SQL_ID , s.SQL_HASH_VALUE
  2. from v_$session s
  3. 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. 1)    Incremental 1831497(<1833000要做增量检查点) RBA ->(想把检查点位置移动到这里)0x6c.440d.0(0x6c.4a79.0)
  2. 不写了的原因fast_start_mttr_target
  3. 2)1831497  Incremental(<1835000) RDB->0x6c.6318.0(0x6c.6657.0)
  4. 不写了的原因fast_start_mttr_target

  5. 0x6d.2.10  1836090


  6. 1+2+日志切换(助力), 的结果0x6d.2.10  1836090

复制代码
  1. select d.RESETLOGS_CHANGE#,
  2.           d.CHECKPOINT_CHANGE#,
  3.           d.CURRENT_SCN
  4. from v_$database d;

  5. select  d.CHECKPOINT_CHANGE# ,d.NAME
  6.   from v_$datafile d;
  7.   
  8.   select  * from v$log;
  9.   
  10.   alter system switch logfile;
  11.   
  12.     alter system switch logfile;
  13.    
  14.    
  15.     alter system checkpoint;
  16.         
  17.     alter database drop logfile group 1;
  18.    
  19.     alter database add logfile group 1  size  50M;
  20.    
  21.     select  * from v$log;
  22.    
  23.     select  * from v$logfile;
  24.    
  25.     alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02c.log' to group 2  ;
  26.    
  27.     alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo02c.log';
  28.    
  29.         alter system switch logfile;
  30.         
  31.       alter database drop logfile member '/u01/app/oracle/oradata/orcl/redo02c.log';   
  32.       
  33.           select  * from v$logfile;
复制代码


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 04:40 , Processed in 0.036433 second(s), 24 queries .

快速回复 返回顶部 返回列表