Tag Archive: RMAN

RMAN detect corruption
  • 17
    Nov

RMAN detect corruption

You can validate your database using Oracle Recovery Manager command BACKUP VALIDATE. RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL; No backup is created. If there are block corruptions you can find them in the dictionary view V$DATABASE_BLOCK_CORRUPTION . By default the...

Read More
Problem affecting rman and redolog
  • 30
    Set

Problem affecting rman and redolog

  I have worked on a db  were a rman configured to make a backup every 2 hour that means every two hours we found in the alert.log ALTER SYSTEM ARCHIVE LOG and the db suddenly slows. The problem was...

Read More
A new feature in Oracle 11g: ACTIVE DUPLICATE
  • 8
    Lug

A new feature in Oracle 11g: ACTIVE DUPLICATE

Very often we need to make copies of the production database in test environments to be able to perform functional tests which can then be issued on production. To make a copy of the database there are several methods. Some...

Read More