Software: Apache. PHP/5.5.15 

uname -a: Windows NT SVR-DMZ 6.1 build 7600 (Windows Server 2008 R2 Enterprise Edition) i586 

SYSTEM 

Safe-mode: OFF (not secure)

C:\Program Files\Symantec\Backup Exec\RAWS\scripts\oracle\   drwxrwxrwx
Free 3.26 GB of 39.52 GB (8.25%)
Detected drives: [ a ] [ c ] [ d ] [ e ] [ f ]
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     restore-pit-timestamp-auxiliary_destination-pluggable_database-12c.txt (1.68 KB)      -rw-rw-rw-

#Sample RMAN script for a pluggable database point in time restore.
#NOTE: 
# 1. The pluggable database has to be MOUNTED for point in time restore.
#    Using "ALTER PLUGGABLE DATABASE <pluggable database name> CLOSE;" command on SQLPLUS.
# 2. The below script will use the Auxiliary destination (specified in the script) to perform the recovery.

# Please replace the below fields in the sample script:
# a. <Oracle ServerName> - Oracle Server name
# b. <Container database name> - Oracle Container database name.
# c. <pluggable database name> - Oracle Pluggable database name inside the container DB.
# d. Replace the TO_DATE field with the time upto which restore/recovery is required.
# e. <auxiliary destination path> - Replace it with local system path where the Auxiliary instance will be created.
# 			            Also ensure that the path is created manually & with sufficient privileges.

# Once the fields are replaced, please save this txt file as .rman so that it can be executed on the rman console eg: RMAN>@samplescript.rman


RUN {
 CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NBBSA_DB_DEVICE_NAME=Oracle-Win::\\<Oracle ServerName>\<Container database name>)";
 
 RESTORE PLUGGABLE DATABASE '<pluggable database name>' UNTIL TIME "TO_DATE('06-23-2014:17:58:46', 'MM-DD-YYYY:HH24:MI:SS')";
 
 RECOVER PLUGGABLE DATABASE '<pluggable database name>' UNTIL TIME "TO_DATE('06-23-2014:17:58:46', 'MM-DD-YYYY:HH24:MI:SS')" auxiliary destination='<auxiliary destination path>';
 
 ALTER PLUGGABLE DATABASE <pluggable database name> OPEN RESETLOGS;
 
 CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
 CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
}
exit