Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!v26g2000prm.googlegroups.com!not-for-mail
From: "fitzjarrell@cox.net" <oratune@msn.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Recovery fails with 06053 and 06025
Date: Fri, 18 Jul 2008 07:33:21 -0700 (PDT)
Organization: http://groups.google.com
Lines: 86
Message-ID: <46279ec8-5083-4ede-b058-367f20a582c5@v26g2000prm.googlegroups.com>
References: <a17cbf84-77aa-4f89-bb4f-9d5d92893b44@z72g2000hsb.googlegroups.com>
NNTP-Posting-Host: 138.32.32.166
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1216391601 5471 127.0.0.1 (18 Jul 2008 14:33:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 18 Jul 2008 14:33:21 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v26g2000prm.googlegroups.com; posting-host=138.32.32.166; 
 posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ;  Embedded Web 
 Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 
 2.0.50727),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.misc:253260
X-Received-Date: Fri, 18 Jul 2008 10:33:21 EDT (text.usenetserver.com)

On Jul 17, 12:29 am, Kake <Kake....@gmail.com> wrote:
> Hello,
>
> First of all I have no experience on Oracle. I'm simple programmer
> with task out of my skills.
>
> I was given task to restore database to a new location with few simple
> commands.
>
> First I take full backup of the database with RMAN
>
>  BACKUP INCREMENTAL LEVEL 0 DATABASE FILESPERSET 4;
>  DELETE OBSOLETE;
>
> Then I do restore to another location.
>
> I connect the target and so
>
> Then I restore controlfile from autobackup maxdays=10;
> Everything goes fine I mount the database,
>
> Then I use restore database;
> That goes fine.
>
> After that all goes wrong.
>
> I tried to do
>
> RMAN> recover database delete archivelog;
>
> KΣynnistetΣΣn recover, 16.07.2008
> kΣyt÷ssΣ on kanava ORA_DISK_1
>
> kΣynnistetΣΣn vΣlinepalautuminen
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-00579: the following error occurred at 07/16/2008 20:29:31
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: recover
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: recover(4)
> RMAN-06053: unable to perform media recovery because of missing log
> RMAN-06025: no backup of log thread 1 seq 453183 scn 4864997667 found
> to restore
>
> RMAN-06025: no backup of log thread 1 seq 453182 scn 4864993160 found
> to restore
>
> RMAN-06025: no backup of log thread 1 seq 453181 scn 4864988601 found
> to restore
>
> RMAN-06025: no backup of log thread 1 seq 453180 scn 4864985052 found
> to restore
>
> ...
>
> Okay so I understand I'm missing something. I tried to do recovery
> until the time last full backup was taken no help. Then I tried to do
> until last sequence i found from List backup. I always keep getting
> the same errors.
>
> Finaly I tried to do following
>
> SQL> recover database using backup controlfile until cancel;
>
> No it says that it's missing following redolog REDOLOGS\AAS_356807.ARC
> and change 4078425941 made in 11/28/2007 13:40:26  thread 1 sequence
> 356807
>
> Of course such REDOLOG can't be found. Or I have no idea where to find
> it.
>
> I have no idea how to get pass this problem. Any ideas?
>
> I don't even have access to metalink ;(

You DID copy the complete backupset to the destination machine before
you started working?


David Fitzjarrell