Re: Issues when using SVRMGRL

Hi Joseph,

Follow these steps:

1.From the server manager prompt, do
SVRMGR> startup nomount
SVRMGR>show parameter control_files

This will give you the path of your control file(s) at the operating system level.Go to those directories and make sure the files are really there. if you have only one in the list and that is not present at the operating system level, that's a whole new thread to this group, since you will have to recreate the controlfile. If there are two or more files listed in the list, and one of them is intact, remove references to the missing files from your init.ora file. Do a search to find this init parameter file, but it is generally located in D:\oracle\admin\prod\pfile directory, assuming that Oracle binaries (ORACLE_HOME) was installed on the D drive, you did a default install and your instance name is prod. Delete the full paths of the missing files from the control_files parameter in the init.ora file and try the startup mount command.

Murali Sreedhar

"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 Tue Jul 17 2001 - 17:08:17 CDT