Hi,

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.


--
Nick Keighley

On Nov 26, 5:42 am, Nick Keighley <nick_keighley_nos... (AT) hotmail (DOT) com>
wrote:
Probably need more information to figure this out. Version to four
digits, platform, other errors in the error stack, what you are
restoring, original backup command. 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. I'm also wondering if you
are doing something else you are not mentioning.

jg
--
@home.com is bogus.
If at first you don't succeed, try a brisk swim. http://www.msnbc.msn.com/id/21935099/

On 27 Nov, 23:46, joel garry <joel-ga... (AT) home (DOT) com> wrote:
thanks for responding!


I thought that might be the initial answer, but I wasn't sure what
would
be useful.


it's a legacy system using a pretty old verion of Oracle

8.1.7.0.0

Windows XP, Windows 2000

this is the rman log from the restore

************************************************** *********************
Recovery Manager: Release 8.1.7.0.0 - Production

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: set

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-08030: allocated channel: ch2
RMAN-08500: channel ch2: sid=11 devtype=DISK

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-00571:
================================================== =========
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.
************************************************** *********************


? the database?

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;
38> }
39>


we were beginning to suspect it might be something to do with
readonly tablespaces. There are known bugs?!

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 Keighley