Re: Fun with backup

From: Mladen Gogala <>
Date: Mon, 24 Sep 2012 17:05:32 +0000 (UTC)
Message-ID: <>

On Mon, 24 Sep 2012 14:32:44 +0000, Mladen Gogala wrote:

> That, in particular, means that there is no recovery without a restart
> if backup is taken off the standby database. I must say I hoped that
> this would be a bit more flexible and allow me to set the DB_UNIQUE_NAME
> and do the restore. What I can do is to backup a datafile as a copy on
> standby, copy the file to the primary and catalog it there using RMAN.
> There is a solution, but it's far from automated and requires some work.

I even tried resyncing from DB_UNIQUE_NAME, still no cigar:

RMAN> resync catalog from db_unique_name ALL;

starting full resync of recovery catalog full resync complete

resyncing from database with DB_UNIQUE_NAME STBY

RMAN> list backup of database;

specification does not match any backup in the repository

RMAN> list backup of database for db_unique_name='STBY';

List of Backup Set for database with db_unique_name STBY

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ -------------------
431     Full    1.27G      DISK        00:01:06     2012-09-23 16:01:14
        BP Key: 435   Status: AVAILABLE  Compressed: NO  Tag: 
        Piece Name: /data/oracle/backup/fulldb1enlu9g8_1_1.bak
  List of Datafiles in backup set 431
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
  2       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
  3       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
  4       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
  5       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/

RMAN> BTW, as the good book says, in order to do the resync this way, DB_UNIQUE_NAME needs to be configured for the corresponding identifier in the recovery catalog. When doing tricks like this, RMAN catalog has to be used.

Mladen Gogala
The Oracle Whisperer
Received on Mon Sep 24 2012 - 12:05:32 CDT

Original text of this message