Oracle 启动阶段 OPEN-白红宇

Oracle 启动阶段 OPEN

阅读量：793 次

发布时间：2023-02-24

本文共 2244 字，大约阅读时间需要 7 分钟。

Oracle????????????

1. ?????????( SCN )

????Oracle???????????????????????????????????????( SCN )?????????????????????????SCN??????SCN??????????????????????????

2. ??????

?????Control File??Oracle????????????????????????????????????????????????????????

????????????????system01.dbf??????????????/DBBK/oracle/oradata/orcl/?

??????????0?????8192??????????7??????????Dup=1??

?????????ID?0????????????0?

SCN???SCN????????????????????scn: 0x0000.001d621a??2014-12-16 13:08:09?

3. ??????

?????Data File??Oracle??????????????????????????

????????????????system01.dbf?sysaux01.dbf?????????????/DBBK/oracle/oradata/orcl/?

??????????0?????8192??????????7??????????Dup=1??

SCN????????SCN??????????????????scn: 0x0000.001d621a??2014-12-16 13:08:09?

4. ???????

??????????????????????????????

??1??2014-12-16 13:08:16????1????????SCN?0x0000.000e6c20?

??0??2014-12-16 13:08:40????0????????SCN?0x0000.000e6c20?

??????????????????????????????????????

5. ??????

?????Redo Log File????????????????????????????

????????????????redo01.log?redo02.log?redo03.log????redo???????/DBBK/oracle/oradata/orcl/?

???SCN?????????????SCN??????????1?2014-12-16 13:08:16?????SCN?0x0000.000e6c20?

????????????????????????????

6. ????

???????????

?????????ALTER SYSTEM SET RESTORE POINT?????????

????????ALTER SYSTEM CREATE RESTORE POINT????????

?????????RECOVER DATABASE???????????????

?????????VERIFY DATABASE?????????

7. ??????

???????CheckPoint Cnt???????????????????

CheckPoint cnt: 183 scn: 0x0000.001d6f61???2015-01-05 09:14:06??????183?????

CheckPoint cnt: 182 scn: 0x0000.001d621a???2015-01-05 08:05:09??????182?????

8. ?????( SCN )

SCN????????????? SCN ??????

???? SCN???DBMS_FLASHBACK.GET_SYSTEM_change_number?????? SCN?

SCN ?????????SCN_TO_TIMESTAMP??? SCN ??????????

?? SCN ??????????? SCN ????????????

9. ????????

?????????????????????????????????

???????????restore_point_1?restore_point_2??

????????????????? SCN?

????????????????????????????

10. ?????

???????v$database?v$datafile_header?????????

DBID: ???ID?1394247230?

Checkpoint Change#: 2078903?

Checkpoint Time: 2015-01-06 08:06:35?

?????????????????????????

11. ????

?????????????????

????????????????????????????????????

???????????????????????

????????????????????????????

?????????????Oracle????????????????

转载地址：http://cxpfk.baihongyu.com/

你可能感兴趣的文章

oobbs开发手记

查看>>

OPEN CASCADE Curve Continuity

查看>>

Open Graph Protocol(开放内容协议)

查看>>

Open vSwitch实验常用命令

查看>>

Open WebUI 忘了登入密码怎么办？

查看>>

Open-E DSS V7 应用系列之五构建软件NAS

查看>>

open-vm-tools-dkms : 依赖: open-vm-tools (>= 2:9.4.0-1280544-5ubuntu3) 但是它将不会被安装

查看>>

open3d-Dll缺失，未找到指定模块解决

查看>>

Openbox-桌面图标设置

查看>>

opencart出现no such file or dictionary

opencv videocapture读取视频cap.isOpened 输出总是false

查看>>

opencv waitKey() 函数理解及应用

OpenCV 在 Linux 上的 python 与 anaconda 无法正常工作.收到未实现 cv2.imshow() 的错误

查看>>

Opencv 完美配置攻略 2014 (Win8.1 + Opencv 2.4.8 + VS 2013)上

查看>>

opencv 模板匹配，已解决模板过大程序不工作的bug

查看>>

OpenCV 错误:(-215)size.width＞0 &&函数imshow中的size.height＞0

查看>>