Re: Issues when using SVRMGRL

Are you sure the database was shutdown properly.

By the sounds of the message you are getting for the start up command it doesn't sound like you ORACLE_SID is set.

Open a command window (DOS prompt) and type the following set ORACLE_SID=YOURDB where YOURDB is the name of your database

next run svrmgrl and the connect internal (assuming you are on the NT box as the person that installed Oracle)
now try a shutdown immediate (personally I recommend only using abort in do or die situations)

once the db is down the issue a startup mount followed by the other commands from you docs.

I assume you made the changes to the init.ora to specify where the archive log files should be placed etc etc.

HTH
Scott Watson.

Joseph Ahmad <jahmad2088_at_home.com> wrote in message news:CII47.491628$eK2.101856538_at_news4.rdc1.on.home.com...
> Good Afternoon,
>
> I'm a not yet comfortable with administering Oracle 8i, so please forgive
> the simplicity of my posting. We are currently running Oracle 8i Release
> 8.1.7.0.0 on Windows NT 4.0 (service pack 5), and I'm attempting to
> configure the ARCServe "Oracle Agent" in order to perform complete,
 system
> wide recovery. As some of you may realize, ARCHIVELOG mode must be enabled
> in order for this backup mechanism to run correctly. As a result, I opened
 a
> SVRMGR command window, and verified that ARCHIVELOG mode was *not* enabled
> by entering the command "Archive log list". According to the instructions
> provided by Computer Associates (vendor of ARCServe 2000), a series of
> commands must be entered in order to enable ARCHIVELOG mode. The ARCServe
> documentation recommended the following:
>
> (a) At the svrmgr prompt, type the following : "shutdown abort" (in order
 to
> shutdown the Oracle instance)
> (b) The user must now reconnect to Oracle using the internal account; once
> reconnected, type the following series of commands:
> "startup mount database"
> "alter database archivelog"
> "alter database open"
> " archive log start"
>
> Nevertheless, after having issued the "shutdown abort" command, I'm unable
> to startup the database. For example, when I type "startup mount <name of
> database>", I'm presented with an error message that states - ORA-00205
> error in identifying control file name. I checked some online resources,
 but
> could not find any helpful suggestions as to why this error was being
> generated. Any insight on this matter would be greatly appreciated, at
> present, I'm unable to start the database.
>
>
>
>
Received on Mon Jul 16 2001 - 21:14:15 CDT