| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: problems restoring rman backup (RMAN-06026)
On 27 Nov, 23:46, joel garry <joel-ga..._at_home.com> wrote:
> On Nov 26, 5:42 am,Nick Keighley<nick_keighley_nos..._at_hotmail.com>
> wrote:
> > We are having problems restoring rman backups. Sometimes. If a single
> > backup is made then restored it works. Subsequent (or possibly just
> > older ones) fail.
>
> > We get an RMAN-06026 "some targets not found"
>
> > I've done an RMAN "list backupset" and, if I'm correctly interpreting
> > the output all the missing files are of the form EVENTn.DBF. Not all
> > the files fail just the older one (I've only got one example so far
> > so this isn't definite).
>
> > The rman command looks like this
>
> > RMAN> run { set until scn 545992;
> > 2> allocate channel ch1 type disk;
> > 3> allocate channel ch2 type disk;
> > 4> allocate channel ch3 type disk;
> > 5> restore database check readonly;
> > 6> recover database check readonly, delete archivelog;
> > 7> sql "alter database open resetlogs";
> > 8> }
> > 9> exit;
>
> > the restore fails.
thanks for responding!
> Probably need more information to figure this out.
I thought that might be the initial answer, but I wasn't sure what
would
be useful.
> Version to four digits,
it's a legacy system using a pretty old verion of Oracle
8.1.7.0.0
> platform,
Windows XP, Windows 2000
> other errors in the error stack,
this is the rman log from the restore
RMAN-06005: connected to target database: TETRA (DBID=531252930) RMAN-06009: using target database controlfile instead of recovery catalog
RMAN> run { set until scn 545992;
2> allocate channel ch1 type disk;
3> allocate channel ch2 type disk;
4> allocate channel ch3 type disk;
5> restore database check readonly;
6> recover database check readonly, delete archivelog;
7> sql "alter database open resetlogs";
8> }
9> exit;
RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch1 RMAN-08500: channel ch1: sid=10 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate
RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: ch3 RMAN-08500: channel ch3: sid=12 devtype=DISK
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: ch2 RMAN-08031: released channel: ch3 RMAN-08031: released channel: ch1 RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03002: failure during compilation of command RMAN-03013: command type: IRESTORE RMAN-06026: some targets not found - aborting restore RMAN-06023: no backup or copy of datafile 27 found to restore RMAN-06023: no backup or copy of datafile 26 found to restore RMAN-06023: no backup or copy of datafile 25 found to restore RMAN-06023: no backup or copy of datafile 24 found to restore RMAN-06023: no backup or copy of datafile 23 found to restore RMAN-06023: no backup or copy of datafile 22 found to restore RMAN-06023: no backup or copy of datafile 21 found to restore RMAN-06023: no backup or copy of datafile 20 found to restore RMAN-06023: no backup or copy of datafile 19 found to restore
Recovery Manager complete.
> what you are restoring,
? the database?
> original backup command.
some comments have been trimmed and directory structure elided
RMAN>
16> run {
17> allocate channel d1 type disk;
18> backup
19> format 'E:\NMS\BACKUP/database/full_%t_s%s_s%p'
20> database;
24> sql 'alter system archive log current';
26> backup archivelog all format 'xxxx/archiveLogs/arch_%t_s%s_s
%p'
29> delete input;
30> release channel d1;
31> }
32>
33> run {
34> allocate channel d1 type disk;
35> copy
36> current controlfile to 'xxxx/control_2007_11_28_09_35.ctl';
37> release channel d1;
> For example, you could be hitting
> a known read-only tablespace bug if you are on 8 or 9iR1 and are
> trying to restore a read-only tablespace.
we were beginning to suspect it might be something to do with readonly tablespaces. There are known bugs?!
> I'm also wondering if you
> are doing something else you are not mentioning.
highly likely. We arn't using a catalog and the control files appear to be restored by copying the file, not via rman.
Some Oracle docuemntation seems to imply I don't need to do a restore if I'm doing recover immediatly afterwards.
-- Nick KeighleyReceived on Wed Nov 28 2007 - 03:57:22 CST
 |
 |