[20150130]关于flashback补充3.txt
--昨天写了http://blog.itpub.net/267265/viewspace-1418458/,听别人实际上只要只要recover database,就可以不需要open
--restelogs打开. 看来自己老了,忘记了基本的东西,重复测试看看.
SYS@test> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test> startup mount
ORACLE instance started.
Total System Global Area 473956352 bytes
Fixed Size 2084776 bytes
Variable Size 230686808 bytes
Database Buffers 230686720 bytes
Redo Buffers 10498048 bytes
Database mounted.
SYS@test> alter database flashback on ;
Database altered.
SYS@test> alter database open ;
Database altered.
SYS@test> create restore point x3;
Restore point created.
SYS@test> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@test> startup mount
ORACLE instance started.
Total System Global Area 473956352 bytes
Fixed Size 2084776 bytes
Variable Size 230686808 bytes
Database Buffers 230686720 bytes
Redo Buffers 10498048 bytes
Database mounted.
SYS@test> flashback database to restore point x3;
Flashback complete.
SYS@test> recover database ;
Media recovery complete.
SYS@test> alter database open ;
Database altered.
--实际上只要recover database就可以了.哎,没有学好oracle.