Home » RDBMS Server » Backup & Recovery » RMAN Question
RMAN Question [message #240008] Wed, 23 May 2007 18:58 Go to next message
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 #240011 is a reply to message #240008] Wed, 23 May 2007 20:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
YES YOU CAN.
Recovery catalog is recommened on other server not on the same.
you will connect your dbs through service.

And must take backup of recovery catalog after taking backups of productions....
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10770/rcmsynta19a.htm

[Updated on: Wed, 23 May 2007 21:49]

Report message to a moderator

Re: RMAN Question [message #240104 is a reply to message #240011] Thu, 24 May 2007 02:37 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Importing partition of a table to a different tablespace
Next Topic: Database is in 9i and catalog on 10g
Goto Forum:
  


Current Time: Mon Dec 05 10:59:58 CST 2016

Total time taken to generate the page: 0.08019 seconds