Home » RDBMS Server » Backup & Recovery » whole backup
whole backup [message #459746] Tue, 08 June 2010 03:55 Go to next message
sougatpradhan
Messages: 4
Registered: May 2010
Junior Member
If operating in ARCHIVELOG mode, the DBA also has the option of backing up different parts of the database over a period of time, thereby constructing a whole database backup piece by piece.

how is this whole database backup done please clarify?
what will be the recovery procedure?
Re: whole backup [message #459751 is a reply to message #459746] Tue, 08 June 2010 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 58860
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how is this whole database backup done please clarify?

Er..., piece per piece? Your question is not clear, please clarify.

Quote:
what will be the recovery procedure?

restore
recover

Regards
Michel

[Updated on: Tue, 08 June 2010 04:25]

Report message to a moderator

Re: whole backup [message #459756 is a reply to message #459751] Tue, 08 June 2010 04:35 Go to previous messageGo to next message
sougatpradhan
Messages: 4
Registered: May 2010
Junior Member
as i was going through some book it was written "If operating in ARCHIVELOG mode, the DBA also has the option of backing up different parts of the database over a period of time, thereby constructing a whole database backup piece by piece. "

so i am not able understand the concept of "how to build whole database backup piece by piece over a period of time " and how it differ from full backup(offline).
Re: whole backup [message #459769 is a reply to message #459756] Tue, 08 June 2010 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58860
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He differs in that you back up piece per piece.
He has nothing to do with offline or online, you can do it both whole or piece per piece online or offline.

Your question is still not clear.

Regards
Michel
Re: whole backup [message #459943 is a reply to message #459769] Wed, 09 June 2010 02:21 Go to previous messageGo to next message
sougatpradhan
Messages: 4
Registered: May 2010
Junior Member
Thanks Michel for your time

Basically i want to know what is the difference between whole database backup and full database backup .I am confussed and secondly "how we can construct a whole database backup piece by piece". what does the book author mean by "peice by peice over a period of time" .

Regards
Sougat
Re: whole backup [message #459945 is a reply to message #459943] Wed, 09 June 2010 02:26 Go to previous messageGo to next message
Michel Cadot
Messages: 58860
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what is the difference between whole database backup and full database backup.

I don't know as I don't what you mean by these 2 terms, for me whole and full are identical.
Maybe you can say that "full database" is using "backup full database" when "whole database" is backup all the components of the database piece by piece.

"piece by piece" means "part of database (one or several tablespaces) by part of database".

Regards
Michel

[Updated on: Wed, 09 June 2010 02:27]

Report message to a moderator

Re: whole backup [message #459948 is a reply to message #459945] Wed, 09 June 2010 02:33 Go to previous message
sougatpradhan
Messages: 4
Registered: May 2010
Junior Member
Thanks for the clarification

Sougat
Previous Topic: Loss of all redo logs
Next Topic: insufficient privileges while connecting sys user
Goto Forum:
  


Current Time: Fri Aug 22 06:46:53 CDT 2014

Total time taken to generate the page: 0.10452 seconds