This Article first appeared in a Medium blog post Oracle Container Database (CDB) is a multi-tenant architecture that allows you…
Tag RMAN
One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the…
Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to…
Source Database ————— ::: Directory Structure ::: ORACLE_HOME : E:\oracle\product\10.2.0\db_1 RMAN Backup : E:\rman_backup_full Control Files : E:\oradata\ecc DataFiles: E:\oradata\ECC…
— If doing on Source Server — ::12c–>sqlplus “/as sysdba” set head off pages 0 feed off echo off verify…
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
[sourcecode language=”sql”] run { allocate channel sbt1 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate channel sbt2 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; CONFIGURE DEFAULT…
Setup for the Environment ——————- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home…
Solution: This happens when you havea RAC setup and you are backing up the Snapshot of the controlfile to a…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…
ORA-01578: ORACLE data block corrupted (file # 19, block # 461509) ORA-01110: data file 19: ‘E:\ORACLE\ORADATA\PLACID\CARA_NS.ORA’ You are getting the…
Restoring a controlfile without rman _____________________________________ suppose you lost a controlfile say control01.ctl. The controlfile got deleted but you have…
Transportable Tablespace across Different Platforms ___________________________________________________ In our example we will transport a tablespace called TEST. The tablespace should be…
Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current…
1. Turn on block checking REASON: The aim is to detect, very early the presence of corrupt blocks in the…