WEB开发网
开发学院数据库Oracle oracle 10G减少和增加控制文件个数 阅读

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

 2012-08-26 08:50:33 来源:WEB开发网   
核心提示: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

上一页  1 2 

Tags:oracle 减少 增加

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接