| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: RE: Online vs offline backups
Hi, guys,
We have discussed this topic many times on this list. Actually a good DBA
should design a good backup and restore strategy instead of "online or
offline" according to business situation.
>From my opinion, both "online" and "offline" are necessary, for example, I
do monthly offline line cold backup and daily online hot backup on my
production db. The only thing you need to know is that if you do offline
backup, you should backup every thing, include online redo logs, otherwise,
you may lost some data; if you do online hot backup, the online redo logs
are useless when you do restore.
Cheers!
Shine Sha
Snr. Oracle DBA
iGINE Pte. Ltd.
-----Original Message-----
Thomas F
Sent: Thursday, June 20, 2002 12:44 AM
To: Multiple recipients of list ORACLE-L
chaos,
if you believe everything you read in the oracle docs, then your are NOT a thinking DBA. just because they failed to mention that you should backup the log files does NOT mean you should not back them up.
as everyone who knows anything has stated in this thread, this is a very bad idea. never mind the "what if" scenario you mentioned. anyone who is performing a database restore had better know exactly what and where they are restoring to (what point in time), and the condition of all of the database files on the disk before they begin. if they don't, they are in for trouble.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, June 19, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
hi, Mercadante, Thomas F£¬ÄúºÃ£¡
But according to Oracle Document(which i believe), oracle backup and recovery guide (version 8.1.6)page 4-4: it said:
Use operating system commands or a backup utility to make backups of all
datafiles and all control files specified by the CONTROL_FILES parameter of
the initialization parameter file. Also back up the initialization parameter
file
and other Oracle product initialization files. To find them, do a search for
*.ora starting in your Oracle home directory and recursively search all of
its
subdirectories.
You can see, oracle mentions everything it need, but it does not mention the online redo log.
And:
Is the online redo log useful in recovery since you do a full clean
cold backup? Just do a clear logfile group 1,2,3 and you cleanly opened your
database when you Just restore the datafile,controlfiles.If you want to make
full recovery, the online redo log is also totally USELESS. And if you
carelessly overlay the old online redo log, the CURRENT ACTIVE ONLINE REDO
LOG WILL BE DESTROYED! so , you cannot do complete recovery.
This is my opinions.Though i also do not do coldbackup.
Good luck!
chaos
chaospku_at_163.net
zhu chao
DBA of Eachnet.com
86-021-32174588-667
ÔÚ 2002-06-19 06:43:00 You wrote:
>chal_ping
>
>What? Makes no sense. Why NOT backup everything if you are taking a Cold
>Backup. Why make yourself perform an open reset logs upon a recovery?
>
>This is bad advice.
>
>Personally, I use Rman performing hot backups all the time. My database is
>*always* open to the world.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Wednesday, June 19, 2002 8:38 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ferenc Mantfeld£¬
>
>>The same person that advocated a cold backup
>>did not back up the online redo logs, so what use was it anyway, since the
>>only way they would force open their DB is with a resetlogs option anyway.
> For cold backup, oracle does not recommend backup the online redo
>log. And if you restore the whole cold backup, why need the online redo
log?
>I am sure people doing cold backup will do shutdown normal/immediate, not
>shutdown abort.So there is no need to backup the online redo log at all!
>Backup the online redo log also take the risk of damage the current online
>redo log when you want to do full recovery.
> So, never backup the online redo log when doing cold backup.
>
> ÖÂ
>Àñ£¡
>
> chal_ping
> chaospku_at_163.net
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: chal_ping
> INET: chaospku_at_163.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: chaospku_at_163.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shine_DBA INET: shine_dba_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jun 24 2002 - 00:38:18 CDT
 |
 |