OraFAQ Forum: Backup & Recovery » Reg Cold and Hot backup

Home » RDBMS Server » Backup & Recovery » Reg Cold and Hot backup (Oracle 9i)

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

Reg Cold and Hot backup [message #324606]

Tue, 03 June 2008 05:32

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,

My Questions
1.What is meant by Cold and Hot backup,and which is better one ?
2.Any separate reason for these backup process ahead of normal backuping process?

Thanks,
Ram

Report message to a moderator

Re: Reg Cold and Hot backup [message #324618 is a reply to message #324606]

Tue, 03 June 2008 06:07

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

Senior Member
Account Moderator

>>normal backuping process?
What is the meaning of normal backup in your book?
For me, hot backup is the normal backup. Exact method will depend on
the version of Oracle. From 9i and above, RMAN is the most preferred tool.
>>1.What is meant by Cold and Hot backup,and which is better one ?
Always please google / search the forum before posting.
Hot backup may be better in the sense the database that database needs not be shutdown. With the right setup, one can incrementally
backup. Cold backup are taken after shutting. Most very handy for upgrades, patching etc. Hugely dependent on database size.

Report message to a moderator