RE: Logging into Windows 2000 "Advanced" Server

From: Walthour, Jon (GEAE, Compaq) <Jon.walthour_at_ae.ge.com>
Date: Sat, 08 Sep 2001 20:29:28 -0700
Message-ID: <F001.003877AB.20010908203017@fatcity.com>

The ORA-1113 message suggests that you have a file that needs media recovery, which makes sense considering the abrupt shutdown. Instead of opening the database, mount it first through SVRMGRL, the type "recover database". You may be asked for some archive logs if you're in archivelog mode. Just follow the directions that Oracle provides. You should be able to do a full recovery if the file is not permanently damaged. My guess is that the db may just be out of sync and media recovery will just get things back in sync. After the media recovery finishes, run "alter database open".

To do this, go to a command prompt and type "set" to see all your environment variables. To use SVRMGRL, you need to set your ORACLE_SID variable. To do this, enter "set ORACLE_SID=<your oracle sid goes here>". The run SVRMGRL, connect internal, and mount the database. Then recover it and open it. For example:

C:\>set oracle_sid=mydb

C:\>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production With the Partitioning option
JServer Release 8.1.7.2.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup mount
ORACLE instance started.

Total System Global Area                         52193308 bytes
Fixed Size                                          75804 bytes
Variable Size                                    10342400 bytes
Database Buffers                                 41697280 bytes
Redo Buffers                                        77824 bytes

Database mounted.
SVRMGR>recover database
Database recovered. (There may be more to this step to do any media recovery.)
SVRMGR> alter database open;
Statement processed.
SVRMGR> ... and on you go ...

Hope this helps.

Jon Walthour

-----Original Message-----
Sent: Saturday, September 08, 2001 8:45 PM To: Multiple recipients of list ORACLE-L

Hope somebody can help.

Our network personnel rebooted a Windows 2000 production box without shutting down Oracle. I now have the following error in my alert log: Sat Sep 08 13:45:08 2001 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Sat Sep 08 13:45:08 2001
alter database open
ORA-1113 signalled during: alter database open...

Metalink says to check my environment variables. Is there an equivalent of the UNIX env command on NT? I'm not sure exactly where the environment is defined here. I'd also like to access this database from the command line to manually start it up. Having had no success with the "as SYSDBA" options for sqlplus on either UNIX or NT, I figure I must be using the wrong syntax. I know I can't use terminal services client (because the bequeath protocol doesn't work), but here's what I'm gettiing after I explicitly set the ORACLE_SID (Metalink says the double quotes are mandatory):

sqlplus "<username>/<password> connect as sysdba" Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]

where <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
      <start>  ::= @<filename>[.<ext>] [<parameter> ...]
        "-" displays the usage syntax
        "-?" displays the SQL*Plus version banner
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

TIA - David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: DBarbour_at_austin.isd.tenet.edu

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: Walthour, Jon (GEAE, Compaq)
INET: Jon.walthour_at_ae.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------