There is a metalink note 283630.1 about CONTROLFILE AUTOBACKUP TAKEN
AFTER EACH RESETLOGS
This concerns versions 9.0.1.4 to 10.1.0.4
Perhaps you've performed this scenario ?
Hans
-----Original Message-----
From: Joel
[mailto:oracledba-ezmlmshield-x51985838.[Email address protected]
Sent: dinsdag 3 april 2007 21:39
To: LazyDBA Discussion
Subject: RE: RMAN restore
I did a restore controlfile from <filename> (using my auto backup
'snap...f')
My problem is this error? Don't know why it is asking me this? I
should have a good backup.
sql statement: alter database mount
Starting restore at 03-APR-07
released channel: d1
released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/03/2007 15:35:49
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546
9>
10> run {
11> allocate channel d1 type disk;
12> allocate channel d2 type disk;
13> sql "alter database mount";
14> restore database;
15> recover database;
16> release channel d1;
17> release channel d2;
18> }
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
Oracle LazyDBA home page