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