This Article first appeared in a Medium blog post Oracle Container Database (CDB) is a multi-tenant architecture that allows you…
Category 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…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON 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…
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…
**************** Cloning of the Oracle Database ******************** On production 1) Make sure controlfile autobackup is on and take the incremental…