【OracleDatabase】数据库控制文件管理-创新互联

移动控制文件
[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.ctl
                      
SQL> 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.ctl
                      
SQL> host rm -rf /u01/app/oracle/flash_recovery_area/wallet/control02.ctl

重建控制文件
SQL> show parameter user_dump_dest
NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
user_dump_dest                       string                            /u01/app/oracle/diag/rdbms/kin
                                                                       g/wallet/trace
                                                                       
SQL> alter session set tracefile_identifier='trace_control';
Session altered.

SQL> alter database backup controlfile to trace;
Database altered.

[oracle@wallet01 ~]$ cd /u01/app/oracle/diag/rdbms/wallet/wallet/trace

[oracle@wallet01 trace]$ more wallet_ora_28356_trace_control.trc

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> host rm -rf /u01/app/oracle/oradata/wallet/control01.ctl

SQL> host rm -rf /u02/app/oracle/oradata/wallet/control02.ctl

SQL> startup nomount
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

SQL> CREATE CONTROLFILE REUSE DATABASE "WALLET" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '/u01/app/oracle/oradata/wallet/redo01a.log',
    '/u02/app/oracle/oradata/wallet/redo01b.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 2 (
    '/u01/app/oracle/oradata/wallet/redo02a.log',
    '/u02/app/oracle/oradata/wallet/redo02b.log'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 3 (
    '/u01/app/oracle/oradata/wallet/redo03a.log',
    '/u02/app/oracle/oradata/wallet/redo03b.log'
  ) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/wallet/system01.dbf',
  '/u01/app/oracle/oradata/wallet/sysaux01.dbf',
  '/u01/app/oracle/oradata/wallet/undotbs01.dbf',
  '/u01/app/oracle/oradata/wallet/users01.dbf',
  '/u01/app/oracle/oradata/wallet/soe01.dbf',
  '/u01/app/oracle/oradata/wallet/soe02.dbf',
CHARACTER SET AL32UTF8;
Control file created.

SQL> shutdown abort    
ORACLE instance shut down.

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.

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。