Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Archive Log File Format

    The "Log_Archive_Format" for my database is currently set to ARCH_%t%s.
    and the output file looks like ARCH_1_10021.
    I would like to see the date/Datetime/Timestamp also in the name of the Archive log file, something like ARCH_20040714084600_1_10021.

    Is it possible? If so then what should I do?

    Thanks!

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    The only parameters allowed within the filename itself are:

    %t %T %s %S

    This can't be changed because Oracle needs to know what the files are called (without having to second guess what the DBA has renamed them as).

    A possible option would be to copy the log file/s to another destination and then rename the copies, but I'm not sure how you could automate this process & get the correct date/timestamp applied to the file/s - anyone else got ideas on how to do this?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    Why do you want a timestamp of the file when you have the file created date each time a file is created? Same thing.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    I'm testing RMAN hot backup.. and seems like after a fresh restore, the RMAN backup overwrites the existing archive log backup, which were taken before the restore.

Posting Permissions

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