【Oracle Database】数据库控制文件管理
生活随笔
收集整理的這篇文章主要介紹了
【Oracle Database】数据库控制文件管理
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
移動控制文件
[oracle@wallet01?~]$?sqlplus?/?as?sysdba
SQL>?set?line?200
SQL>?col?name?for?a60
SQL>?select?status,name?from?v$controlfile;STATUS??NAME
-------?------------------------------------------------------------/u01/app/oracle/oradata/wallet/control01.ctl/u01/app/oracle/fast_recovery_area/wallet/control02.ctlSQL>?alter?system?set?control_files=
'/u01/app/oracle/oradata/wallet/control01.ctl',
'/u02/app/oracle/oradata/wallet/control02.ctl'?scope=spfile;
System?altered.SQL>?shutdown?immediate???
Database?closed.
Database?dismounted.
ORACLE?instance?shut?down.[oracle@wallet01?~]$?cp?/u01/app/oracle/oradata/wallet/control01.ctl?/u02/app/oracle/oradata/wallet/control02.ctl[oracle@wallet01?~]$?sqlplus?/?as?sysdba
SQL>?startup
ORACLE?instance?started.Total?System?Global?Area?1068937216?bytes
Fixed?Size??????????????????2260088?bytes
Variable?Size?????????????335545224?bytes
Database?Buffers??????????725614592?bytes
Redo?Buffers????????????????5517312?bytes
Database?mounted.
Database?opened.SQL>?set?line?200
SQL>?col?name?for?a60
SQL>?select?status,name?from?v$controlfile;STATUS??NAME
-------?------------------------------------------------------------/u01/app/oracle/oradata/wallet/control01.ctl/u02/app/oracle/oradata/wallet/control02.ctlSQL>?host?rm?-rf?/u01/app/oracle/flash_recovery_area/wallet/control02.ctl
轉載于:https://blog.51cto.com/13598811/2132354
總結
以上是生活随笔為你收集整理的【Oracle Database】数据库控制文件管理的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 哈尔滨csdn1
- 下一篇： centos redis make 报错