[20150130]關于flashback補充3.txt

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

SYS@test> create restore point x3;

Restore point created.

SYS@test> flashback database to restore point x3;

Flashback complete.

SYS@test> recover  database ;

Media recovery complete.

--實際上隻要recover database就可以了.哎,沒有學好oracle.