Re: rman catalog and current controlfile
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: goran00@xxxxxxxxx, oracle_l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Jul 2007 03:58:32 -0700 (PDT)
another addition you can also make a controlfilecopy from the standby node and
use that to sync the primary per the syntax below.
Syntax ElementDescription
CATALOGUpdates the recovery recovery catalog with RMAN metadata in the current
control file (default) or a control file copy.
CONTROLFILEUpdates the current control file (and recovery catalog, if RMAN is
connected to one) with RMAN metadata from a control file copy.
FROM CONTROLFILECOPY 'filename'Specifies the name of the control file copy to
use for resynchronization. Physical schema information is not updated when you
use this option.
Note: The control file copy can either be in the current database incarnation,
or created in a prior incarnation (that is, prior to the most recent OPEN
RESETLOGS).
----- Original Message ----
From: goran bogdanovic <goran00@xxxxxxxxx>
To: oracle_l <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, July 18, 2007 4:07:31 AM
Subject: rman catalog and current controlfile
Hi all,
I have configuration of one primary and one physical standby. the backups are
done on standby and recovery catalog is in use.
if I connect using rman on primary and catalog, primary is 'aware' of all
backups done on standby. If I connect (rman) with no catalog, primary do not
'see' backups done on standby.
I have tried to find a way (except cataloging backups on primary) to 'refresh'
records in primary controlfile from catalog.
In documentation "Backup and Recovery Reference 10R2' is mentioned command:
RESYNC CONTROLFILE
which says:
<>
The primary use for RESYNC CONTROLFILE occurs when you re-create the control
file
(for example, to change the database name), which causes you to lose RMAN
records.
You can then resynchronize the newly created control file with an old copy.
<>
which is not appropriate in this case.
Does anybody know some method of 'refreshing' the backup info in controlfile
from recovery catalog?
Thanks.
Goran
Other related posts:
