Re: problems restoring rman backup (RMAN-06026)

On Nov 26, 5:42 am, Nick Keighley <nick_keighley_nos..._at_hotmail.com> 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/