Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_DATE_FORMAT in RMAN

VPSOct 28 2007 — edited Oct 28 2007
Friends,

OS: RHEL AS 3.0
DB: 9iR2

i checked the nls date parameter in sqlplus as sysdba. it shows the below output
sql> show parameter nls_date_format
DD-MON-YYYY

i checked the date format in rman by
rman>list backup;
all the date part of this output is showing the date format as dd-mon-yy

how come the rman is not taking the parameter's nls_date_format?
when i execute the below command in rman..

rman>RUN
{
SET UNTIL TIME 'Oct 27 2007 09:00:00';
RESTORE DATABASE;
RECOVER DATABASE;
}

it throws ORA-01858 error.

what should i do?
can i....

export NLS_DATE_FORMAT="DD-MM-YYYY HH24:Mi:SS"
then run

rman>RUN
{
SET UNTIL TIME '27-Oct-2007 09:00:00';
RESTORE DATABASE;
RECOVER DATABASE;
}


thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2007
Added on Oct 28 2007
4 comments
1,450 views