tag:blogger.com,1999:blog-2530682427657016426.post227523348798694322..comments2024-03-28T08:29:25.033+01:00Comments on Marko Sutic's Database Blog: Point in Time Recovery fails with ORA-01841 on Oracle 10.2 SEMarko Sutichttp://www.blogger.com/profile/08926232581329666732noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2530682427657016426.post-61477115683302313962019-04-15T15:22:15.002+02:002019-04-15T15:22:15.002+02:00Worked with 11.2.0.4
Thanks Worked with 11.2.0.4<br /><br />Thanks Marlon Costahttps://www.blogger.com/profile/10348615496442406714noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-89006579235022353892010-05-08T20:53:15.575+02:002010-05-08T20:53:15.575+02:00Thanks Damir ;)Thanks Damir ;)Marko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-77329929979916578842010-05-07T13:05:20.374+02:002010-05-07T13:05:20.374+02:00Nice topic-very handful!Nice topic-very handful!Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-38439736456392894062010-03-17T20:40:32.172+01:002010-03-17T20:40:32.172+01:00Encountered this same error, but had a stable envi...Encountered this same error, but had a stable environment (no recent changes) so I knew it was an actual date problem.<br /><br />With this query, this is how I found the problem.<br /><br /> SELECT SUBSTR (date_field, 8, 11) AS year_txt<br />, COUNT (*) AS cnt<br />from table<br />where to_char(date_field,'YYYY') = 0<br />or to_char(date_field,'YYYY') <= -4713<br />or to_char(date_field,'YYYY') >= 9999 <br />group by SUBSTR (date_field, 8, 11) <br /><br />Then I just found the row by searching the table with one of the where statements above based on the corrupted date data.Unknownhttps://www.blogger.com/profile/14798914792374693713noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-87448527961846314712009-12-23T15:51:45.810+01:002009-12-23T15:51:45.810+01:00Hi,
I don't use catalog for managing backups ...Hi,<br /><br />I don't use catalog for managing backups so I can't test this right now - but maybe later I will...<br /><br />For me it is important that I've seen this error and next time when I encounter it I will know what to do :)<br /><br />Enjoy,<br />MarkoMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-32467586372373304592009-12-23T14:46:48.619+01:002009-12-23T14:46:48.619+01:00Hi,
For sure I have to set NLS_LANG in 8.1.7 with...Hi,<br /><br />For sure I have to set NLS_LANG in 8.1.7 with catalog and for some operations in nocatalog mode.<br /><br />This same was for 9.0.x - I don't remember exactly versions and I was fixed in next releases. I assume <br />that for 9.2 should be OK but check it with catalog too if you have a chance. <br /><br />regards,<br />MarcinMarcin Przepiorowskihttps://www.blogger.com/profile/15133397892511680504noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-36249401955419361242009-12-23T14:17:10.624+01:002009-12-23T14:17:10.624+01:00Hi Marcin,
thanks for your comment. It is very in...Hi Marcin,<br /><br />thanks for your comment. It is very interesting that you had to set NLS_LANG to run RMAN in earlier versions :)<br /><br />I've tested this on Oracle 9.2.0.6 EE, which is the earliest version we have, and NLS_LANG can be empty.<br /><br />Maybe I should try with 9.2 SE :)Marko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-14424100742537394602009-12-23T13:08:32.586+01:002009-12-23T13:08:32.586+01:00Hi,
In times of Oracle 8i and early 9i
NLS_LANG h...Hi,<br /><br />In times of Oracle 8i and early 9i<br />NLS_LANG has to be set to american_america to make RMAN running ;)<br /><br />As I can see there is still some old hard coded date setting.Marcin Przepiorowskihttps://www.blogger.com/profile/15133397892511680504noreply@blogger.com