alter database recover managed standby database 语句

RDBMS 11.2.0.4 

参考文档：

ALTER DATABASE (oracle.com)

语法格式如下：

 一种用法：

alter database recover managed standby database until change 123456 disconnect from session;

官方的解释：

STANDBY DATABASE Specify the STANDBY DATABASE clause to manually recover a physical standby database using the control file and archived redo log files copied from the primary database. The standby database must be mounted but not open.

This clause recovers only online data files.

• Use the UNTIL clause to specify the duration of the recovery operation.

  • CANCEL indicates cancel-based recovery. This clause recovers the database until you issue the ALTER DATABASE statement with the RECOVER CANCEL clause.

  • TIME indicates time-based recovery. This parameter recovers the database to the time specified by the date. The date must be a character literal in the format 'YYYY-MM-DD:HH24:MI:SS'.

  • CHANGE indicates change-based recovery. This parameter recovers the database to a transaction-consistent state immediately before the system change number specified by integer.

  • CONSISTENT recovers the database until all online files are brought to a consistent SCN point so that the database can be open in read only mode. This clauses requires the controlfile to be a backup controlfile.

• Specify USING BACKUP CONTROLFILE if you want to use a backup control file instead of the current control file.

END