| RMAN Question [message #240008] |
Wed, 23 May 2007 18:58  |
california_6_1
Messages: 29
Registered: February 2007
|
Junior Member |
|
|
I was wondering, if this scenario is possible?
I would like to setup a central RMAN repository and catalog all the databases running out on other servers to this repository?
But my question is, how could i catalog these databases running on other servers? I assume through an entry in tnsnames.ora. but was curious, if this works or not? if yes, then from performance point of view, is it OK to backup large database from this central location? I.E, like 100GB?
Appreciated if someone please share some thought process.
Thanks,
Cali
|
|
|
|
|
|
| Re: RMAN Question [message #240104 is a reply to message #240011] |
Thu, 24 May 2007 02:37  |
california_6_1
Messages: 29
Registered: February 2007
|
Junior Member |
|
|
Thank you so much for your answer DreamZ.
You said, recovery catalog is needed on other server. I am not quiet sure, what this means? But here's my scenario: My catalog database is running on a server by name "Backup" and the other production databases are running on prod1 and prod2 and named as finance on prod1 and sales on prod2.
So my question is, if i have the service names configured (finance and sales) on my backup server (Backup), then can i backup these databases through RMAN from this "Backup" server?
The connect syntax might be something like this: Is this right?
rman catalog backup/backup@backup target backup/backup@finance
Help me, if i listed anything wrong.
Many thanks again,
Cali
|
|
|
|
| Re: RMAN Question [message #240109 is a reply to message #240104] |
Thu, 24 May 2007 02:50 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
recovery catalog is needed on other server
Create Separate database for RECOVERY CATALOG.'
rman TARGET=usrname/pwd@prod1 CATALOG=rman/cat@catdb
rman TARGET=usrname/pwd@prod2 CATALOG=rman/cat@catdb
rman>register database;
Note:
prod1 --> finance database
prod2 --> sales database
catdb --> catalog database
Regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
