Orlando,
What happens if you go to take a backup and the database containing the catalog
is unavailable? Can your rman scripts cope with this, or will they fail and you
don't get any backups that night because the catalog was down or unreachable.
You may want to consider performing the backup without connecting to the
catalog. Once the backup is complete, connect to the catalog and perform a
"resync catalog" command. If that fails you can resync it later but you still
created your backup and all of the backup information is in the controlfile.
Backup history is kept in the controlfile for "CONTROL_FILE_RECORD_KEEP_TIME".
The default is 7 days, which I find very small and generally increase to 64
days (2 months plus a bit). The amount of space taken by a controlfile is
pretty irrelevant in the scheme of things.
Ensure you backup your controlfiles as part of the standard backup.
You should also ensure you backup any password files, especially if you use
FlexASM as the internally generated FlexASM password is not one with which you
want to experience an unrecoverable problem.
regards
Neil Chandler
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Orlando L <oralrnr@xxxxxxxxx>
Sent: 12 May 2017 07:46
To: Stefan Koehler
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: backup info in db controlfile with catalog
Thanks Stefan. Will the information about the backup settings and backup
history will still be available in the target db's controlfile.
On Sun, May 7, 2017 at 2:02 AM, Stefan Koehler
<contact@xxxxxxxx<mailto:contact@xxxxxxxx>> wrote:
Hey Orlando,
will the backup information be still available in the database's controlfile?
Orlando L <oralrnr@xxxxxxxxx<mailto:oralrnr@xxxxxxxxx>> hat am 7. Mai 2017 um
06:40 geschrieben:
All
We are trying to set up catalog for rman for our db systems. If we set
up catalog and connect to it when we do backups, will the backup
information be still available in the database's controlfile? ie, will
we be able to get data from, say v$rman_bacup_job_dtls or
v$rman_outpt.
TIA,
Orlando