非归档状态:
outline:
name | click me | 关库状态 | click me | 开启状态 | 操作 | 数据完整性 |
---|---|---|---|---|---|---|
inactivate | shut immediate | mount | 清空logs | 没关系 | ||
activatecurrent | shtu immediate | 隐含参数 | 丢失 |
process:
_audit_trail_file 的方法:
v$logfile;
冲坏方式:
关闭Db
ORA-03113: end-of-file on communication channel
Process ID: 3546
Session ID: 125 Serial number: 5
隐藏参数
:
desc v$parameter
desc v$spparameter
desc v$system_parameter
desc X$KSPPI-------------KSPPINM
desc X$KSPPCV---------------KSPPSTVL
set line 200
col KSPPINM for a40
col KSPPSTVL for a20
select KSPPINM,KSPPSTVL from X$KSPPI a ,X$KSPPCV b where a.indx=b.indx;
select KSPPINM,KSPPSTVL from X$KSPPI a ,X$KSPPCV b where a.indx=b.indx and KSPPINM like '\_%' escape '\'' and KSPPINM like '%resetlog%';
--查看隐藏参数
select KSPPINM,KSPPSTVL from X$KSPPI a ,X$KSPPCV b where a.indx=b.indx and KSPPINM like '\_%' escape '\' and KSPPINM like '%resetlog%';
开归档模式下的恢复:
模式确认-->
name | click me | 结束状态 | 状态 | click me | click me | 数据完整性 |
---|---|---|---|---|---|---|
log | 关库 | 关库 | 操作 | |||
Inactived | shut immediate | mount | 清空logs | OK | ||
activate | abort | force | 加seq | OK | ||
current | shut immediate | open before | 隐含参数+arch | 丢失 |
描述: