Re:File Restoration/Recovery
Dick... Thanks very much for the reply! 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...) I hate second-guessing myself, but this is what I've been trying to tell him. 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. Here's another direct quote on my admonition for not running the database with archive logging: Thanks again for your help on this. we've [sic] not decided to run oracle in archive mode yet as content on this oracle [sic] instance will only be changed through replication and instead of recovering from archive logs it is easy to recover it from replication. The replication to which he is referring is through the application (Documentum). 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. I considered offering him that option, but that wouldn't solve his problem. The background (briefly) is that this server, until Wednesday, was being administered by an engineer -- it's part of someone's empire here at Lucent, and [WAS] outside of the scope of my Unix system administration team. On Wednesday, one of the hard drives failed, taking with it many of the datafiles Oracle finds useful. Not surprisingly, it quickly became in-scope. We replaced the failed drive, then discovered that the system wasn't even being backed-up. Now, this developer wants a way to recover without, again, having to manually recreate the database. Thanks again for the reply and the assistance!! 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).
Re:File Restoration/Recovery
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).
Re:File Restoration/Recovery
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 ? h, 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, andeverything else that compromises the database (online redo, control files,etc...) or 2) the effected tablespaces are put into hot backup mode before thecopy, in which case when you restore the files Oracle will ask for the archiveredo to roll them forward to the rest of the database. As far as "returning theskeleton database based on these files" he's smoking something good!! What Ibelieve he's more likely asking for is a schema export.Dick GouletReply SeparatorAuthor: Gary Chambers [EMAIL PROTECTED]Date: 3/14/2003 7:44 AMAll...A developer working on a Solaris 2.6 server running Oracle 7.3.4 desiresa nightly backup (by simply copying them to a backup directory) of thedatafiles of an active instance. I explain that it will be a waste oftape because the files will be corrupt and useless. He counters, "Aslong as these files are there, irrespective of their state, oracle [sic]provides the tools to restore the skeleton database based on thesefiles."Will this be the case? I understand that there will [most likely] besome loss of data, but will Oracle "fix" itself to a point where it'suseful again? TIAGary 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).