[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.