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!

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

2962628Jul 31 2015 — edited Aug 3 2015

Hi,

I am getting below error while performing flashback activity. Currently we have backups so when I tried flashback command in RMAN my issue got solved.

But if I want to do the same using SQLPLUS what actions should I take?

ERROR:

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

ORA-38762: redo logs needed for SCN 20062842926 to SCN 20062842936

ORA-38761: redo log sequence 4 in thread 2, incarnation 65 could not be

accessed

DATABASE:11.2.0.3.0(UAT)

This post has been answered by AJ on Jul 31 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2015

Added on Jul 31 2015

#general-database-discussions

4 comments

1,192 views