Subscriber Count

    459

Subscribe to Posts by Email

Pages

Duplicate Standby : Issues & Issues all the way

Well doing,

All the DBA’s using the duplicate database to build a standby database and its proved most of the times it works. But it happens sometimes that it creates a series of issues.

Thanks to our good old DBA Basavaraju (a very long time DBA) for pointing out this series of issues and […]

12c Database : RMAN Enhancement : Rollfoward standby using network service without incremental backups

As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log

Check on Primary

SQL> archive log […]

12c Database : RMAN Enhancement : Restore the datafiles directly from Standby using TNS Service

From 12c Onwards, RMAN has been enhanced to restore/recover the datafiles/tablespaces etc from the network services rather copying them manually. This enhanancement facilitates easy recovery operations when you have standby database without backups or activation etc. YOu can even recover the database from standby using service in RMAN in restore command.

Lets see how […]

Step by Step Migrating RAC Database to a new Cluster

Excellent step by step document from my colleague, Venkat, with his kind permission I am publishing the same for all benefit.

Please note the following can be done using Duplicate database from active database without moving any backups etc. But that is another variant.

########################################################################################### Copy RAC database to another RAC Server ###########################################################################################

Task: Copy […]

Archive missing ? Recover standby using roll forward standby with incremental backup

Here is the step by step document for recovering the standby if archive is missing and not recoverable, using a feature called rollforward standby using incremental backup introduced in 10g.

1) After recovery in step above login to sqlplus and get the current scn from standby database;

SQL> col CURRENT_SCN format 999999999999

SQL> select current_scn […]

Basics: Oracle Corruptions Series #3: How to find physical corruptions and limitations with each approach.

Series: Part 1, Part 2, Part3

Typical Oracle physical corruptions may pose are,

(a) ORA-01578 – This error explains physical structural damage with a particular block.

(b) ORA-08103 – This error is a logical corruption error for a particular data block.

(c) ORA-00600 [2662] – This error is related to block corruption , and occurs […]

Basics: Oracle Corruptions Series #2: Very good note on different types of Oracle corruption

Series: Part 1, Part 2, Part3

Some good metalink notes for my reference and for your record.

Master Note for Handling Oracle Database Corruption Issues [ID 1088018.1]

Identify the corruption extension using RMAN/DBV/ANALYZE etc [ID 836658.1]

Handling Oracle Block Corruptions in Oracle7/8/8i/9i/10g/11g [ID 28814.1]

How to identify all the Corrupted Objects in the Database with […]

Basics: Oracle Corruptions series #1: Physical & Logical Corruptions in Oracle

Series: Part 1, Part 2, Part3

Oracle will have two types of corruptions , Physical & Logical corruptions.

Physical Block Corruptions

This kind of block corruptions are normally reported by Oracle with error ORA-1578 and the detailed corruption description is printed in the alert log. Corruption Examples are:

Bad header – the beginning of the […]

ora-01610: recovery using the BACKUP CONTROLFILE option must be done, but how does Oracle knows where does it see?

SQL> recover database ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Am trying to recover a database after a controlfile lost and restored from the backup. But How does Oracle knows that we are using a backup control file where does it look after to get […]