ORACLE FLASHBACK DATABASE知识整理(六)
sql]
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1272213504 bytes
Fixed Size 1336260 bytes
Variable Size 822086716 bytes
Database Buffers 436207616 bytes
Redo Buffers 12582912 bytes
Database mounted.
11）闪回至指定SCN
[sql]
SQL> flashback database to scn 839748;
Flashback complete.
12）查看数据文件状态，注意文件5是OFFLINE的状态。与闪回点状态不一致，与操作点状态一致。
[sql]
SQL> select file#,status from v$datafile;
FILE# STATUS
-----------------
1 SYSTEM
2 RECOVER
3 RECOVER
4 RECOVER
5 OFFLINE
6 ONLINE
7 OFFLINE
8 RECOVER
8 rows selected.
13）打开数据库
[sql]
SQL> alter database open resetlogs;
Database altered.
14）无法查看
[sql]
SQL> select * from knight.books;
select * from knight.books
*
ERROR at line1:
ORA-00376: file5 cannot be read at this time
ORA-01110: datafile 5: '/ss/test_space01.dbf'
15）无法上线
[sql]
SQL> alter tablespace test_space online;
alter tablespace test_space online
ERROR at line1:
ORA-01190: control file or data file 5 is from before the last RESETLOGS
ORA-01110: datafile 5: '/ss/test_space01.dbf'
无法上线
[sql]
SQL> alter database datafile 5 online;
alter database datafile 5 online
*
ERROR at line1:
ORA-01190: control file or data file 5 is from before the last RESETLOGS
ORA-01110: datafile 5: '/ss/test_space01.dbf'
16）使用隐含参数
[sql]
SQL> alter system set "_allow_resetlogs_corruption"=TRUE scope=spfile;
System altered.
[sql]
SQL> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME ADJUST_SCN LEVEL1';
Session altered.
17）重启数据库至mount
[sql]
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[sql]
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1272213504 bytes
Fixed Size 1336260 bytes
Variable Size 822086716 bytes
Database Buffers 436207616 bytes
Redo Buffers 12582912 bytes
Database mounted.
18）不完全恢复
[sql]
SQL> recover database until cancel;
Media recovery complete.
19）此时可以上线
[sql]
SQL> alter database datafile 5 online;
Database altered.
[sql]
SQL> alter database open resetlogs;
Database altered.
20）报内部错误
[sql]
SQL> select * from knight.books;
select * from knight.books
*
ERROR at line1:
ORA-00600:internal error code, arguments: [2662], [0], [840208], [0],
[840576],[20971648], [], [], [], [], [], []
21）再次重启
[sql]
SQL> shutdown immediate;
ORA-00600:internal error code, arguments: [2662], [0], [840230], [0], [840576],[20971648], [], [], [], [], [], []
[sql]
SQL> shutdown abort
ORACLE instance shut down.
[sql]
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1272213504 bytes
Fixed Size 1336260 bytes
Variable Size 822086716 bytes
Da