6150680: Cannot Create Guaranteed Restore Point In Physical Standby DB_602270.1

rongshiyuan發表於2014-09-28

6150680: Cannot Create Guaranteed Restore Point In Physical Standby Database (文件 ID 602270.1)


In this Document

Symptoms
Cause
Solution
References

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***

Symptoms

Create Restore point on on a physical standby database errors out with

 

SQL> create restore point GO_LIVE GUARANTEE FLASHBACK DATABASE;
create restore point GO_LIVE GUARANTEE FLASHBACK DATABASE
*
ERROR at line 1:
ORA-38784: Cannot create restore point 'GO_LIVE'.
ORA-38788: More standby database recovery is needed



.

Cause

This issue is reported in Bug

Bug 6150680 ORA-38788 / ORA-38784 from CREATE RESTORE POINT GUARANTEE FLASHBACK DATABASE

Fixed-Releases: 10.2.0.5 , 11.1.0.7

If  any datafile header's checkpointSCN are not equal to the database incomplete recovery SCN its not clean it will fail indicating one datafile is not clean (it needs recovery).Read-only datafiles will fail this check .

  • Flashback database is disabled
  • This is an physical standby database
  • There are  read-only datafiles

Solution

 

Workaround :-

 

SQL>alter database flashback off; 

SQL>alter database flashback on;

and

SQL>CREATE RESTORE POINT GUARANTEE FLASHBACK DATABASE

The command should succeed this time.

 

Check for availability of one off patch using the following link Patch 6150680

 

References

BUG:6150680 - CANNOT CREATE GUARANTEED RESTORE POINT IN PHYSICAL STANDBY DATABASE

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

相關文章