Hi All Please download following file from Google drive and keep in unix directory say /home/oracle https://drive.google.com/open?id=0B8-3R318F39hQUJOcnVPMUdrNzg The files to be downloaded:- Please use ojdbc7.jar downloaded for 12c.For 11g,you can use ojdbc6.jar.   Please provide execute permissions Now you can test connection using below:- [oracle@SBJ1ITESBDBV01 ~]$ sh sqlScript_new.sh 2017-10-26 09:45:53.0… Continue Reading Troubleshoot connection issue using standalone jdbc driver to oracle

Introduction The next document will describe the steps to restore scenario for CDB and PDB using Data protector and RMAN 1.New SYSBACKUP privilege in RMAN 12c 1.1 create common user in CDB with sysbackup privilege. [oracle@rac1 ~]$ export ORACLE_SID=orcl1 [oracle@rac1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on… Continue Reading Different restore and recovery scenario for PDB and CDB in Oracle 12c

1 Introduction The next document will describe the steps to restore database with CDB and PDB point in time using Data protector and RMAN.   2.  Restore Database with PDB PITR using command prompt (Best/Preferred way)   [oracle@orclbkp admin]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon… Continue Reading Restore Database with PDB PITR Oracle 12c

1 Introduction The next document will describe the steps to restore database point in time using Data protector and RMAN   2. Restore using data protector console   2.1. Restore screen shot       3.  Restore Database PITR using command prompt (Best/Preferred way)   3.1  Restore database 1st incarnation… Continue Reading Database point in time recovery using Data protector and RMAN

1 Introduction The next document will describe the steps to recover corrupt block using RMAN   2. Recover block if datafile header is corrupted   2.1. Please check the physical corruption   [oracle@cdv1pradmdbv01 datafile]$ rman target / Recovery Manager: Release 12.2.0.1.0 – Production on Mon Jun 26 12:55:06 2017 Copyright… Continue Reading Database corrupt block recovery using RMAN

1.Login to source database 2. Create temporary pfile from spfile of source database   2.1. create temporary pfile from spfile sqlplus / as sysdba SQL>create pfile=’/tmp/inittest.ora’ from spfile;     2.2. Change parameters in init parameter to fit target database   Please change all source database name to target database… Continue Reading Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance