rman backup, restore and apply incremental backup

[xyz2000]

Hi,

I have to move database from one server to another, I used rman backup/restore and apply log first. Later, I found out there are a lot of tables are no logging. So apply log result database have corrupted blockes.

So I have to use incremental level 0 backup and incremental level 1 backup.

But I have some problem to do that.

1. if I start restore after incremental level 1 backup completed. restore/recover is fine.

2. In my case, restore takes too long for production to shutdown. I need to restore before incremental backup started.

During restore, datafile is renamed (from data file to ASM file).

So after I completed restore of level 0 backup, control file can not recognize newly created incremental backup (this backup is created after control file restored on target server). So I did catalog to catalog this backup piece and archivelog piece after incremental backup. After that, I start recover database. It apply incrememtal backup. then ask for archivelog. but archive log sequence is after level 0 backup, not after incremental level 1 backup .

3. So I will do another testing to see if I can shutdown database before incremental backup (do a cold incremental backup), this way after apply incremental backup, without apply log, I should be able to open database resetlogs without apply logs. I don't/can't apply logs any way because database data corruption problem.

Any one have any idea what should I do to apply incrememtal backup after restored level 0 backup?

Keep in mind, oracle 9i did not allow catalog backup piece.

Thank in advance.

xyz2000

[xyz2000]

by the way, my database is 10g and 9i,

[PAVB]

I would put all tables/indexes in logging mode then take level 0

After you complete migration you can always re-set offending tables/indexes to nologging mode.

[xyz2000]

There are several operations like sql load (by pass redo log) may also result in data block corruption when apply log. So I not only need to put all tables in logging, I may also have to stop those sql load operation, which I am not sure I can stop that.. It is part of production operation.

[xyz2000]

I did cold incremental level 1 CUMULATIVE backup (database shutdown and start mount).
then recover

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup

released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/17/2009 15:57:43
RMAN-06054: media recovery requesting unknown log: thread 1 seq 12107 lowscn 1668718033

alter database open resetlog failed.

Here, it ask for log after level 0 backup before level 1 backup.


eventhogh level 1 is cold backup, recover already applied level 1 backup, it still ask for old log.. and database can not open resetlogs.

[giteshtrivedi]

What commands were used during recovery and restore of RMAN?

[xyz2000]

rman command is restore database and recover database.

If filename did not change during restore, after restore level 0 backup, I can restore controlfile again (control file after incremental backup), then recover database. This works fine

But during restore, data file changed to new name (from datafile to ASM file). So I think if I restore controlfile again. I need to rename datafile again. That will be very messy with several hundrend files.