控制文件管理-CSDN博客

#查看控制文件的位置
SQL> select value from v$parameter where name='control_files';

VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ENMOEDU/control01.ctl, /u01/app/oracle/fast_recovery_are
a/ENMOEDU/control02.ctl

SQL> show parameter control_files;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/ENMOEDU/control01.ctl,

/u01/app/oracle/fast_recovery_area/ENMOEDU/control02.ctl

SQL> select status,name from v$controlfile;

STATUS
-------
NAME
--------------------------------------------------------------------------------

/u01/app/oracle/oradata/ENMOEDU/control01.ctl

/u01/app/oracle/fast_recovery_area/ENMOEDU/control02.ctl

#控制文件的内容

SQL> desc v$controlfile_record_section
Name Null? Type
----------------------------------------- -------- ----------------------------
TYPE VARCHAR2(28)
RECORD_SIZE NUMBER
RECORDS_TOTAL NUMBER
RECORDS_USED NUMBER
FIRST_INDEX NUMBER
LAST_INDEX NUMBER
LAST_RECID NUMBER

SQL> select TYPE,RECORD_SIZE, RECORDS_TOTAL , RECORDS_USED from v$controlfile_record_section;

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
---------------------------- ----------- ------------- ------------
DATABASE 316 1 1
CKPT PROGRESS 8180 11 0
REDO THREAD 256 8 1
REDO LOG 72 16 3
DATAFILE 520 100 7
FILENAME 524 2298 11
TABLESPACE 68 100 7
TEMPORARY FILENAME 56 100 1
RMAN CONFIGURATION 1108 50 0
LOG HISTORY 56 292 86
OFFLINE RANGE 200 163 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
---------------------------- ----------- ------------- ------------
ARCHIVED LOG 584 28 0
BACKUP SET 40 409 0
BACKUP PIECE 736 200 0
BACKUP DATAFILE 200 245 0
BACKUP REDOLOG 76 215 0
DATAFILE COPY 736 200 0
BACKUP CORRUPTION 44 371 0
COPY CORRUPTION 40 409 0
DELETED OBJECT 20 818 0
PROXY COPY 928 246 0
BACKUP SPFILE 124 131 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
---------------------------- ----------- ------------- ------------
DATABASE INCARNATION 56 292 1
FLASHBACK LOG 84 2048 0
RECOVERY DESTINATION 180 1 1
INSTANCE SPACE RESERVATION 28 1055 1
REMOVABLE RECOVERY FILES 32 1000 0
RMAN STATUS 116 141 0
THREAD INSTANCE NAME MAPPING 80 8 8
MTTR 100 8 1
DATAFILE HISTORY 568 57 0
STANDBY DATABASE MATRIX 400 31 31
GUARANTEED RESTORE POINT 212 2048 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
---------------------------- ----------- ------------- ------------
RESTORE POINT 212 2083 0
DATABASE BLOCK CORRUPTION 80 8384 0
ACM OPERATION 104 64 6
FOREIGN ARCHIVED LOG 604 1002 0

从输出可以看出控制文件存放了数据库的信息，重做日志的信息，数据文件以及归档日志文件记录等信息
#v$backup v$database v$tempfile v$tablespace v$archive v$log v$logfile
v$loghist v$archived_log v$database都是从控制文件中获取数据

例如 SQL> select name,created,log_mode from v$database;

NAME CREATED LOG_MODE
--------- --------- ------------
ENMOEDU 07-OCT-13 NOARCHIVELOG

#多路复用控制文件
SQL> alter system set control_files='/u01/app/oracle/oradata/ENMOEDU/control03.ctl','/u01/app/oracle/oradata/ENMOEDU/control01.ctl' scope=spfile;
SQL> shutdown immediate
[oracle@ENMOEDU ENMOEDU]$ cp control03.ctl control01.ctl
SQL> startup
SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /u01/app/oracle/oradata/ENMOEDU/control03.ctl,

/u01/app/oracle/oradata/ENMOEDU/control01.ctl

#备份控制文件到跟踪文件
SQL> alter system set sql_trace=true;

System altered.

SQL> alter database backup controlfile to trace
2 ;

Database altered.

SQL> show parameter user_dump_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /u01/app/oracle/diag/rdbms/enmoedu/ENMOEDU/trace

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29438041/viewspace-1140526/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29438041/viewspace-1140526/