Logical View Restore: Regular

Logical View is the default view in the Restore window. You can select tablespaces to restore. Regular Logical View Restore basically restores backed-up data files, then recovers the tablespace by using the backed-up archive logs.

Support for Regular Logical View Restore is subject to the following considerations:

• The restore succeeds only if being done from the latest backup.
• The restore attempts to roll up the transaction logs to the current time.

Restrictions.

As a consequence of the roll-up, in case data from a tablespace are deleted from within the database, this restore mode will not result in restoring the deleted data.
For more information, see: Recovering Tables and Table Partitions in PDBs in Oracle documentation.

• The restore destination node must be running the same operating system version as that of the source node.
• If the restore destination is not “Original Location”, the restore destination node should have a similar configuration to the original source server including file paths, database ID, and any other Oracle-related configuration settings. Also, the tablespaces being restored must be present in the Oracle database.
• Oracle SYSTEM and SYSAUX tablespaces are not supported for restore.
• Oracle UNDO tablespaces are not supported for restore.

Take the following steps to enable regular restore:

1. Set the restore destination job option Oracle Restore Mode to “Regular”. “Regular” is the default. See Special Restore Destination Options for Oracle.
2. Select tablespaces or databases for restore. Then complete the restore steps outlined in Introduction to the Restore Functions in the Reference Guide.