Two question about creating archivelog files

From: Stefano Unternaehrer <stefano.unternaehrer_at_ti.ch>
Date: 2000/07/14
Message-ID: <396EE363.146512EA@ti.ch>#1/1

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

• 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

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 Fri Jul 14 2000 - 00:00:00 CDT