0x84bb0001 sqlserver_archivelog 下不需要热备也能完全恢复损_sqlserver

prerequisite:被删除的表空间创建时开始,数据库一直在archivelog模式下

恢复具体操作如下:

SQL> archive log list;

Database log mode              Archive Mode

http://www.gaodaima.com/34799.htmlarchivelog 下不需要热备也能完全恢复损_sqlserver

Automatic archival             Enabled

Archive destination            F:/oracle/ora92/RDBMS

Oldest online log sequence     23

Next log sequence to archive   25

Current log sequence           25

SQL> alter tablespace backuptest offline;

alter tablespace backuptest offline

*

ERROR at line 1:

ORA-01109: database not open

SQL> alter database datafile 'f:/backup.dbf' offline;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter tablespace backuptest offline immediate;

Tablespace altered.

SQL> select * from v$recover_file;

FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME

---------- ------- ------- ----------------------------------------------------------------- ---------- ---------

11 OFFLINE OFFLINE FILE NOT FOUND                                                             0

SQL> alter database create datafile 'f:/backup.dbf' as 'f:/backup.dbf';

Database altered.

SQL> select * from v$recover_file;

FILE# ONLINE  ONLINE_ ERROR                                                                CHANGE# TIME

---------- ------- ------- ----------------------------------------------------------------- ---------- ---------

11 OFFLINE OFFLINE                                                                      3074706 03-NOV-04

SQL> recover tablespace backuptest;

Media recovery complete.

SQL> alter tablespace backuptest online;

Tablespace altered.

SQL> select * from backup;

ID

----------

1

2

至此,已经完全恢复了^_^

欢迎大家阅读《archivelog 下不需要热备也能完全恢复损_sqlserver》,跪求各位点评,若觉得好的话请收藏本文,by 搞代码

e7ce419cf2d6ad34d01da2ceb8829eed.png

微信 赏一包辣条吧~

023a57327877fb4402bcc76911ec18ea.png

支付宝 赏一听可乐吧~

已标记关键词 清除标记
表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
相关推荐
©️2020 CSDN 皮肤主题: 1024 设计师:白松林 返回首页