RE:Problem setting up ARCHIVELOG

The line
log_archive_dest = /u209/oraPROD/arch should read
log_archive_dest = /u209/oraPROD/arch/redo and the line
log_archive_format = redo_%S.arc
should read
log_archive_format = _%S.arc

This is because in log_archive_dest you specify the directory name and part of filename format.

Hope this helps...

> -----Original Message-----
> From: Josef Buergi [SMTP:nbuejo_at_halser.ascom.ch]
> Posted At: 06 March 1998 22:41
> Posted To: server
> Conversation: Problem setting up ARCHIVELOG
> Subject: Problem setting up ARCHIVELOG
>
> Hi
>
> I tried to set up ARCHIVELOG on my unix server (sparc20).
>
> So I did
>
> log_archive_dest = /u209/oraPROD/arch
> log_archive_format = redo_%S.arc
>
> in init.ora and startet the db up.
>
> But I got
>
> SQLDBA> Connected.
> SQLDBA> ORA-00256: error occurred in translating archive text string
> '/u209/oraPROD/arch'
> ORA-07287: soagdi: unsupported device for log archiving.
> QLDBA> SQL*DBA complete.
>
> I did not a mistake in spelling the directory or anything other !
>
> I'm frustrated AND IT'S round midnight .....
>
> So, if anybody can help I would by thankfull
>
> Joe
>
> Please mail to josef.buergi_at_ascom.ch
Received on Sat Mar 07 1998 - 00:00:00 CST