控制文件丢失恢复实验

丢失控制文件的恢复

进入控制文件目录并删除对应的控制文件

[root@oracleyyy]# pwd

/u01/app/oradata/yyy

[root@oracleyyy]# ll

total5103052

-rw-r-----1 oracle dba    9879552 Apr  2 08:58 control01.ctl

-rw-r-----1 oracle dba    9879552 Apr  2 08:58 control02.ctl

-rw-r-----1 oracle dba   52436992 Apr  2 08:57 qqq01.dbf

-rw-r-----1 oracle dba   52429312 Apr  2 08:57 redo01.log

-rw-r-----1 oracle dba   52429312 Apr  2 08:56 redo02.log

-rw-r-----1 oracle dba   52429312 Apr  2 08:56 redo03.log

-rw-r-----1 oracle dba  734011392 Apr  2 08:56 sysaux01.dbf

-rw-r-----1 oracle dba  734011392 Apr  2 08:56 system01.dbf

-rw-r-----1 oracle dba   30416896 Apr  1 22:01 temp01.dbf

-rw-r-----1 oracle dba   53485568 Apr  2 08:56 test_01.dbf

-rw-r-----1 oracle dba 3271565312 Apr  2 08:57test02.dbf

-rw-r-----1 oracle dba   10493952 Apr  2 08:57 test3_23.dbf

-rw-r-----1 oracle dba   78651392 Apr  2 08:56 undotbs01.dbf

-rw-r-----1 oracle dba   55058432 Apr  2 08:56 users01.dbf

-rw-r-----1 oracle dba   52436992 Apr  2 08:57 www01.dbf

[root@oracleyyy]# rm control0*

 

[root@oracleyyy]# ll

total5083756

-rw-r-----1 oracle dba   52436992 Apr  2 08:27 qqq01.dbf

-rw-r-----1 oracle dba   52429312 Apr  2 08:22 redo01.log

-rw-r-----1 oracle dba   52429312 Apr  2 08:52 redo02.log

-rw-r-----1 oracle dba   52429312 Apr  1 22:00 redo03.log

-rw-r-----1 oracle dba  734011392 Apr  2 08:50 sysaux01.dbf

-rw-r-----1 oracle dba  734011392 Apr  2 08:45 system01.dbf

-rw-r-----1 oracle dba   30416896 Apr  1 22:01 temp01.dbf

-rw-r-----1 oracle dba   53485568 Apr  2 08:27 test_01.dbf

-rw-r-----1 oracle dba 3271565312 Apr  2 08:27test02.dbf

-rw-r-----1 oracle dba   10493952 Apr  2 08:27 test3_23.dbf

-rw-r-----1 oracle dba   78651392 Apr  2 08:50 undotbs01.dbf

-rw-r-----1 oracle dba   55058432 Apr  2 08:27 users01.dbf

-rw-r-----1 oracle dba   52436992 Apr  2 08:27 www01.dbf

 

RMAN>shutdown abort 

 

Oracleinstance shut down

 

RMAN>startup nomount 

 

connectedto target database (not started)

Oracleinstance started

 

TotalSystem Global Area    2405122048 bytes

 

FixedSize                     2215704 bytes

VariableSize                620757224 bytes

DatabaseBuffers            1761607680 bytes

RedoBuffers                  20541440 bytes

 

进入备份目录找到最新的控制文件备份的文件进行恢复

 

RMAN>  restore controlfile from'/file/backup/rman/controlfile_c-2086322433-20180326-09';

 

Startingrestore at 02-APR-18

allocatedchannel: ORA_DISK_1

channelORA_DISK_1: SID=1146 device type=DISK

 

channelORA_DISK_1: restoring control file

channelORA_DISK_1: restore complete, elapsed time: 00:00:01

outputfile name=/u01/app/oradata/yyy/control01.ctl

outputfile name=/u01/app/oradata/yyy/control02.ctl

Finishedrestore at 02-APR-18

 

RMAN>alter database mount; 

 

databasemounted

releasedchannel: ORA_DISK_1

 

RMAN>recover database;

 

Startingrecover at 02-APR-18

allocatedchannel: ORA_DISK_1

channelORA_DISK_1: SID=1146 device type=DISK

 

startingmedia recovery

 

archivedlog for thread 1 with sequence 18 is already on disk as file/u01/app/oradata/yyy/redo03.log

archivedlog for thread 1 with sequence 19 is already on disk as file/u01/app/oradata/yyy/redo01.log

archivedlog for thread 1 with sequence 20 is already on disk as file/u01/app/oradata/yyy/redo02.log

archivedlog file name=/file/backup/arch/arch1_1_971785192.dbf thread=1 sequence=1

archivedlog file name=/file/backup/arch/arch1_2_971785192.dbf thread=1 sequence=2

archivedlog file name=/file/backup/arch/arch1_3_971785192.dbf thread=1 sequence=3

archivedlog file name=/file/backup/arch/arch1_4_971785192.dbf thread=1 sequence=4

archivedlog file name=/file/backup/arch/arch1_5_971785192.dbf thread=1 sequence=5

archivedlog file name=/file/backup/arch/arch1_6_971785192.dbf thread=1 sequence=6

archivedlog file name=/file/backup/arch/arch1_7_971785192.dbf thread=1 sequence=7

archivedlog file name=/file/backup/arch/arch1_8_971785192.dbf thread=1 sequence=8

archivedlog file name=/file/backup/arch/arch1_9_971785192.dbf thread=1 sequence=9

archivedlog file name=/file/backup/arch/arch1_10_971785192.dbf thread=1 sequence=10

archivedlog file name=/file/backup/arch/arch1_11_971785192.dbf thread=1 sequence=11

archivedlog file name=/file/backup/arch/arch1_12_971785192.dbf thread=1 sequence=12

archivedlog file name=/file/backup/arch/arch1_13_971785192.dbf thread=1 sequence=13

archivedlog file name=/file/backup/arch/arch1_14_971785192.dbf thread=1 sequence=14

archivedlog file name=/file/backup/arch/arch1_15_971785192.dbf thread=1 sequence=15

archivedlog file name=/file/backup/arch/arch1_16_971785192.dbf thread=1 sequence=16

archivedlog file name=/file/backup/arch/arch1_17_971785192.dbf thread=1 sequence=17

archivedlog file name=/u01/app/oradata/yyy/redo03.log thread=1 sequence=18

archivedlog file name=/u01/app/oradata/yyy/redo01.log thread=1 sequence=19

archivedlog file name=/u01/app/oradata/yyy/redo02.log thread=1 sequence=20

mediarecovery complete, elapsed time: 00:00:05

Finishedrecover at 02-APR-18

 

RMAN>alter database open resetlogs; 

 

databaseopened

然后查看控制文件是否恢复！