OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN Question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: RMAN Question [message #240011 is a reply to message #240008]

Wed, 23 May 2007 20:35

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

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

Report message to a moderator

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Previous Topic:	Importing partition of a table to a different tablespace
Next Topic:	Database is in 9i and catalog on 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 23:02:33 CDT 2025