Home » RDBMS Server » Backup & Recovery » Recovery catalog backup & recovery
Recovery catalog backup & recovery [message #167951] Tue, 18 April 2006 01:53 Go to next message
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 Go to previous messageGo to next message
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
Re: Recovery catalog backup & recovery [message #167958 is a reply to message #167956] Tue, 18 April 2006 02:08 Go to previous messageGo to next message
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.


Re: Recovery catalog backup & recovery [message #167961 is a reply to message #167958] Tue, 18 April 2006 02:17 Go to previous messageGo to next message
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
Re: Recovery catalog backup & recovery [message #169892 is a reply to message #167961] Sun, 30 April 2006 02:44 Go to previous message
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:
  


Current Time: Thu Mar 28 15:21:41 CDT 2024