Home » RDBMS Server » Backup & Recovery » Hot backup
Hot backup [message #145572] Thu, 03 November 2005 20:13 Go to next message
chandan_001
Messages: 3
Registered: November 2005
Location: vizag
Junior Member
Hi

HotBackup means only tablespaces backup or also the backup of controlfile and log files also.

Normally in real time, to take hot backup we need to run a script, this will take backup of only datafiles or also the backup of control files and log files also.

Plz clear this doubt.


-chandan
Re: Hot backup [message #145609 is a reply to message #145572] Fri, 04 November 2005 03:10 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
when taking hot backup, take backup of datafiles & controlfile only.

No need to backup redologs.

--Girish
Re: Hot backup [message #145613 is a reply to message #145609] Fri, 04 November 2005 03:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>HotBackup means only tablespaces backup or also the backup of controlfile and log files also.
Says who?
Never, ever ,never backup redolog files.
Re: Hot backup [message #145696 is a reply to message #145572] Fri, 04 November 2005 20:47 Go to previous messageGo to next message
chandan_001
Messages: 3
Registered: November 2005
Location: vizag
Junior Member
archive logs are required to take backup?

Re: Hot backup [message #145712 is a reply to message #145696] Sat, 05 November 2005 03:33 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
DB has to be in archive log mode for taking hot backup. Otherwise its not possible.

Also, I would advise that you start reading some docs related to general DB administration. They will come handy for you.

--Girish
Re: Hot backup [message #145734 is a reply to message #145572] Sat, 05 November 2005 10:29 Go to previous message
Steve Callan
Messages: 44
Registered: January 2004
Member
A hot backup, technically speaking, does not include control files. You can and should have backups of control files, but that is an extra step in terms of what a hot backup is. You should backup a control file AFTER a stuctural change has been made.

It's free, start reading before you get into trouble:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96572/toc.htm

Previous Topic: Oracle Checkpoints
Next Topic: while taking backup
Goto Forum:
  


Current Time: Thu Dec 01 14:40:48 CST 2022