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-pluggable_database-Linux-12c.txt (1.54 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 Flash Recovery Area (FRA) to perform the recovery.

# Please refer "restore-pit-timestamp-auxiliary destination-pluggable database-12c.txt" to perform recovery using Auxiliary destination path.

# 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.

# 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-Linux::\\<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')";
 
 ALTER PLUGGABLE DATABASE <pluggable database name> OPEN RESETLOGS;
 
 CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
 CONFIGURE AUXILIARY CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
}
exit