Archive logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Archive logs

  1. #1
    Join Date
    Oct 2001
    Posts
    9

    Archive logs

    I have copied a database running in archive log mode onto another server. When starting up the database and issuing the command alter system switch logfile I find that the owner of the logs is root. Will this cause me a problem later when users are logging into the database.

    Many Thanks
    Glen

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Don't know - what are the permissions on the log files? A UNIX-based Oracle-related account should be the owner of ALL your Oracle files. "root" is a privileged account in UNIX, just as sys/system/dba-enabled accounts are in Oracle. You need to fix the ownership of your Oracle files. If you don't know how, look up the following commands:

    chown
    chgrp
    chmod

  3. #3
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    No.. This will not "cause" a problem later when users log into the database as their actions in the database generate the archive logs but they have no access to the logs.

    However, Steven(Stecal) is absolutely correct. Root should NOT own the files, an "Oracle" user should own the files.

    Check the directory ownership where the logs are created. It sounds as if that directory is owned by root and has permissions where others can write to that directory...

    The "Norm" is:

    oracle:dba - 640 rw-r-----

    owner = oracle, group = dba
    Read write by oracle, read by the dba group, and nothing for others...
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Again, based on what you provided, the answer is "don't know" - what if the permissions are 644 for root? Oracle can read, but not write. Did alter system switch logfile work or not? If the Oracle owner can write to the files, then ownership isn't necessarily a show stopper.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width