RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went missing and there was a gap. After doing the restore we got the below error in the RMAN recovery rman nocatalog target sys/******@mw auxiliary / connected to target database: MW (DBID=000000000) using target database control … Continue reading RMAN — ORA-19909: datafile 1 belongs to an orphan incarnation in a Standby Database.

Guaranteed Restore Points Oracle 11g

Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database to a time without tradional point in time recovery. Guaranteed restore points are basically alias'es for SCN's A normal restore point assigns a restore point name to an SCN or specific point in time.The control … Continue reading Guaranteed Restore Points Oracle 11g

Flashback Table to Timestamp 11gR2

Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver. You can even rollback a query to a point in time without requiring traditional database restore. I will demonstrate below how to do flashback a table to a point in time. But first you have … Continue reading Flashback Table to Timestamp 11gR2

RMAN Point-In-Time Recovery

RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup - this example assumes you are running RMAN without a Catalog and are performing a Restore & Point-In-Time Recovery of all data back to a particular date/time in the past. If you are running in Archive log mode and … Continue reading RMAN Point-In-Time Recovery

Block Media Recovery using RMAN ( Oracle 10g)

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 above error in Application. This means a block has been corrupted on the disk. In this scenario we had last nights RMAn backup. IF you do not have RMAN configured. Please make sure RMAN backups … Continue reading Block Media Recovery using RMAN ( Oracle 10g)

Restore ControlFile with RMAN / Without RMAN

Restoring a controlfile without rman _____________________________________ suppose you lost a controlfile say control01.ctl. The controlfile got deleted but you have the controlfile control02.ctl control03.ctl Now when you login to database, you get below error SQL> shutdown immediate ORA-00210: cannot open the specified control file /u2/oracle/product/10.1.0/db/oradata/SWX/control01.ctl’ ORA-27041: unable to open file SVR4 Error: 2: No such … Continue reading Restore ControlFile with RMAN / Without RMAN

A Ballad For a DBA

Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned to fear and to get out of his way He would drop production tables when complaints had grown to loud He would smile and feign surprise and then suggested “use the cloud” He would backup … Continue reading A Ballad For a DBA

I've lost an archived/online REDO LOG file, can I get my DB back?

The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be handy if you do database recovery and one of the archived log files are missing and cannot be restored. NOTE: Caution is advised when enabling this parameter as you might end-up losing your entire database. … Continue reading I've lost an archived/online REDO LOG file, can I get my DB back?

Oracle Database HA Architecture

By Uwe Hesse Link to original post: http://uhesse.wordpress.com/oracle-database-ha-architecture/ A very popular topic in many of my courses is Oracle Database Architecture regarding High Availability (HA). This page is supposed to address this topic with a high level overview, covering “Ordinary” Single Instance Databases, Data Guard, Real Application Clusters (RAC) and Extended RAC (sometime called “Stretched … Continue reading Oracle Database HA Architecture

Backup Controlfile to Trace

How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control File, or you generate a text file script which will re-generate a Control File when run as a SQL script. To create the binary image, issue the command ALTER DATABASE BACKUP CONTROLFILE TO 'C:\SOMEWHERE\CONTROL01.BKP'; (obviously … Continue reading Backup Controlfile to Trace