How to perform pluggable database (PDB) point-in-time (PIT) restore on Windows and Linux platforms

How to perform pluggable database (PDB) point-in-time (PIT) restore on Windows and Linux platforms

記事: 100014098
最終公開日: 2017-12-04
評価: 0 0
製品: Backup Exec

Problem

Performing a pluggable database (PDB) point-in-time (PIT) restore on Windows and Linux platforms

Solution

On a Windows platform, perform the following steps:

1. Oracle 12c installed with non admin Oracle Home User
Manually add the non-admin Oracle HOME user in the Administrators group. Restart the Oracle service of that particular instance that you want to restore.

2. Oracle 12c installed with the Administrator user
No action required

Pluggable database PIT restore steps for Windows platform:

1. Server-initiated PDB PIT restore
Create the PDB PIT restore job on Backup Exec and run the job.


2. DBA-initiated PDB PIT restore
On the Oracle server on Windows, use the sample scripts located at: Program Files\Symantec\Backup Exec\RAWS\Scripts\oracle\
Replace the fields in the sample file and save the text file as .rman to run this file on the RMAN console.

Example of the sample file: restore-pit-timestamp-auxiliary_destination-pluggable_database-12c.txt
Example of sample file name: RMAN>@samplescript.rman
 

Pluggable database PIT restore for Linux platform:

1. Server-initiated PDB PIT restore
Create the PDB PIT restore job on Backup Exec and run the job.

2. DBA-initiated PDB PIT restore
Refer to the Backup Exec server for the sample scripts.  Use the sample scripts located at:
Program Files\Symantec\Backup Exec\Scripts\oracle\
Replace the fields in the sample file and save the text file as .rman to run this file on the RMAN console.

Example of the sample file: restore-pit-timestamp-auxiliary_destination-pluggable_database-12c.txt
Example of sample file name: RMAN>@samplescript.rman
 


Applies To

Backup Exec 2014 Service Pack 2 and later + Oracle 12c database

Was this content helpful?