We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
Tag Recovery
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
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…
Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned…
The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be…
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…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…
Whenever you are trying to backup Archivelogs from RMAN you might get the following error. Starting backup at 25-FEB-10 current…
SQL> select * from v$flashback_database_log; SQL> show parameter db_file SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=2g; System altered. SQL> alter system set…