How to Create or Remove Restore Point on Standby database (文件 ID 1672977.1)

rongshiyuan發表於2014-09-28
REMRESTDatabase

How to Create or Remove Restore Point on Standby database (文件 ID 1672977.1)


In this Document

Goal
Solution


Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

 This note is to provide steps to create or remove restore point on standby database.

Solution

To create restore point on a standby database:

It is required to stop the managed recovery on the standby, otherwise the following error will happen:

ORA-38784: Cannot create restore point ''.
ORA-01153: an incompatible media recovery is active

sqlplus / as sysdba

SQL> alter database recover managed standby database cancel;
SQL> create restore point ;

  

To remove a restore point on a standby database:

If standby database is running in Active Data Guard mode, close the database is required, otherwise the following error will happen:

ORA-16000: database open for read-only access

sqlplus / as sysdba

SQL> shutdown immediate

SQL> startup mount
SQL> drop restore point ;
SQL> alter database open read only; (if using Active Data Guard)
SQL> alter database recover managed standby database using current logfile disconnect; (restart the managed recovery)

 
Above commands are applicable for all standby Protection mode (MaxPerformance/MaxAvailability/MaxProtection).


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

相關文章