FAQ
you are right and the developer is not. cold backups taken with the db open
are worthless. you cannot use them to open it back to a consistent state

babu
----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Friday, March 14, 2003 10:44 AM
All...

A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance. I explain that it will be a waste of
tape because the files will be corrupt and useless. He counters, "As
long as these files are there, irrespective of their state, oracle [sic]
provides the tools to restore the skeleton database based on these
files."

Will this be the case? I understand that there will [most likely] be
some loss of data, but will Oracle "fix" itself to a point where it's
useful again? TIA

Gary Chambers

//--------------------------------------
// Lucent Technologies ITO/Servers/Unix
// Senior Unix System Administrator
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//--------------------------------------


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Chambers
INET: gc22_at_lucent.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author: Babu Nagarajan
INET: orclbabu_at_hotmail.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 7 of 13 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 14, '03 at 3:44p
activeMar 14, '03 at 8:09p
posts13
users11
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase