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 […]
Introduction If RDS Instances is AWS keep running without 24×7 usage, it can cost you very high in AWS billing. Take following example how idle RDS instances can cost you:- Lets take a medium sized RDS instance db.m4.xlarge (4CPU and 16GB RAM) in Sydney region for MySQL engine costs $0.492 per hour. Now if we use the calculator, usage running […]
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 get following error if you use […]
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 2017 Copyright (c) 1982, 2014, Oracle. […]
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 Copyright (c) 1982, 2017, Oracle and/or […]
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 […]
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/or its affiliates. All rights reserved. […]
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 […]