rman backup, restore and apply incremental backup
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.
by the way, my database is 10g and 9i,
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.
Last edited by PAVB; 11-17-2009 at 02:59 PM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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.
I did cold incremental level 1 CUMULATIVE backup (database shutdown and start mount).
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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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.
What commands were used during recovery and restore of RMAN?
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.
Click Here to Expand Forum to Full Width