OraFAQ Forum: Backup & Recovery » Catalog DB is lost

Home » RDBMS Server » Backup & Recovery » Catalog DB is lost (Oracle,any,any)

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

Catalog DB is lost [message #386853]

Tue, 17 February 2009 03:09

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

Report message to a moderator

Re: Catalog DB is lost [message #386867 is a reply to message #386853]

Tue, 17 February 2009 03:24

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

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

Report message to a moderator

Re: Catalog DB is lost [message #386895 is a reply to message #386867]

Tue, 17 February 2009 03:58

dass8484
Messages: 18
Registered: February 2009
Location: India

Junior Member

Hi Michel,

could u pls give the steps

Report message to a moderator

Re: Catalog DB is lost [message #386898 is a reply to message #386895]

Tue, 17 February 2009 04:04

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

Senior Member
Account Moderator

The same ones as with catalog db but with "nocatalog".

Regards
Michel

Report message to a moderator

Re: Catalog DB is lost [message #390213 is a reply to message #386898]

Thu, 05 March 2009 08:13

dass8484
Messages: 18
Registered: February 2009
Location: India

Junior Member

Hi,

But all the info will be in the catalog db...right?

Report message to a moderator

Re: Catalog DB is lost [message #390217 is a reply to message #390213]

Thu, 05 March 2009 08:44

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

Senior Member
Account Moderator

And in the control file.

Regards
Michel

Report message to a moderator

Re: Catalog DB is lost [message #390225 is a reply to message #390217]

Thu, 05 March 2009 09:08

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

Report message to a moderator

Re: Catalog DB is lost [message #390227 is a reply to message #390225]

Thu, 05 March 2009 09:11

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Michel already gave the "steps".
Search the forum/docs before posting.

Report message to a moderator

Re: Catalog DB is lost [message #390229 is a reply to message #390227]

Thu, 05 March 2009 09:17

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

Report message to a moderator

Re: Catalog DB is lost [message #390231 is a reply to message #386853]

Thu, 05 March 2009 09:27

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Catalog DB is lost [message #390232 is a reply to message #390229]

Thu, 05 March 2009 09:28

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	Excluding Tablespace in RMAN Backup Strategy
Next Topic:	rman backup:restoring to new host

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 14:19:28 CST 2024