基于SCN的恢复是指将数据库恢复到某个特定的SCN点,如果我们误操作了一张表而需要恢复该表,如果我们知道这张表被误操作的SCN点,我们就可以执行基于SCN的不完全恢复。
和之前做时间点的不完全恢复一样,我们在操作之前先热备全库。
alter database begin backup
cp.......
依旧是使用test7表:
02:40:44 SQL> select * from test7;
ID
----------
1
02:40:57 SQL> insert into test7 values(2);
1 row created.
02:41:06 SQL> commit;
Commit complete.
02:41:09 SQL> select * from test7;
ID
----------
1
2
02:41:14 SQL> select current_scn from v$database;
CURRENT_SCN
-----------
8262659
02:41:28 SQL>
02:41:31 SQL> drop table test7;
Table dropped.
02:41:44 SQL> select current_scn from v$database;
CURRENT_SCN
-----------
8262691
关闭数据库,删除数据文件,
将备份数据文件拷贝到数据文件位置,执行基于scn的recover
SQL> select file#,change# from v$recover_file;
FILE# CHANGE#
---------- ----------
1 8262450
2 8262450
3 8262450
4 8262450
备份文件集的scn要小于我要恢复点的scn
SQL> recover database until change 8262659;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select * from test7;
ID
----------
1
2
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
------------------------------------------------------------------------------------
原博客地址:http://blog.itpub.net/23732248/
原作者:应以峰 (frank-ying)
-------------------------------------------------------------------------------------
和之前做时间点的不完全恢复一样,我们在操作之前先热备全库。
alter database begin backup
cp.......
依旧是使用test7表:
02:40:44 SQL> select * from test7;
ID
----------
1
02:40:57 SQL> insert into test7 values(2);
1 row created.
02:41:06 SQL> commit;
Commit complete.
02:41:09 SQL> select * from test7;
ID
----------
1
2
02:41:14 SQL> select current_scn from v$database;
CURRENT_SCN
-----------
8262659
02:41:28 SQL>
02:41:31 SQL> drop table test7;
Table dropped.
02:41:44 SQL> select current_scn from v$database;
CURRENT_SCN
-----------
8262691
关闭数据库,删除数据文件,
将备份数据文件拷贝到数据文件位置,执行基于scn的recover
SQL> select file#,change# from v$recover_file;
FILE# CHANGE#
---------- ----------
1 8262450
2 8262450
3 8262450
4 8262450
备份文件集的scn要小于我要恢复点的scn
SQL> recover database until change 8262659;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select * from test7;
ID
----------
1
2
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1
------------------------------------------------------------------------------------
原博客地址:http://blog.itpub.net/23732248/
原作者:应以峰 (frank-ying)
-------------------------------------------------------------------------------------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23732248/viewspace-1482785/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23732248/viewspace-1482785/