当前位置：首页 -> 基础 -> 数据库编程

手工恢复控制文件的深入解析(二)

2014-11-24 12:31:01 · 作者: · 浏览: 1
标签: 手工 恢复 控制 文件 深入 解析
from v$datafile;
CHECKPOINT_CHANGE#
------------------
4935675
4935675
4935675
4935675
4935675
4935675
4935675
4935675
4935675
4935675
4935675
CHECKPOINT_CHANGE#
------------------
4935675
已选择12行。
23:26:31 SYS@orcl#alter system checkpoint;
系统已更改。
23:27:27 SYS@orcl#select CHECKPOINT_CHANGE#,CONTROLFILE_SEQUENCE#,CONTROLFILE_CHANGE# from v$database;
CHECKPOINT_CHANGE# CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
------------------ --------------------- -------------------
4937086 14336 4937088
23:27:31 SYS@orcl#select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
4937086
4937086
4937086
4937086
4937086
4937086
4937086
4937086
4937086
4937086
4937086
CHECKPOINT_CHANGE#
------------------
4937086
已选择12行。
23:27:32 SYS@orcl#
v$datafile_header. CHECKPOINT_CHANGE# （代表数据文件头的检查点scn，这个值和数据文件的检查点相一致，在数据库运行到open状态进行的数据文件dump文件中的header 中的checkpoint scn就是此值。）
23:35:32 SYS@orcl#col file# for 99
23:35:43 SYS@orcl#col name for a70
23:35:52 SYS@orcl#r
1* select a.file#,a.name,b.ts#,b.name from v$datafile a,v$tablespace b where a.ts#=b.ts#
FILE# NAME TS# NAME
----- ---------------------------------------------------------------------- ---------- ----------------------------------------------------------------------
1 /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf 0 SYSTEM
2 /opt/oracle/oradata/ORCL/datafile/o1_mf_sysaux_8no736vh_.dbf 1 SYSAUX
3 /opt/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_8no736w0_.dbf 2 UNDOTBS1
4 /opt/oracle/oradata/ORCL/datafile/o1_mf_users_8no75m69_.dbf 4 USERS
5 /opt/oracle/oradata/ORCL/datafile/huadan 6 VPN_HUADAN
6 /opt/oracle/oradata/sysaux_add.dbf 1 SYSAUX
7 /opt/oracle/oradata/system_add.dbf 0 SYSTEM
8 /opt/oracle/oradata/test1.dbf 7 TEST1
9 /opt/oracle/oradata/ORCL/datafile/bigtablespace.dbf 11 BIGTABLESPACE
10 /opt/oracle/oradata/ORCL/datafile/undotbs02.dbf 5 UNDOTBS2
11 /opt/oracle/oradata/ORCL/datafile/test2.dbf 12 TEST2
FILE# NAME TS# NAME
----- ---------------------------------------------------------------------- ---------- ----------------------------------------------------------------------
12 /opt/oracle/oradata/ORCL/datafile/test3.dbf 13 TEST3
已选择12行。
23:35:54 SYS@orcl#show user;
USER 为 "SYS"
23:36:09 SYS@orcl#select default_tablespace from dba_users where username='SYS';
DEFAULT_TABLESPACE
------------------------------------------------------------
SYSTEM
23:36:30 SYS@orcl#
23:38:43 SYS@orcl#select CHECKPOINT_CHA