Database Backup and Recovery (MOSC)

MOSC Banner

RMAN: better timing information in logfile (Unix)

BrunoVroman
BrunoVroman Posts: 3,950 Gold Crown
edited Jan 6, 2010 3:50AM in Database Backup and Recovery (MOSC) 4 comments

Comments

  • DaveDrake
    DaveDrake Posts: 367 Silver Badge
     Bruno,
    Thanks, this is an excellent tip!

    Dave.
  • BrunoVroman
    BrunoVroman Posts: 3,950 Gold Crown
     Bruno,
    Thanks, this is an excellent tip!

    Dave.
    Thank you for the feedback.

    In fact, "long time ago", I was used to the "poor" format "DD-MON-YY", thinking "not very useful, but this is how RMAN has been developed, I must live with it"; then, one day I realized that I had different formats on two different servers... After some investigation I realized that we could specify the format => great!

    Best regards,

    Bruno.

  • Manoj Sam
    Manoj Sam Posts: 1,787 Silver Trophy
    Thank you for the feedback.

    In fact, "long time ago", I was used to the "poor" format "DD-MON-YY", thinking "not very useful, but this is how RMAN has been developed, I must live with it"; then, one day I realized that I had different formats on two different servers... After some investigation I realized that we could specify the format => great!

    Best regards,

    Bruno.

    Hi,

    Such format is used for 'UNTIL TIME' operations as well.

    Regards,

    Sam. 

  • BrunoVroman
    BrunoVroman Posts: 3,950 Gold Crown
    Hi,

    Such format is used for 'UNTIL TIME' operations as well.

    Regards,

    Sam. 

    Hi Sam,

    for "UNTIL TIME" I prefer to use an explicit format, so I use things like "TO_DATE( '14-FEB-2010 15:00', 'DD-MON-YYYY HH24:MI' )"

    Best regards,

    Bruno.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center