Creating Standby Database With Enterprise Manager Failing (文件 ID 1400482.1)

rongshiyuan發表於2014-09-28
DatabaseAI

Creating Standby Database With Enterprise Manager Failing (文件 ID 1400482.1)


In this Document

Symptoms
Cause
Solution
References


Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2013***

Symptoms


=== ODM Issue Clarification ===

Standby database creation getting error:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38788: More standby database recovery is needed
ORA-38706 signalled during: alter database flashback on...

 

Cause



Bug 12923814 FLASHBACK AND ARL DELETION OPTIONS IGNORED IN ADD STANDBY DATABASE WIZARD - this bug is unpublished and is fixed in 12g grid. 

Solution

By default a standby database is created without DORECOVER, when the backup is online the files will be inconsistent. With a standby database, this is OK as managed recovery will take care of making files consistent. However, in order to turn 'flashback ON', the files must be consistent.

Thus, once it fails:

1.  recover standby database applying enough redo to make files consistent.

2.  cancel recovery and turn on flashback database

3. operate standby database normally

References


BUG:13250486 - ADD STANDBY DATABASE FOR TARGET WITH FLASHBACK ON FAILS WITH ERROR

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1283436/，如需轉載，請註明出處，否則將追究法律責任。

相關文章