Oracle 控制文件操作记录

 

Oracle 控制文件操作记录

SQL> column name format a70
SQL> select * from v$controlfile;

STATUS  NAME                                                                                          IS_
------- ---------------------------------------------------------------------- ---
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON1.CTL                           NO
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON2.CTL                           NO

 

//关闭数据库, 复制旧的控制文件用以添加新控制文件, 修改PFile中的控制文件目录，添加新的控制文件
SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> host copy D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON1.CTL D:/oracle/product/10.1.0/oradata/DB3/con3.ctl

已复制         1 个文件。

 

//启动数据库
SQL> startup

ORACLE instance started.

Total System Global Area  163577856 bytes
Fixed Size                   787948 bytes
Variable Size             111933972 bytes
Database Buffers           50331648 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.

 

//查询控制文件表
SQL> select * from v$controlfile;

 

STATUS  NAME                                                                                          IS_
------- ---------------------------------------------------------------------- ---
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON1.CTL                           NO
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON2.CTL                           NO
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON3.CTL                           NO

 

//关闭数据库 将控制文件复制改名后放入backup后启动
SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

 

//启动数据库
SQL> startup

ORACLE instance started.

Total System Global Area  163577856 bytes
Fixed Size                   787948 bytes
Variable Size             111933972 bytes
Database Buffers           50331648 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.

 

//查询控制文件表
SQL> select * from v$controlfile;

STATUS  NAME                                                                                          IS_
------- ---------------------------------------------------------------------- ---
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON1.CTL                           NO
           D:/ORACLE/PRODUCT/10.1.0/ORADATA/DB3/CON2.CTL                           NO
           D:/ORACLE/BACKUP/DB3/CON3.CTL                                                     NO