shutdown immedate，恢复全部数据文件（不包括control和redo）

最新推荐文章于 2022-11-03 00:19:13 发布

原创最新推荐文章于 2022-11-03 00:19:13 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #thread #sql #数据库 #oracle #file

oracle 专栏收录该内容

137 篇文章

订阅专栏

本文介绍了Oracle数据库完全恢复的操作步骤。先拷贝热备数据文件，接着进行数据库的mount操作，然后执行完全恢复数据库的命令，最后打开数据库。通过一系列SQL命令完成恢复，并验证恢复结果为完全恢复成功。

（把热备的数据文件拷贝回来，不包括control和redo）
SQL> conn internal
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

复制全部热备的数据文件过来（完全恢复成功！）
mount数据库
SQL> startup mount
ORACLE instance started.

Total System Global Area 25856028 bytes
Fixed Size                   75804 bytes
Variable Size             8925184 bytes
Database Buffers          16777216 bytes
Redo Buffers                77824 bytes
Database mounted.
SQL>

完全恢复数据库
SQL> recover database;
ORA-00279: change 424112 generated at 10/20/2002 20:40:52 needed for thread 1
ORA-00289: suggestion : D:/BACKUPDB/ARCHIVE/BACKUPT001S00001.ARC
ORA-00280: change 424112 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 424125 generated at 10/20/2002 20:44:14 needed for thread 1
ORA-00289: suggestion : D:/BACKUPDB/ARCHIVE/BACKUPT001S00002.ARC
ORA-00280: change 424125 for thread 1 is in sequence #2
ORA-00278: log file 'D:/BACKUPDB/ARCHIVE/BACKUPT001S00001.ARC' no longer needed
for this recovery

ORA-00279: change 424135 generated at 10/20/2002 21:55:35 needed for thread 1
ORA-00289: suggestion : D:/BACKUPDB/ARCHIVE/BACKUPT001S00003.ARC
ORA-00280: change 424135 for thread 1 is in sequence #3
ORA-00278: log file 'D:/BACKUPDB/ARCHIVE/BACKUPT001S00002.ARC' no longer needed
for this recovery

ORA-00279: change 424139 generated at 10/20/2002 21:57:42 needed for thread 1
ORA-00289: suggestion : D:/BACKUPDB/ARCHIVE/BACKUPT001S00004.ARC
ORA-00280: change 424139 for thread 1 is in sequence #4
ORA-00278: log file 'D:/BACKUPDB/ARCHIVE/BACKUPT001S00003.ARC' no longer needed
for this recovery

Log applied.
Media recovery complete.
SQL>

打开数据库
SQL> alter database open;

Database altered.

验证恢复结果：完全恢复
SQL> conn lunar/lunar
Connected.
SQL> select * from test1;

      A
----------
      1
      2

SQL>
完全恢复成功！

说明：
1.  复制全部热备的数据文件过来
2.  mount数据库
3.  完全恢复数据库
4.  打开数据库