Hi DBA's I am testing the recovery of the "PROD" SID from hot backups to a Network Attached Storage device. I followed all the prescribed procedures which completed successfully. However, after starting the instance, opening the database, and starting an SQL*Plus session I get the following error message when trying to execute an SQL statement from an SQL*Plus session connected to the newly recovered "DEV2" SID: "ORA-01034: Oracle Not available". I think there is a way to trick Oracle into thinking that a database is local right? However, what I'm trying to do might be breaking the rules because the ORACLE_HOME on the NT server is on local drive D:\ORANT while I have restored the Oracle physical files to N:\Ora_Database\DEV2 which is a mapped drive of a share on a DELL Network Attached Storage device. I already tried changing the ORACLE_HOME path in the listener.ora configuration file. I used both the local and remote paths. Please tell me if I'm wasting my time or give me some help. Thanks in advance for your time, Denmark Weatherburne "Knowledge is power, but it is only useful if it is shared!" _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: [EMAIL PROTECTED] 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: [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).
