Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question: RMAN - Getting closer...

Re: Question: RMAN - Getting closer...

From: Ronald Rood <devnull_at_ronr.nl>
Date: Fri, 2 Sep 2005 08:12:56 +0200
Message-ID: <0001HW.BF3DBA080038FC80F0305550@news.individual.net>


On Thu, 1 Sep 2005 21:48:40 +0200, BD wrote (in article <1125604120.151442.257580_at_g43g2000cwa.googlegroups.com>):

> 4) RMAN: run {allocate auxiliary channel dev1 type disk;sql "alter
> session set nls_date_format=''MM-DD-YYYY HH24:MI:SS''"; recover
> tablespace small_tables_2 until time '09-01-2005 09:45:01';}

You could also have specified
recover tablespace small_tables_2 until time "to_date('09-01-2005 09:45:01','MM-DD-YYYY HH24:MI:SS')"; With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Fri Sep 02 2005 - 01:12:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US