about rman, recovery and date format

From: Remigiusz Sokolowski <rems_at_wp-sa.pl>
Date: Thu, 22 Nov 2007 09:31:09 +0100
Message-id: <47453E4D.2080205@wp-sa.pl>

lastly I've had to recover one of databases. I use script below

run {
allocate channel d1 device type disk format '<path>/%d/%d_%T_%U.bkp' sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''"; set until time '2007-11-20 23:00:00';
restore database;
recover database;
}

During recover operation I 've got error

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

The solution was to delete lines 3 and 4 (i.e. not to set date format) - as in this I have could done because proper time was not so important and I have operated on chosen fraction of archivelogs.

Any thoughts what is wrong?

TIA
Remigiusz

Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy

lub juz pracujemy nad jej uruchomieniem 2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora

i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa Wirtualna Polska S.A.

WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216; Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)
--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 22 2007 - 02:31:09 CST