恢复数据库时什么时候需要using backup controlfile

最新推荐文章于 2023-10-16 10:53:15 发布

原创最新推荐文章于 2023-10-16 10:53:15 发布 · 190 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL #thread

ORACLE管理专栏收录该内容

275 篇文章

订阅专栏

本文介绍了一次Oracle数据库恢复过程，包括全库备份、控制文件离线备份及数据文件与控制文件恢复步骤。演示了如何使用命令行进行数据库的关闭、打开、切换日志等操作，并通过实例展示了恢复过程中遇到的问题及解决办法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

现在轮到测试using backup controlfile
先进行全库备份
[oracle@linuxsvr oradata]$ cp ./ora10r2/*.dbf ./ora10r2_bak
数据库打开之后进行，再次进行controlfile的离线备份，即controlfile比datafile要新
16:19:48 SQL> shutdown abort
ORACLE instance shut down.
[oracle@linuxsvr ora10r2]$ cp control01.ctl control01.ctl.bak

16:21:33 SQL> alter database open;

Database altered.

16:22:13 SQL> alter system switch logfile;

System altered.

16:25:58 SQL> /

System altered.

16:25:59 SQL> /

16:26:16 SQL> shutdown abort
ORACLE instance shut down.
进行数据文件和控制文件恢复
[oracle@linuxsvr oradata]$ mv ora10r2 ora10r2_new
[oracle@linuxsvr oradata]$ mv ora10r2_bak ora10r2
[oracle@linuxsvr oradata]$ cp ora10r2_new/control01.ctl ./ora10r2
16:26:41 SQL> startup mount
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.
16:29:45 SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#
------------------
568284
568284
568284
568284
526657

16:30:03 SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
527735
527735
527735
527735
526657
可以看到由于controlfile为离线备份，且比数据文件新，故不用using backup controlfile选项
16:30:12 SQL> recover database;
ORA-00279: change 527735 generated at 12/19/2010 16:15:38 needed for thread 1
ORA-00289: suggestion : /oradata/archlog/1_6_738173171.dbf
ORA-00280: change 527735 for thread 1 is in sequence #6

16:30:37 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 547852 generated at 12/19/2010 16:19:09 needed for thread 1
ORA-00289: suggestion : /oradata/archlog/1_7_738173171.dbf
ORA-00280: change 547852 for thread 1 is in sequence #7
ORA-00278: log file '/oradata/archlog/1_6_738173171.dbf' no longer needed for
this recovery
。。。
Media recovery complete.

16:33:36 SQL> alter database open;

Database altered.