![]() From the command prompt issue the following replacing client_server with the netbackup NB_ORA_CLIENT value. Step-By-Step Identifing the Controlfile Backups in Netbackupġ. The following guide shows how the control file can be recovered from Netbackup using RMAN when no local copy of the control file is available. Now if the entire SAN gets corrupted or the ASM disks are lost, the control file backup can be recovered from tape using RMAN and Netbackup. One such backup tool is Netbackup which can be used in conjunction with RMAN to redirect or duplex auto control file backups to tape in addition to or instead of disk. However, what happens if the SAN has been lost in its entirety and there is no backup of the control file on disk? Or where the control file is stored in ASM and the ASM disks have been lost?Īt many sites, the control file backup is backed up to tape using backup software. Furthermore, the control file backup is simply a copy of the controlfile and as such, can be manipulated using OS commands. This allows DBAs to get access to the control file outside of the standard RMAN backups. This ensures that whenever any backups are taken an automatic and independent backup of the controlfile is also taken to a predefined location, normally a file system. Part of the solution to this problem is making sure auto control file backups are switched on. Therefore, when not using an RMAN catalog it is important that particular attention is taken in regards to control file backups. A "chicken and egg" situation can occur where you need to restore the control file, but to find out where the control file backups are you need the control file. Given the control file makes up part of the database that is being restored and it is in itself stored in the backup, it can become difficult to restore the database especially if the control file is one of the files that has been lost. However, if an RMAN catalog is not used, then any recovery of the database will be reliant on the backup records stored within the control file. RMAN backup records are stored in the RMAN catalog and the control file. To Recover the spfile or controlfile BACKGROUND ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |