OraFAQ Forum: Backup & Recovery » Recovery Catalog Database Creation

Home » RDBMS Server » Backup & Recovery » Recovery Catalog Database Creation

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

Recovery Catalog Database Creation [message #256430]

Sat, 04 August 2007 12:57

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Hello there,

I read in a book that it is more advantageous to store RMAN backup in a catalog database than in the DB controlfile.

And that I should create a recovery catalog databse that is about 115mb including datafiles and redolog which Oracle recommends.

My question is how will i create the recovery catalog database with this size (115mb)... can anyone help ... preferably with the creation scripts.

Thanks in good anticipation.

Regards,

Cherish

Report message to a moderator

Re: Recovery Catalog Database Creation [message #256432 is a reply to message #256430]

Sat, 04 August 2007 13:08

ebrian
Messages: 2794
Registered: April 2006

Senior Member

The docs provide all the info you would need (Creating a Recovery Catalog).

Report message to a moderator

Re: Recovery Catalog Database Creation [message #256452 is a reply to message #256432]

Sat, 04 August 2007 16:49

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

RMAN ( CATALOG CREATION ) STEP BY STEP

http://forums.oracle.com/forums/thread.jspa?threadID=227461

Report message to a moderator

Re: Recovery Catalog Database Creation [message #256942 is a reply to message #256430]

Tue, 07 August 2007 04:15

ahmed123
Messages: 9
Registered: August 2007
Location: india

Junior Member

Hiii

I want to do backup using rman
i created one database on my PC name muj

Created one tablespace
creates user rman
grant him reocvery_catalog_owner

but when iam connecting

connect rman/rman@muj

iam getting errror ORA 12154
TNS could not resolve connect identifier

PLZ help me to solve the prob

Report message to a moderator

Re: Recovery Catalog Database Creation [message #256945 is a reply to message #256942]

Tue, 07 August 2007 04:21

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post a new topic, don't use an old one for another question.
Search before posting, error 12154 is very often posted the answer is the same for you than other posters.

Regards
Michel

Report message to a moderator

Re: Recovery Catalog Database Creation [message #257099 is a reply to message #256942]

Tue, 07 August 2007 10:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

ahmed123 wrote on Tue, 07 August 2007 03:15

http://www.cryer.co.uk/brian/oracle/ORA12154.htm

Report message to a moderator

Previous Topic:	How to create Rman backup script for database,controlfile and archivelog in one script
Next Topic:	Attach a tablespace to a database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 16:28:37 CST 2025