Error while Flashbacking a standby DB [message #350029] |
Tue, 23 September 2008 16:12 |
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 #350207 is a reply to message #350029] |
Wed, 24 September 2008 06:47 |
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
|
|
|
|