Home » RDBMS Server » Backup & Recovery » backup
backup [message #210373] Wed, 20 December 2006 09:08 Go to next message
yonwatoh
Messages: 4
Registered: December 2006
Location: London
Junior Member

Hello,

Please how can we compare the two backup methods and what is the difference between them (Online (hot backup)/ offline (cold backup)?
Re: backup [message #210374 is a reply to message #210373] Wed, 20 December 2006 09:11 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This provides an overview between the two methods (Online and Offline Backups).
Re: backup [message #210379 is a reply to message #210373] Wed, 20 December 2006 09:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

If you can shutdown or you have downtime then you can take cold backup.
Cold Backup + No Archive log mode.

If you have no downtime then you take Hot backup.

Hot Backup + Archive log mode.


regards
Taj
Re: backup [message #210381 is a reply to message #210379] Wed, 20 December 2006 09:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
user52 wrote on Wed, 20 December 2006 10:22

Cold Backup + No Archive log mode.


Not sure why you specify cold backup + NO archive log. This can be misleading to the OP.
Re: backup [message #210383 is a reply to message #210381] Wed, 20 December 2006 09:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

"ebrian". my point is when database is running in "No Archive Log" mode then you should take "Cold Backup".

is there anything wrong.

reply. plz.
regards
Taj
Re: backup [message #210385 is a reply to message #210383] Wed, 20 December 2006 09:32 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I was trying to indicate that the OP may take that to mean that if doing cold backups, then archive log isn't necessary.
Previous Topic: catalog database
Next Topic: exporting database
Goto Forum:
  


Current Time: Sun Dec 08 07:30:44 CST 2024