Re: Two question about creating archivelog files

I think the owner of the archive log files is the owner (read "creator") of the database. The owner of the current Oracle processes is the account that started up the instance/database and they aren't, necessarily, one and the same. When I query ownership of the archive logs mine show "oracle:dba", the creator and the processes are owned by "oper2:dba" the account that restarts the db in the middle of the night after an automated cold backup.

HTH "Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3971141b$1_at_news.iprimus.com.au...
>
> "Stefano Unternaehrer" <stefano.unternaehrer_at_ti.ch> wrote in message
> news:396EE363.146512EA_at_ti.ch...
> >
> > Hello guys!
> > I'm testing the ARCHIVELOG faeture, and have 2 questions:
> >
> > - why the archlog files created with svrmgrl are owned by a
> > different user? Here are the details:
> >
> > unix> id
> > uid=301(oracle) gid=30(dba)
> > unix> ll `which svrmgrl`
> > -rwxr-xr-x oracle dba $ORACLE_HOME/bin/svrmgrl
> >
> > svrmgr> archive log list
> > Database log mode Archive Mode
> > Automatic archival Enabled
> > Archive destination /usr/virtua/clas99/arch
> > Oldest online log sequence 84
> > Next log sequence to archive 86
> > Current log sequence 86
> > svrmgr> alter system archive log current;
> >
> > unix> ll -ld /usr/virtua/clas99/arch
> > drwxrwxr-x oracle dba /usr/virtua/clas99/arch
> > unix> ll /usr/virtua/clas99/arch
> > -rw-r----- dbadmin dba arch_0000000086.arc
> >
> > #############^^^^^^^#### WHY dbadmin ???????????????????????
> >
> > unix> ps -ef |grep ora_
> > oracle 1079 1 0 10:47:22 ? 0:00 ora_lgwr_vtls99
> > oracle 1077 1 0 10:47:22 ? 0:00 ora_arch_vtls99
> > oracle 1083 1 0 10:47:22 ? 0:00 ora_smon_vtls99
> > oracle 1075 1 0 10:47:22 ? 0:01 ora_dbwr_vtls99
> > oracle 1081 1 0 10:47:22 ? 0:00 ora_ckpt_vtls99
> > oracle 1073 1 0 10:47:22 ? 0:00 ora_pmon_vtls99
> >
>
> This is deep Unix territory for me, but I would imagine it has something
 to
> do with the fact that it is actually the ARCH background process that is
> writing out the files.
>
> >
> > - how to change the 'upper bound'(?) in order to have just 5
> > digits in the archlog file name, as for example arch_00086.arc ?
> > This is what I have about archivelog in the initSID.ora file:
> >
> > log_archive_start = true
> > log_archive_dest = /usr/virtua/clas99/arch
> > log_archive_format = arch_%S.arc
> >
>
> I don't believe that it is possible to alter the numbering scheme in the
 way
> you require. Lowercase '%s' gives you just the log sequence number;
> uppercase '%S' gives you the sequence number with leading zeroes, and it's
 a
> ten digit number. I know of no other variables that can be used to give
 you
> different options, nor a way of changing %S's default behaviour.
>
> Sorry,
> HJR
>
>
>
>
>
> > Thank you for your help!
> > Best regards,
> > Stefano
> >
> >
> > HP-UX B.11.00 U 9000/800 - Oracle7 Server Release 7.3.4.1.0
> > ______________________________________________________________________
> > Stefano Unternaehrer Informatico Sbt - DBA/SysAdmin
> > Sistema bibliotecario ticinese c/o Biblioteca Cantonale Bellinzona
> > Viale Stefano Franscini 30a 6501 Bellinzona Ticino Switzerland
> > voice +41 (0)91 814 15 13 paper +41 (0)91 814 15 09
> > mailto:stefano.unternaehrer@ti.ch homepage: http://www.sbt.ti.ch/
> >
> > --
> > Posted from dalia.ti.ch [193.246.181.29]
> > via Mailgate.ORG Server - http://www.Mailgate.ORG
>
>
Received on Wed Jul 19 2000 - 00:00:00 CDT