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