Re: problems restoring rman backup (RMAN-06026)
- From: Nick Keighley <nick_keighley_nospam@xxxxxxxxxxx>
- Date: Wed, 28 Nov 2007 01:57:22 -0800 (PST)
On 27 Nov, 23:46, joel garry <joel-ga...@xxxxxxxx> wrote:
On Nov 26, 5:42 am,Nick Keighley<nick_keighley_nos...@xxxxxxxxxxx>
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
***********************************************************************
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.
***********************************************************************
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;
38> }
39>
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 Keighley
.
- References:
- problems restoring rman backup (RMAN-06026)
- From: Nick Keighley
- Re: problems restoring rman backup (RMAN-06026)
- From: joel garry
- problems restoring rman backup (RMAN-06026)
- Prev by Date: Re: difficult design question
- Next by Date: Re: Conditional Trigger
- Previous by thread: Re: problems restoring rman backup (RMAN-06026)
- Next by thread: How to store emails with fulltext index
- Index(es):
Relevant Pages
|
|
