Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

PSU patching for 12.1.0.2:-   First Identify the patch to be downloaded:- Oracle 12.1.0.2 proactive DB patching . Patch number:-26635880.We needed to apply in RHEL 7 64-bit. Please download this patch from Oracle support. We need to follow below link for details of steps:- https://updates.oracle.com/Orion/Services/download?type=readme&aru=21529863   We need to download following OPATCH utility as wellContinue reading Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

Oracle database instance recovery is taking too much time after shutdown immediate

1.We were going to open DB after shutdown immediate but it went hang.In alert log , we could only notice following message for 40 minutes.   Completed: ALTER DATABASE MOUNT Tue Oct 31 01:08:39 2017 ALTER DATABASE OPEN Beginning crash recovery of 1 threadsparallel recovery started with 9 processes Started redo scanTue Oct 31 01:08:58Continue reading Oracle database instance recovery is taking too much time after shutdown immediate

Troubleshoot connection issue using standalone jdbc driver to oracle

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 Please note you may getContinue reading Troubleshoot connection issue using standalone jdbc driver to oracle

Different restore and recovery scenario for PDB and CDB in Oracle 12c

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 Sat Dec 9 19:56:36 2017Continue reading Different restore and recovery scenario for PDB and CDB in Oracle 12c

Restore Database with PDB PITR 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 Jun 26 21:32:29 2017 CopyrightContinue reading Restore Database with PDB PITR Oracle 12c

Database point in time recovery using Data protector and RMAN

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 (No need to reset incarnation)Continue reading Database point in time recovery using Data protector and RMAN

Database corrupt block recovery using 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 (c) 1982, 2017, Oracle and/orContinue reading Database corrupt block recovery using RMAN

Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance

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 name and create audit_file_dest andContinue reading Clone point in time Recovery using Dataprotector and RMAN for single instance to single instance