Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: rman nocatalog - point in time recovery

Re: rman nocatalog - point in time recovery

From: Mladen Gogala <>
Date: Tue, 13 Jul 2004 17:00:36 -0400
Message-ID: <>

On 07/13/2004 04:43:59 PM, "Schauss, Peter" wrote:
> This may not be the cleanest solution, but it worked:

> - I want to restore the database to the state it was in at 10:45 am by applying
> the redo logs through number 1234.
> I restore my control files by copying them to the appropriate directories on
> the disk (e.g. /ora1/oradata/sid/control01.ctl ... /ora2/... /ora3/...).
> I run the following commands in rman
> run {
> set until logseq=1234 thread=1;
> allocate channel ch1 type disk;
> allocate channel ch2 type disk;
> allocate channel ch3 type disk;
> restore database;
> recover database;
> alter database open resetlogs;
> }
> Oracle says:
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: set
> RMAN-06003: ORACLE error from target database: RMAN-20206: log sequence not
> found in the recovery catalog

restore database;
recover database until to_date('12244096 23:59:59','MMDDYYYY HH24:MI:SS') using backup controlfile; alter database open resetlogs;
hasta la vista dba;

Why would you ever want to go into sqlplus?

Mladen Gogala
Oracle DBA
Wang Trading LLC
Tel: (203) 956-6826

This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Tue Jul 13 2004 - 15:57:52 CDT

Original text of this message