foreignlogRecordSpecifier

Purpose

Use the foreignlogRecordSpecifier subclause to specify a set of foreign archived redo logs for use in RMAN operations.

Usage Notes

Foreign archived redo logs are received by a logical standby database for a LogMiner session. Unlike normal archived logs, foreign archived logs have a different DBID. For this reason, they cannot be backed up or restored on a logical standby database.

A logical standby database creates foreign archived logs in the flash recovery area if the following conditions are met:

  • A flash recovery area is configured on the logical standby database.

  • One of the LOG_ARCHIVE_DEST_n initialization parameters is set to 'LOCATION=USE_DB_RECOVERY_FILE_DEST' with a proper VALID_FOR setting to receive foreign archived logs.

  • The COMPATIBLE initialization parameter is set to a value greater than or equal to 11.0.0.

Syntax

foreignlogRecordSpecifier::=

Description of foreignlogrecordspecifier.gif follows
Description of the illustration foreignlogrecordspecifier.gif

archlogRange::=

Description of archlogrange.gif follows
Description of the illustration archlogrange.gif

Semantics

The semantics are exactly the same as for archivelogRecordSpecifier except that the logs are foreign archived redo logs.

Examples

Example 3-20 Crosschecking Foreign Archived Redo Logs

This example crosschecks all foreign archived redo logs:

RMAN> CROSSCHECK FOREIGN ARCHIVELOG ALL;