6150680: Cannot Create Guaranteed Restore Point In Physical Standby DB_602270.1
6150680: Cannot Create Guaranteed Restore Point In Physical Standby Database (文件 ID 602270.1)
In this Document
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*** SymptomsCreate Restore point on on a physical standby database errors out with
SQL> create restore point GO_LIVE GUARANTEE FLASHBACK DATABASE; CauseThis issue is reported in Bug
Bug 6150680 ORA-38788 / ORA-38784 from CREATE RESTORE POINT 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 .
Solution
Workaround :-
SQL>alter database flashback off; and
SQL>CREATE RESTORE POINT The command should succeed this time.
Check for availability of one off patch using the following link Patch 6150680
ReferencesBUG:6150680 - CANNOT CREATE GUARANTEED RESTORE POINT IN PHYSICAL STANDBY DATABASE |
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1283273/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Create or Remove Restore Point on Standby database (文件 ID 1672977.1)REMRESTDatabase
- [20171204]guaranteed restore point.txtREST
- oracle小知識點3--有保證的復原點guaranteed restore pointOracleREST
- RESTORE POINTREST
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- Oracle physical standbyOracle
- DataGuard:Physical Standby Switchover
- 閃回還原點restore pointREST
- Step-By-Step Guide To Create Physical Standby On Normal File System For ASM Primary using RMANGUIIDEORMASM
- DataGuard:Physical Standby FailoverAI
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- restore point -特色的SCN標誌(一)REST
- 【DG】Data Guard搭建(physical standby)
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- oracle Physical Standby failover stepOracleAI
- Creating a Physical Standby DatabaseDatabase
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- Orace Flash Restore Point(閃回還原點)REST
- Oracle10GR2 中的RESTORE POINTOracleREST
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- open physical standby 為read write
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- Cannot restore segment prot after reloc:Permission deniedREST
- Physical Standby Switchover_status Showing Not Allowed
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- Oracle10G Physical Standby Database setupOracleDatabase
- 最大效能Physical Standby設定記錄
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- Creating a physical standby from ASM primaryASM
- 6150680 ORA-38788/38784 from CREAT RESTOR POINT GUARANTE FB DB_6150680.8REST
- restore point特色二&閃回資料庫特性(三)REST資料庫
- Script to Collect Data Guard Physical and Active Standby Diagnostic InformationORM
- oracle 10g physical standby 切換操作Oracle 10g
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- 關於建立DataGuard Physical Standby資料庫資料庫
- oracle 10g physical standby database creationOracle 10gDatabase
- Recover physical standby database after loss of archive log(2)DatabaseHive
- 建立Local Physical Standby Oracle9i standby 資料庫筆記Oracle資料庫筆記