Re: Two question about creating archivelog files

"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 Sun Jul 16 2000 - 00:00:00 CDT