![]() ![]() In this case, you must go to a good backup of the controlfile. If you get a logical corruption (IE a bug in the software) with controlfiles multiplex, then you're still screwed because all controlfiles are physical copies of each other, so all controlfiles have the same corruption. In a disaster situation, where you lose the server and the storage is also lost, so you have to go to a backup and multiplexing saves you from what it is because the backup has only 1 copy of the controlfile and archivelogs. Multiplexing or not does not change your ability to use another server. So if the server dies (and the storage is still ok) and then transport the storage to another server and you are in business again. If you back up your recovery connects dialy then I don't know what exactly the redundant copies really are for/record you leave? However, if the server is a server database physical, with local storage (in which case files of database and the oracle software resides), no configuration of cluster if the server dies a sudden death, then what exactly are the newspapers redundant recovery and control of files will save you of? Is it to minimize the loss of data, or else (told you I wasn't a DBA or Oracle guru). CTL' scope = spfile Įxcuse my ignorance in this area (not oracle or a DBA), but from a risk perspective, I read his best practices for storing a redundant copy of recovery logs and control files on a separate disk / server - for redundancy. Use it like this:ĪLTER system set control_files='E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01. You actually use the incorrect syntax for alter system. So, what could be the reason? someone has an idea? When I copy control01 to 02, 03, I did stop the database, so there is no problem of incompatibility. ![]() SQL>Why it's happening? Just in case control02.ctl, control03.ctl are broken, I have manually copy the control01.ctl and rename it to control02.ctl and control03.ctl, but still does not. SQL> alter system set control_files='E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL' scope=spfile When only two of them are included in parameter ORA-00205: error in identifying control file, check alert log for more info TA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL' scope=spfile SQL> alter system set control_files='E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADA Then, I start to manipulate the parameter CONTROL_FILES and got below: -When all three controlfiles are included in parameter O/S-Error: (OS 123) he system cannot find the path specified.But I guarantee you that these files are there. ORA-00205: error in identifying control file, check alert log for more infoand when I look to the top of the alert.log, it shows: ORA-00202: control file: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL' When I try to mount the database, it always throws below error. Originally, my database was using the controlfile multiplexing configuration default and it worked perfectly fine. What is the problem with my controlfile multiplexing configuration? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |