Home » RDBMS Server » Backup & Recovery » Catalog DB is lost (Oracle,any,any)
Catalog DB is lost [message #386853] Tue, 17 February 2009 03:09 Go to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
Hi All,

Iam new to this forum...

I have a doubt in RMAN restore and recovery....


I have a catalog database and one target db is registered with it...

Now the scenario is, i want to do a incomplete recovery for my database.

i found out the catalog db is also crashed....

So how to recover a database with out using a catlaog db
Re: Catalog DB is lost [message #386867 is a reply to message #386853] Tue, 17 February 2009 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Catalog db is not required, you can always use control file as catalog.
Just try it using "nocatalog" as option when you connect to rman.

Regards
Michel
Re: Catalog DB is lost [message #386895 is a reply to message #386867] Tue, 17 February 2009 03:58 Go to previous messageGo to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
Hi Michel,

could u pls give the steps
Re: Catalog DB is lost [message #386898 is a reply to message #386895] Tue, 17 February 2009 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The same ones as with catalog db but with "nocatalog".

Regards
Michel
Re: Catalog DB is lost [message #390213 is a reply to message #386898] Thu, 05 March 2009 08:13 Go to previous messageGo to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
Hi,

But all the info will be in the catalog db...right?
Re: Catalog DB is lost [message #390217 is a reply to message #390213] Thu, 05 March 2009 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And in the control file.

Regards
Michel
Re: Catalog DB is lost [message #390225 is a reply to message #390217] Thu, 05 March 2009 09:08 Go to previous messageGo to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
U mean the target DB...


Could u pls give the steps, it will help ful for me
Re: Catalog DB is lost [message #390227 is a reply to message #390225] Thu, 05 March 2009 09:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Michel already gave the "steps".
Search the forum/docs before posting.
Re: Catalog DB is lost [message #390229 is a reply to message #390227] Thu, 05 March 2009 09:17 Go to previous messageGo to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
Sorry mahesh...

I didnt get any docs on this topic, thats y i posted .

Atleast,pls give the link
Re: Catalog DB is lost [message #390231 is a reply to message #386853] Thu, 05 March 2009 09:27 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
When all else fails it is time to Read The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm
Re: Catalog DB is lost [message #390232 is a reply to message #390229] Thu, 05 March 2009 09:28 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.google.com/search?hl=en&q=rman+connect+nocatalog&btnG=Search&aq=f&oq=

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup003.htm#sthref221


Also to get better response,
Do not use IM style language here. Avoid u=you y=why and so on.
Most of the folks here are not native English speakers
or
under the age of 15 and used to "texting".
Always please post the Oracle versions,OS etc.
Please read the posting guides.
Previous Topic: Excluding Tablespace in RMAN Backup Strategy
Next Topic: rman backup:restoring to new host
Goto Forum:
  


Current Time: Wed Dec 07 06:45:09 CST 2016

Total time taken to generate the page: 0.14758 seconds