-
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!
-
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.
-
Hi
It is still the same error with the change of the date format ... :( Have you tested it out and is it ok?
-
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
-
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.
-
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
-
Nope... Still not working :( Same error that the db has to be mounted.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|