Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flashback database log status

384961Mar 25 2010 — edited Mar 25 2010
My question are
- how come the oldest_flashback_scn is 0
- how come oldest_flashback_time is empty

And I can still do "as of" query


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


SQL> select
2 OLDEST_FLASHBACK_SCN,
3 to_char(oldest_flashback_time,'Dy DD-Mon-YYYY HH24:MI:SS'),
4 RETENTION_TARGET,
5 FLASHBACK_SIZE,
6 ESTIMATED_FLASHBACK_SIZE
7 from v$flashback_database_log;

OLDEST_FLASHBACK_SCN TO_CHAR(OLDEST_FLASHBACK RETENTION_TARGET FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ------------------------ ---------------- -------------- ------------------------
0 15 151461888 67700736

SQL>
SQL> select count(*) from test1 as of scn 364263;

COUNT(*)
----------
2097152
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2010
Added on Mar 25 2010
3 comments
864 views