 |
|
| Computers Forum Index » Computer - Databases - Oracle (Server) » Oracle10g, Catalog and control file... |
|
Page 1 of 1 |
|
| Author |
Message |
| Fabrice... |
Posted: Sat Oct 24, 2009 5:16 pm |
|
|
|
Guest
|
Hello,
I have just configured a catalog for RMAN in another instance.
I realized some backups before creating the catalog. The synchronization has
been realized after the creation.
Now, I use the catalog. But I'm suprise by the fact :
1. that the Controlfile is following to grow.
2. either i'm connect to the "control file" or the catalog, the
command "list backup summary" shows the same result.
Example :
rman> connect target /
rman> list backup summary --> Tell me that I'm using the control file. And
the new backups are displayed.
rman> connect target / catalog rman/rman at (no spam) mycatalog
rman> list backup summary --> display all the new backups.
I don't understand why I can see the list of all the backups when I'm not
connect to the catalog.
Thanks for your help.
fabrice |
|
|
| Back to top |
|
|
|
| ddf... |
Posted: Sat Oct 24, 2009 5:16 pm |
|
|
|
Guest
|
On Oct 24, 8:16 am, Fabrice <t... at (no spam) test.com> wrote:
Quote: Hello,
I have just configured a catalog for RMAN in another instance.
I realized some backups before creating the catalog. The synchronization has
been realized after the creation.
Now, I use the catalog. But I'm suprise by the fact :
1. that the Controlfile is following to grow.
2. either i'm connect to the "control file" or the catalog, the
command "list backup summary" shows the same result.
Example :
rman> connect target /
rman> list backup summary --> Tell me that I'm using the control file. And
the new backups are displayed.
rman> connect target / catalog rman/rman at (no spam) mycatalog
rman> list backup summary --> display all the new backups.
I don't understand why I can see the list of all the backups when I'm not
connect to the catalog.
Thanks for your help.
fabrice
It's the way RMAN works; it always writes to the controlfile. This
allows RMAN to recover a database even after the catalog database has
also 'bitten the dust'. You don't stop writing to the controlfile
just because you connect to the catalog. I wouldn't have it any other
way.
David Fitzjarrell |
|
|
| Back to top |
|
|
|
| Mark D Powell... |
Posted: Sat Oct 24, 2009 9:28 pm |
|
|
|
Guest
|
On Oct 24, 10:22 am, ddf <orat... at (no spam) msn.com> wrote:
Quote: On Oct 24, 8:16 am, Fabrice <t... at (no spam) test.com> wrote:
Hello,
I have just configured a catalog for RMAN in another instance.
I realized some backups before creating the catalog. The synchronization has
been realized after the creation.
Now, I use the catalog. But I'm suprise by the fact :
1. that the Controlfile is following to grow.
2. either i'm connect to the "control file" or the catalog, the
command "list backup summary" shows the same result.
Example :
rman> connect target /
rman> list backup summary --> Tell me that I'm using the control file. And
the new backups are displayed.
rman> connect target / catalog rman/rman at (no spam) mycatalog
rman> list backup summary --> display all the new backups.
I don't understand why I can see the list of all the backups when I'm not
connect to the catalog.
Thanks for your help.
fabrice
It's the way RMAN works; it always writes to the controlfile. This
allows RMAN to recover a database even after the catalog database has
also 'bitten the dust'. You don't stop writing to the controlfile
just because you connect to the catalog. I wouldn't have it any other
way.
David Fitzjarrell- Hide quoted text -
- Show quoted text -
Better yet, if you have only one or two databases that you are backing
up with rman you do not need a catalog database at all. The control
file is all you need. Your backup will include the control file so in
the event you lose your control file you first just restore the
control file from the backup then you run a restore using a backup
control file.
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Mon Dec 07, 2009 7:39 pm
|
|