DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN Backup set until time not working

  1. #1
    Join Date
    Jul 2005
    Posts
    45

    RMAN Backup set until time not working

    run
    {
    set until time 'Jul 27 2005 10:00:00';
    restore database;
    recover database;
    alter database open resetlogs;
    }

    I keep getting the error "a non-numeric character was found where a numeric was expected"

    My PROPS$ Table has Mon DD YYYY for the NLS_DATE_FORMAT
    My init file has *.nls_date_format='Mon DD YYYY'

    What is the correct way to set the date time when using the command
    set until time ?

    thanks.

  2. #2
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    Use to_date('Jul 27 2005 10:00:00','MMM DD YYYY HH24:MI:SS')

  3. #3
    Join Date
    Jul 2005
    Posts
    45
    That worked. I did not know that you could use to_date within rman.

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