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:58 2017 Completed redo scan read […]

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 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 2017-10-26 09:45:53.0 Please note you may get following error if you use […]

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 Production on Sat Dec 9 19:56:36 2017 Copyright (c) 1982, 2014, Oracle. […]

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)   [oracle@cdv1pradmdbv01 ~]$ rman target […]

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 – Production on Mon Jun 26 12:55:06 2017 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. […]

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 and control_files loction   BKPTSTC.__data_transfer_cache_size=0 BKPTSTC.__db_cache_size=939524096 […]