的文件
这里我们要实验的是数据库在的状态下,破快控制文件,数据库会不会
查看的路径
,
破坏控制文件
/u01/app/oracle/fast_recovery_area/orcl/control02.ctl
验证数据库的状态
做检查点,切换
检查点不完整
这是为什么呢?那是因为其进程持有的句柄并有释放,如下
8427
8427
跟踪
这里说一个命令
举一个例子
上面的含义是跟踪进程的所有系统调用(),并统计系统调用的花费时间,以及开始时间(并以可视化的时分秒格式显示),最后将记录结果存在文件里面
观察
8427,,,,,,0.000156 gettimeofday ({443228, 1518265363}, NULL)=0
8427,,,,,,0.000176 gettimeofday ({106769, 1518265543}, NULL)=0
8427,,,,,,0.000077 gettimeofday ({106845, 1518265543}, NULL)=0
8427,,,,,,0.000072 gettimeofday ({106917, 1518265543}, NULL)=0
8427,,,,,, pwrite64 (0.000077 256 , “25 \ \ 302 \ \ 0 \ \ \ \ 0 \ 0 \ \ \ 0 \ 0 \ \ 1 \ 4 \ 312 t \ 0 \ \ 2 \ \ 0 \ 0 \ \ 0 \ \ 0问\ \ 0 \ 0”… 16384年, 49152 )=16384
8427,,,,,,0.006462 gettimeofday ({113463, 1518265543}, NULL)=0
8427,,,,,,0.000089 gettimeofday ({113548, 1518265543}, NULL)=0
8427,,,,,, pwrite64 (0.000080 257 , “25 \ \ 302 \ \ 0 \ \ \ \ 0 \ 0 \ \ \ 0 \ 0 \ \ 1 \ 4 \ 312 t \ 0 \ \ 2 \ \ 0 \ 0 \ \ 0 \ \ 0问\ \ 0 \ 0”… 16384年, 49152 )=16384
8427,,,,,,0.000734 gettimeofday ({114364, 1518265543}, NULL)=0
8427,,,,,,0.000081 gettimeofday ({114443, 1518265543}, NULL)=0
8427,,,,,,0.000081 gettimeofday ({114525, 1518265543}, NULL)=0
8427,,,,,,0.000078 gettimeofday ({114603, 1518265543}, NULL)=0
8427,,,,,,0.000211 gettimeofday ({114816, 1518265543}, NULL)=0
8427,,,,,,0.000080 gettimeofday ({114891, 1518265543}, NULL)=0
8427,,,,,,0.000081 pread64 25 (256,“\ \ 302 \ \ 0 \ \ \ \ 0 \ 0 \ \ \ 0 \ 0 \ \ 1 \ 4 r \ t \ 0 \ \ 0 \ \ 0 \ \ 0 \ 0 v \ \ 373 \ 21 y”……、16384、16384)=16384
这的是表示的是文件描述符