Home » RDBMS Server » Server Administration » RMAN HOT BACKUP
RMAN HOT BACKUP [message #215525] Mon, 22 January 2007 13:08 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi,

We have created a database of size 75GB. We are planning to implement RMAN (Weekly) Hot backup for this database.

I have some questions that has to be get cleared before implementing RMAN backup.

a, Is I has to create another small new database for RMAN catalog as source to connect the target database?

b, How much should be the appropriate size of this small database to hold the backup (compressed backup)?

Database : Oracle 10gR2
OS : Sun Solaris 5.8

Regards,

Prashanth




Re: RMAN HOT BACKUP [message #215526 is a reply to message #215525] Mon, 22 January 2007 13:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> a, Is I has to create another small new database for RMAN catalog as source to connect the target database?
Upto you.
If you want to use recovery catalog, a seperate small database is required. Else, you can just use the controlfile (no catalog mode).

>>b, How much should be the appropriate size of this small database to hold the backup (compressed backup)?
Time to read documentation.
This small database does NOT HOLD BACKUP DATA compressed/or whatever.
It will just store the information on backupsets (metadata) and is usually very small (just stores the information on backupsets, its location etc).
Please read RMAN documentation. Everything is already clearly explained over there.

[Updated on: Mon, 22 January 2007 13:18]

Report message to a moderator

Re: RMAN HOT BACKUP [message #215528 is a reply to message #215525] Mon, 22 January 2007 13:25 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As said before,
all your questions are exactly answered here, in the manual.
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14193/toc.htm#i766400
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcatdb001.htm#sthref923
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmarchi003.htm#sthref75

The manual
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm
Previous Topic: deleting files in recovery area
Next Topic: How to upgrade oracle client from 9.2.0.1 to 9.2.0.7?
Goto Forum:
  


Current Time: Fri Sep 20 06:34:18 CDT 2024