Re: init.ora file

Thank you very much for your help. I appreciate all of you sending me the advice.

It worked. I was certainly using spfile on my database but changing init.ora only. After correctly updated spfile, database backup and restore worked without any problems with archive log mode.

Thank you very much.
Hiroko

bentenkids_at_yahoo.com (hiroko) wrote in message news:<5265c4f2.0311260348.62fe396b_at_posting.google.com>...
> Hi, I am studying Oracle Database Administration.
>
> When I was setting automatic archivelog mode, I noticed I had trouble
> setting up init.ora file.
>
> I am using Oracle9 on Win2k.
>
> I modified init.ora file by adding;
> log_archive_start=true
> log_archive_dest=%Oracle%\admin\%SID%\arch
> log_archive_format=archorc_%s.log.
> Then, I shutdown, startup mount, alter database archivelog, alter
> database open.
> When I run alter system switch logfile for 3 times (I have 3 Redolog
> files), SQLPLUS hang.
> When I checked the book I had (OCP text book), it says this occurs
> when init.ora is not modified but alter database archivelog is run.
>
> So init.ora that was located on %Oracle%\admin\%SID%\spfile\ is not
> affecting database.
>
> Init.ora file for this database has a numeric extension like
> init.ora.10020039830 and so Window Explorer displayed file type as
> 10020039830.file (it wasn't read as Ora file.) I am not sure if this
> is the reason.
> Why this init.ora file has numeric extension? How can I make this
> file to be effective?
>
> Any helps or advices to solve this is appreciated.
>
> hiroko
Received on Tue Dec 02 2003 - 14:55:11 CST