RMAN backup

[mooks]

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!

[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

[mooks]

Hi

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

[DaPi]

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).

[mooks]

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.

[hrishy]

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

[mooks]

Nope... Still not working :( Same error that the db has to be mounted.

[DaPi]

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.

[hrishy]

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

[mooks]

Nothing was restored as the execution codes were struck at the SET TIME format...