■修改初始化參數(shù)control_files

SQL> alter system set control_files=
??? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control01.ctl',
??? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control02.ctl',
??? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control03.ctl',
??? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control04.ctl'
??? scope=SPFILE;
?
?- MAXDATAFILES: 指定最大數(shù)據(jù)文件的個數(shù)
?- MAXLOGFILES: 指定最大重做日志文件的個數(shù)
?- MAXLOGMEMBERS: 指定重做日志文件中每個組成員的個數(shù)
?- MAXLOGHISTORY: 指定控制文件可記載的重做日志歷史的最大的個數(shù)
?- MAXINSTANCES: 指定可以同時訪問數(shù)據(jù)庫的最大例程的個數(shù)

■將控制文件備份為二進(jìn)制文件
? SQL> alter database backup controlfile to '/tmp/yuhj/controlfile_061124.bak';

■將控制文件備份為文本文件
? SQL> alter database backup controlfile to trace;
? 跟蹤備份被存放在由初始化參數(shù)USER_DUMP_DEST指定的目錄中.

SQL> show parameter user_dump_dest;?????????????????????????????????????????????????????????????????????????????????????????????????
NAME???????????????????????????????? TYPE??????? VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest?????????????????????? string????? /export/home/opt/product/10.1.
???????????????????????????????????????????????? 0.3.0/admin/ldfsys/udump
■CREATE CONTROLFILE語句
? create controlfile reuse database ldfsys noresetlogs noarchivelog
? MAXLOGFILES 16
? MAXLOGMEMBERS 3
? MAXDATAFILES 100
? MAXINSTANCES 8
? MAXLOGHISTORY 454
? LOGFILE
? GROUP 1 '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/redo01.log'? SIZE 10M,
? GROUP 2 '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/redo02.log'? SIZE 10M,
? GROUP 3 '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/redo03.log'? SIZE 10M
? datafile
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/system01.dbf',
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/undotbs01.dbf',
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/sysaux01.dbf',
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/users01.dbf'
? CHARACTER SET ZHS16GBK
? /

■刪除控制文件
SQL> alter system set control_files=???????????????????????????????????????????????????????????
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control01.ctl',???????????????????
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control02.ctl',??????????????????
? '/export/home/opt/product/10.1.0.3.0/oradata/ldfsys/control03.ctl'???????????????
? scope=spfile;???????
? 就是把刪除的控制文件直接去掉,然后重新設(shè)置下就可以了,然后重新啟動一個oracle.
?
■查詢控制文件信息
? - V$CONTROLFILE???????????????? 控制文件名稱?
? - V$CONTROLFILE_RECORD_SECTION?控制文件記錄文檔段的信息
? - V$PARAMETER????初始化參數(shù)CONTROL_FILES指定控制文件名稱