Oracle 控制文件操作记录

来源：互联网发布：人工智能产业链股票编辑：程序博客网时间：2024/04/28 18:12

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.

//查询控制文件表
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