Now, you could put the tablespaces in read only mode, then the copy would
work. But then again, could you put all the tablespaces in read only mode
?
hmmmm, don't think so :).
>>> [EMAIL PROTECTED] 03/14/03 11:54AM >>>
Gary,
Only if 1) The database is shutdown prior to the copy of the datafiles, and
everything else that compromises the database (online redo, control files,
etc...) or 2) the effected tablespaces are put into hot backup mode before the
copy, in which case when you restore the files Oracle will ask for the archive
redo to roll them forward to the rest of the database. As far as "returning the
skeleton database based on these files" he's smoking something good!! What I
believe he's more likely asking for is a schema export.
Dick Goulet
____________________Reply Separator____________________
Author: Gary Chambers <[EMAIL PROTECTED]>
Date: 3/14/2003 7: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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
>>> [EMAIL PROTECTED] 03/14/03 11:54AM >>>
Gary,
Only if 1) The database is shutdown prior to the copy of the datafiles, and
everything else that compromises the database (online redo, control files,
etc...) or 2) the effected tablespaces are put into hot backup mode before the
copy, in which case when you restore the files Oracle will ask for the archive
redo to roll them forward to the rest of the database. As far as "returning the
skeleton database based on these files" he's smoking something good!! What I
believe he's more likely asking for is a schema export.
Dick Goulet
____________________Reply Separator____________________
Author: Gary Chambers <[EMAIL PROTECTED]>
Date: 3/14/2003 7: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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
