Re: Fun with backup

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 24 Sep 2012 17:05:32 +0000 (UTC)
Message-ID: <pan.2012.09.24.17.04.56_at_gmail.com>

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: 
TAG20120923T160006
        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/
system01.dbf
  2       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
sysaux01.dbf
  3       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
undotbs01.dbf
  4       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/
users01.dbf
  5       Full 3076374    2012-09-23 15:49:58 /data/oracle/data/O11/

example01.dbf

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
http://mgogala.byethost5.com

Received on Mon Sep 24 2012 - 12:05:32 CDT