移动控制文件 [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
创新互联是一家专注于网站设计、成都网站制作与策划设计,成都网站建设哪家好?创新互联做网站,专注于网站建设十余年,网设计领域的专业建站公司;建站业务涵盖:成都等地区。成都做网站价格咨询:028-86922220
重建控制文件 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.