Re: Issue using SVRMGRL in Oracle 8i
Date: Tue, 17 Jul 2001 14:57:33 GMT
Message-ID: <xnY47.13233$l%.5089133_at_typhoon2.gnilink.net>
ORA-00205 -
Check that the proper control file name is referenced in the CONTROL_FILES
initialization parameter in the initialization parameter file and try again.
When using mirrored control files, that is, more than one control file is
referenced in the initialization parameter file, remove the control file
name listed in the message from the initialization parameter file and
restart the instance. If the message does not recur, remove the problem
control file from the initialization parameter file and create another copy
of the control file with a new file name in the initialization parameter
file.
(From Oracle Documentation)
Look in to init<SID>.ora file and uncomment or include these lines to use
the archiving feature or it has been enabled using ALTER DATABASE
ARCHIVELOG.
log_archive_start = true
log_archive_dest_1 = "location=D:\Oracle\oradata\<SID>\archive" # use the
proper OS syntax
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
"Joseph Ahmad" <jahmad2088_at_home.com> wrote in message
news:rfM47.493766$eK2.102194054_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 - 16:57:33 CEST