OraFAQ Forum: Backup & Recovery » Recovery catalog backup & recovery

Home » RDBMS Server » Backup & Recovery » Recovery catalog backup & recovery

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

Recovery catalog backup & recovery [message #167951]

Tue, 18 April 2006 01:53

gajini
Messages: 262
Registered: January 2006

Senior Member

HI,

I read in Oracle documentation about how to do Recovery catalog backup & recovery,but i couldn't understand,can anyone explain to me with more practical example.

In my RMAN setup,
the target database is NEWDB
the recovery catalog database is TESTDB1 (DEFAULT TABLESPACE FOR THE RMAN user is TOOLS,whose datafile is "TOOLS01.DBF".

What does the Recovery catalog database mean?Is it backup of the corresponding datafile,in this case TOOLS01.DBF?

Please anyone explain me with an example.

Thanks in advance,
Malru

[Updated on: Tue, 18 April 2006 02:05]

Report message to a moderator

Re: Recovery catalog backup & recovery [message #167956 is a reply to message #167951]

Tue, 18 April 2006 02:01

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

Go to Command Prompt

RMAN target=sys/password@NEWDB catalog=RMAN/PASSWORD@TESTDB1

RMAN>register database;
RMAN>create catalog;
RMAN>run {
     allocate channel c1 type disk;
     backup database;
     release channel c1;
     }

Rgds
SALIH KM Cool

Report message to a moderator

Re: Recovery catalog backup & recovery [message #167958 is a reply to message #167956]

Tue, 18 April 2006 02:08

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi SALIH KM,

Thanks SALIH KM.

I'm asking about backing up the catalog database,not the target database.I think you'll be clear now,so please tell me how to do catalog database backup & recovering it.

Report message to a moderator

Re: Recovery catalog backup & recovery [message #167961 is a reply to message #167958]

Tue, 18 April 2006 02:17

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

Use cold or hot backup or you can use the rman backup without catalog.

rman target=sys/password@testdb1 nocatalog

RMAN> run {
      allocate channel c1 type disk;
      backup database;
      release channel c1;
      }

Rgds
SALIH KM Cool

Report message to a moderator

Re: Recovery catalog backup & recovery [message #169892 is a reply to message #167961]

Sun, 30 April 2006 02:44

lakher
Messages: 14
Registered: April 2006

Junior Member

backup catalog can use exp/imp

[Updated on: Sun, 30 April 2006 02:59]

Report message to a moderator

Previous Topic:	RMAN 'Duplicate'
Next Topic:	restore database using datafiles controlfiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:32:13 CST 2024