Re: problems restoring rman backup (RMAN-06026)

On Nov 26, 5:42 am, Nick Keighley <nick_keighley_nos...@xxxxxxxxxxx>
wrote:
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

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/
.

Relevant Pages

  • Re: rman
    ... RMAN configuration parameters are: ... CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; ... channel ORA_DISK_1: restoring controlfile ...
    (comp.databases.oracle.server)
  • Re: RMAN Duplicate Question
    ... comes to restoring, there are several conditions which affect how and if you can perform the restore you want. ... the backup pieces must reside on the same host as ... the the auxiliary database. ... as soon as I understood the process behind the scenes RMAN became pretty easy in my book. ...
    (comp.databases.oracle.server)
  • problems restoring rman backup (RMAN-06026)
    ... We are having problems restoring rman backups. ... files fail ...
    (comp.databases.oracle.misc)
  • Re: backing-up with rman and expdump
    ... I do not see any difference between restoring db from full rman ... The difference is you are not "restoring a database " with expdmp, ... also checks for block corruption during backup. ...
    (comp.databases.oracle.server)
  • Re: backing-up with rman and expdump
    ... I do not see any difference between restoring db from full rman ... expdmp is a logical backup. ...
    (comp.databases.oracle.server)