![]() RESTORE CONTROLFILE to '\tem.ctl' FROM AUTOBACKUP Įxecuting command: SET CONTROLFILE AUTOBACKUP FORMATĬhannel ORA_DISK_1: looking for autobackup on day: 20040420Ĭhannel ORA_DISK_1: autobackup found: \c-1821778886-20040420-07Ĭhannel ORA_DISK_1: controlfile restore from autobackup completeįinished restore at 20-APR-04 Solution Sign In SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\%F' This is because the rman searched the autobackup by day and not by time. With following rman script,then rman will extract controlfile from "C-1821778886-20040420-07" In the above example if we try to extract controlfile from backup piece " C-1821778886-20040420-06 " ![]() We have many backuppieces created for controfile autobackup for a particular day. Once we enable the controlfile autoback feature, the autobackup pieces are created once we make any changes to the database structure or any backup of datfiles using RMAN ![]() Information in this document applies to any platform. Oracle Database - Enterprise Edition - Version 9.2.0.1 and later How To Restore Controlfile From Particular Backupiece Out Of Many Backuppieces Created By Autobackup In A Single Day
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |