oracle 10G减少和增加控制文件个数

核心提示：2 '/fantlam/oradata/fantlam/control01.ctl',3 '/fantlam/oradata/fantlam/control02.ctl',4 '/fantlam/oradata/fantlam/controlfile/control03.c

2 '/fantlam/oradata/fantlam/control01.ctl',
3 '/fantlam/oradata/fantlam/control02.ctl',
4 '/fantlam/oradata/fantlam/controlfile/control03.ctl'
5 scope=spfile;

System altered.
2. 关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
3. 复制控制文件到刚才指定的位置
host cp /fantlam/oradata/fantlam/control02.ctl /fantlam/oradata/fantlam/controlfile/control03.ctl
4. 启动数据库
SQL> startup
ORACLE instance started.

Total System Global Area 268435456 bytes
Fixed Size 1218868 bytes
Variable Size 79693516 bytes
Database Buffers 180355072 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
5. 查看v$controlfile视图验证
SQL> select * from v$controlfile;

STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- -------------------------------------------------- --- ---------- --------------
/fantlam/oradata/fantlam/control01.ctl NO 16384 430
/fantlam/oradata/fantlam/control02.ctl NO 16384 430
/fantlam/oradata/fantlam/controlfile/control03.ctl NO 16384 430