Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Error!!! Help!!! for Oracle 7.3.4 in Solaris2.7

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

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 25 Jun 2001 19:33:39 -0700
Message-ID: <93f65984.0106251833.3506ec5b@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tj5h1oovh8rh4f_at_beta-news.demon.nl>...
> "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

Thanks Sybrand,
How to copy archived log files to tpae? Everytime archived log files copy to tape, it 's cleaned automatically? please clarify. Thanks a lot.

JK Yao
Jr. DBA, ModusMedia International Inc.
ICQ:18658328 Received on Mon Jun 25 2001 - 21:33:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US