DBAsupport.com Forums - Powered by vBulletin
Page 4 of 7 FirstFirst ... 23456 ... LastLast
Results 31 to 40 of 61

Thread: RMAN backup

  1. #31
    Join Date
    Jan 2000
    Posts
    387
    Hi

    Please refer to my posting number 23. I did tried to mount it before the command but I am still encountering errors... any advices please? Thanks!

  2. #32
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Mooks

    I think there is something wrong with the date format set untli that part.thats why it ddi not mount.

    can you please change the date part to

    to_date('06-jul-2005 16:50:00','dd-mon-yyyy hh24:mi:ss')

    regards
    Hrishy
    Last edited by hrishy; 07-08-2005 at 05:08 AM.

  3. #33
    Join Date
    Jan 2000
    Posts
    387
    Hi

    It is still the same error with the change of the date format ... :( Have you tested it out and is it ok?

  4. #34
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Quote Originally Posted by hrishy
    Hi Mooks

    I think there is something wrong with the date format set untli that part.thats why it ddi not mount.

    can you please change the date part to

    to_date('06-jul-2005 16:50:00','dd-mon-yyyy hh24:mi:ss')

    regards
    Hrishy
    There was a bug (at least in 8.1.7 under Windoze) that prevented using to_date in the "set until" statement. I was obliged to set NLS_DATE_FORMAT in the environment and put the date as a string in the "set until". (Sorry, no refs, I'm on a desert island at the moment).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  5. #35
    Join Date
    Jan 2000
    Posts
    387
    I am executing the code in a linux machine and it is running oracle 9.2.0.4....

    Extracted from metalink:

    Specifying Dates in RMAN Commands

    -----------------------------------

    When specifying dates in RMAN commands, the date string can be either:

    1) A literal string whose format matches the NLS_DATE_FORMAT setting.

    2) A SQL expression of type DATE, for example, 'SYSDATE-10' or
    "TO_DATE('01/30/1997', 'MM/DD/YYYY')".

    Note that the second example includes its own date format mask and so is independent of the current NLS_DATE_FORMAT setting.
    Last edited by mooks; 07-08-2005 at 05:53 AM.

  6. #36
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Mooks

    Sorry i dont have a oracle database with me now :-)

    Can you please try this instead of the earlier command

    SET UNTIL TIME 'Jul 06 2005 16:50:00'


    regards
    Hrishy

  7. #37
    Join Date
    Jan 2000
    Posts
    387
    Nope... Still not working :( Same error that the db has to be mounted.

  8. #38
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Hi Mooks,

    Yes, that's what the doc said - but it didn't actually work. (Or I was too stupid to get it to work.) But I'm fairly sure that I saw a note somewhere saying to_date didn't do the trick.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  9. #39
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Mooks

    I hope you are using these lines in your code

    restore controlfile to /tmp/control01.ctl;
    restore controlfile from /tmp/control01.ctl ;

    instead restoring the controlfile from autobackup.

    Just wundering do the controlfiles get restored atleast ? at /tmp location ?

    I hope your SID env is correct ?

    regards
    Hrishy
    Last edited by hrishy; 07-08-2005 at 06:10 AM.

  10. #40
    Join Date
    Jan 2000
    Posts
    387
    Nothing was restored as the execution codes were struck at the SET TIME format...

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