设为首页收藏本站

Bo's Oracle Station

查看: 106|回复: 0

课程第16次(2018-11-15星期四)

[复制链接]

745

主题

1118

帖子

8124

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
8124
发表于 2018-11-15 19:46:45 | 显示全部楼层 |阅读模式
日志切换也有增量检查点:
  1. Archived Log entry 124 added for thread 1 sequence 132 ID 0x501b221c dest 1:




  2. Thu Nov 15 19:44:12 2018
  3. Thread 1 cannot allocate new log, sequence 134
  4. Checkpoint not complete
  5.   Current log# 1 seq# 133 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
  6.   Current log# 1 seq# 133 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
  7. Thu Nov 15 19:44:13 2018
  8. Completed checkpoint up to RBA [0x85.2.10], SCN: 2503762
  9. Completed checkpoint up to RBA [0x84.2.10], SCN: 2503734
  10. Thread 1 cannot allocate new log, sequence 134
  11. Private strand flush not complete
  12.   Current log# 1 seq# 133 mem# 0: +DATA/orcl/onlinelog/group_1.261.816169635
  13.   Current log# 1 seq# 133 mem# 1: +FRA/orcl/onlinelog/group_1.257.816169637
  14. Beginning log switch checkpoint up to RBA [0x86.2.10], SCN: 2503855
  15. Thread 1 advanced to log sequence 134 (LGWR switch)
  16.   Current log# 2 seq# 134 mem# 0: +DATA/orcl/onlinelog/group_2.262.816169639
  17.   Current log# 2 seq# 134 mem# 1: +FRA/orcl/onlinelog/group_2.258.816169639
  18. Thu Nov 15 19:44:13 2018
  19. Archived Log entry 125 added for thread 1 sequence 133 ID 0x501b221c dest 1:
  20. Thu Nov 15 19:44:57 2018
复制代码
  1. select d.RESETLOGS_CHANGE#,
  2.             d.CHECKPOINT_CHANGE#,
  3.             d.CURRENT_SCN
  4.     from v_$database  d;
  5.    
  6.     select name , checkpoint_change#
  7.      from v_$datafile df;
  8.      
  9.      alter system checkpoint;
  10.      
  11.      alter system switch logfile;
  12.      
  13.      alter tablespace example offline;
  14.      
  15.      alter tablespace example online;
  16.      
  17.      select  log_mode from v$database;
  18.      
  19.      alter tablespace users begin backup;
  20.      
  21.      
  22.      alter tablespace users end backup;
  23.      
  24.      
  25.      
复制代码

  1. select  * from v$thread;

  2. select  * from v$log;

  3. alter system switch logfile;

  4. alter system checkpoint;

  5. alter database add logfile group 4 size 52428800 ;

  6. select  * from v$logfile;

  7. alter database add logfile member '+fra'  to group  2;

  8. alter database drop logfile member '+FRA/orcl/onlinelog/group_2.301.992295853';

复制代码


上完1Z0-052第1章(14/40),1Z0-053第1章(15/40)


回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2019-1-19 09:00 , Processed in 0.096132 second(s), 32 queries .

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