Re: Archive Error!!! Help!!! for Oracle 7.3.4 in Solaris2.7

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0106211935.6d79be45_at_posting.google.com...
> When I change our company's database mode from nonarchive to archive.
> However, when I shutdown database and startup. It showing following
> errors. Any thought? By the way, If the HD doesn't have enough space
> after I change the mode, any way to solve this problem, such as set
> smaller archive log file or clean those log file more frequently?
> Help plz.
>
> Thanks a lot.
> JK Yao
> DBA, ModusMedia International Inc.
> ICQ:18658328
>
> ----------------------------------
>
>
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 249981388 bytes
> Fixed Size 39816 bytes
> Variable Size 203738692 bytes
> Database Buffers 40960000 bytes
> Redo Buffers 5242880 bytes
> Database mounted.
> ORA-00255: error archiving log 4 of thread 1, sequence # 177
> ORA-00312: online log 4 thread 1: '/data1/POWER6/logPOWER607.ora'
> ORA-00312: online log 4 thread 1: '/data1/POWER6/logPOWER608.ora'
> ORA-00270: error creating archive log
> ORA-00334: archived log: '/oracle/product/7.3.4/dbs/arch/1_177.dbf'
> ORA-07352: sfccf: create error, unable to create file.
> SVR4 Error: 13: Permission denied

> SVR4 Error: 13: Permission denied

You don't have permission on O/S level to create files in that directory. You aren't running the database under root, are you? If the disk has insufficient space, either clean up the disk, or make sure the archived log files are copied to tape frequently, otherwise running in archivelog mode is useless.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jun 21 2001 - 23:08:28 CDT