Home » RDBMS Server » Backup & Recovery » Recovery Catalog Database Creation
Recovery Catalog Database Creation [message #256430] Sat, 04 August 2007 12:57 Go to next message
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
Re: Recovery Catalog Database Creation [message #256432 is a reply to message #256430] Sat, 04 August 2007 13:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The docs provide all the info you would need (Creating a Recovery Catalog).
Re: Recovery Catalog Database Creation [message #256452 is a reply to message #256432] Sat, 04 August 2007 16:49 Go to previous messageGo to next message
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
Re: Recovery Catalog Database Creation [message #256942 is a reply to message #256430] Tue, 07 August 2007 04:15 Go to previous messageGo to next message
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
Re: Recovery Catalog Database Creation [message #256945 is a reply to message #256942] Tue, 07 August 2007 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Recovery Catalog Database Creation [message #257099 is a reply to message #256942] Tue, 07 August 2007 10:26 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ahmed123 wrote on Tue, 07 August 2007 03:15
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


http://www.cryer.co.uk/brian/oracle/ORA12154.htm
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:
  


Current Time: Tue Dec 06 06:22:44 CST 2016

Total time taken to generate the page: 0.06001 seconds