OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » backup

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

backup [message #210373]

Wed, 20 December 2006 09:08

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)?

Report message to a moderator

Re: backup [message #210374 is a reply to message #210373]

Wed, 20 December 2006 09:11

ebrian
Messages: 2794
Registered: April 2006

Senior Member

This provides an overview between the two methods (Online and Offline Backups).

Report message to a moderator

Re: backup [message #210379 is a reply to message #210373]

Wed, 20 December 2006 09:22

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

Report message to a moderator

Re: backup [message #210381 is a reply to message #210379]

Wed, 20 December 2006 09:24

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.

Report message to a moderator

Re: backup [message #210383 is a reply to message #210381]

Wed, 20 December 2006 09:29

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

Report message to a moderator

Re: backup [message #210385 is a reply to message #210383]

Wed, 20 December 2006 09:32

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.

Report message to a moderator

Previous Topic:	catalog database
Next Topic:	exporting database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 00:02:48 CDT 2024