移动控制文件
[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.
免责声明:
① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。
② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341