Home » Server Options » Data Guard » Error while Flashbacking a standby DB (Oracle Enterprise edition 10.2.0.3, AIX 5.3L)
Error while Flashbacking a standby DB [message #350029] Tue, 23 September 2008 16:12 Go to next message
mnlv00
Messages: 8
Registered: May 2008
Junior Member
Hi,
We have a primary DB and a physical standby Oracle 10.2.0.3 DB built on IBM AIX 5.3L.
When I try to flashback the database to a specific time, it throws me this error.

FLASHBACK DATABASE TO TIMESTAMP to_timestamp('09/23/2008 10:00:00','MM/DD/YYYY HH24:MI:SS')
*
ERROR at line 1:
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38761: redo log sequence 1891 in thread 1, incarnation 1 could not be accessed

**************************
We have made sure flashback is enabled. We are able to flashback the database to that time in primary db though.
SQL> show parameter flash

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target integer 1440
SQL> show parameter recov

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
*********************************

Any help is appreciated.
TIA
mnlv
Re: Error while Flashbacking a standby DB [message #350034 is a reply to message #350029] Tue, 23 September 2008 17:28 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What does the following show on the standby:

select FLASHBACK_ON from v$database;
Re: Error while Flashbacking a standby DB [message #350084 is a reply to message #350029] Wed, 24 September 2008 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
 *Cause: A FLASHBACK DATABASE command did not start.  A redo log needed for
         the recovery part of FLASHBACK DATABASE could not be found or
         accessed.
 *Action: See trace files for details of the problem.

Regards
Michel
Re: Error while Flashbacking a standby DB [message #350165 is a reply to message #350084] Wed, 24 September 2008 04:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Doesn't really elaborate on the error message the OP posted?
Re: Error while Flashbacking a standby DB [message #350179 is a reply to message #350165] Wed, 24 September 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course, the details are in the trace file.

Regards
Michel
Re: Error while Flashbacking a standby DB [message #350207 is a reply to message #350029] Wed, 24 September 2008 06:47 Go to previous messageGo to next message
mnlv00
Messages: 8
Registered: May 2008
Junior Member
Hi,
Thx for the reply. The flashback is on, I already checked it.
SQL> select FLASHBACK_ON from v$database;

FLASHBACK_ON
------------------
YES

and I have already done the oerr ora- to get full details on the error. My question is "Is flashback recovery dependent on archivelog ?".
TIA
mnlv
Re: Error while Flashbacking a standby DB [message #350214 is a reply to message #350207] Wed, 24 September 2008 07:25 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
mnlv00 wrote on Wed, 24 September 2008 07:47
My question is "Is flashback recovery dependent on archivelog ?".


Yes.
Previous Topic: Error: ORA-16642: db_unique_name mismatch
Next Topic: Logical standby database set up
Goto Forum:
  


Current Time: Wed Dec 07 09:05:47 CST 2016

Total time taken to generate the page: 0.07657 seconds