控制文件丢失恢复实验

左手的ㄟ右手 2022-05-28 11:38 187阅读 0赞

丢失控制文件的恢复

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

**\[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

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

![SouthEast][]

[SouthEast]: /images/20220528/3d3d8594bd13477ca320faac6e36e382.png

控制文件丢失恢复实验

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关损坏控制文件的恢复方法

相关 RMAN备份与恢复之控制文件丢失

相关丢失了所有控制文件副本后进行恢复以trace文件恢复

相关 ext3文件恢复【我实验过了】

相关 Oracle 利用dbms_backup_restore恢复测试（数据文件和控制文件全部丢失了)

相关 Oracle 重建控制文件（在丢失控制文件的情况下，如何恢复数据库）

相关控制文件丢失恢复实验

相关控制文件的备份与恢复

相关实验：删除/boot,恢复

相关丢失控制文件，有旧的备份控制文件，之后有drop表空间和create表空间的操作恢复。...