Spfile with wrong parameters (urgent)

[miltonbastos]

Environment information:
* Oracle version: 10.2
* Operating system: Windows XP Professional


Good morning!

I made a bullshit here and I can not climb my instance.
Good, as my base was not in Archivelog mode, I gave the commands below to leave in Archive mode:

Select all

 
alter system set log_archive_dest_1='location=D:\oradata\archives' scope=spfile;  
alter system set log_archive_start=true scope=spfile;  
shutdown immediate; 
startup mount; 
alter database archivelog; 
alter database open;

Good, the Principle worked, however, to give startup he gave WARNING

Select all

"obsolete and/or deprecated parameter(s) specified".

I thought it was because of the log_archive_dest_1, so I decided to give the command below to see if it solved:

Select all

alter system set log_archive_dest='location=D:\oradata\archives' scope=spfile;  

]

That is, so set both log_archive_dest and log_archive_dest_1.

Now the instance does not rise, and gives this error:

Select all

SQL> startup mount; 
ORA-32004: obsolete and/or deprecated parameter(s) specified 
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated 
ORA-09291: sksachk: invalid device specified for archive destination 
OSD-04018: N┐o foi poss┐vel acessar o diret┐rio ou dispositivo especificado. 
O/S-Error: (OS 123) A sintaxe do nome do arquivo, pasta ou nome do volume est┐ incorreta. 

I do not have init.ora, only spfile , and how instance does not rise, I can not fix it. What do I do?

[diegolenhardt]

face

Take this location of the command

does so:

Select all

alter system set log_archive_dest='D:\oradata\archives' scope=spfile;

[miltonbastos]

Without the location the command did not work ...

Now I can no longer give any command, because the instance does not rise !!

[ecalvetti]

Milton, do not you have the pfile ???

If you rise the instance using Pfile .. and then generates the spfile again, from it.

Select all

startup PFILE=caminho\init.ora

Generally the INI.ORA uses the name of the instance. Ex: initABC.ora

[miltonbastos]

I do not have Calvetti, I wrote this in the last line of my post ...
of course, if it would be easy.

I will try to make a gambiarra now, if it works I warn you here.

[miltonbastos]

My gambiarra worked ...

I picked up the spfile, opened with WordPad, I copied the part in "text" that I was interested in, I threw another new file and used as Pfile.
worked!

Thanks to those who tried to help !!