Prev: Oracle help
Next: paypal wholesale men jordans 18 (paypal accept)(www goodsaler com
From: Kake on 17 Jul 2008 01:29
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$B&2(Bynnistet$B&2&2(Bn recover, 16.07.2008
k$B&2(Byt$B!`(Bss$B&2(B on kanava ORA_DISK_1



k$B&2(Bynnistet$B&2&2(Bn v$B&2(Blinepalautuminen

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 ;(



From: fitzjarrell on 18 Jul 2008 10:33
On Jul 17, 12:29 am, Kake <Kake....(a)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$B&2(Bynnistet$B&2&2(Bn recover, 16.07.2008
> k$B&2(Byt$B!`(Bss$B&2(B on kanava ORA_DISK_1
>
> k$B&2(Bynnistet$B&2&2(Bn v$B&2(Blinepalautuminen
>
> 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
From: Kake on 23 Jul 2008 13:29

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

It's complete. I did new Full backup from the old database and
restored/recover from same location.
I disabled the archivelog during this operation so the backup should
be ok.

 | 
Pages: 1
Prev: Oracle help
Next: paypal wholesale men jordans 18 (paypal accept)(www goodsaler com