Ticket #1797977

Hi Adam, Here is a summary of the current situation: * All hard drives on the VDB server were replaced, and the system was restored from a previous full backup. * At this point, Oracle is not able to start due to a mismatch between the control file and the data files. * We have spent significant time attempting recovery, but have not been able to successfully restore the Oracle database. At this stage, we see two possible options: Option 1 – Engage Japan team for recovery * We can involve our Japan team to further analyze and attempt recovery of the database. * This will require providing TeamViewer access so they can assess the system directly. Option 2 – Reinstall Oracle * Reinstalling Oracle will resolve the issue, but historical production data (including image history) will be lost. * Programs and libraries will remain intact. * This process will take approximately 3–4 hours and can be performed remotely, including reconfiguration and system verification. Please let us know how you would like to proceed. @Eric McElmurry / OEI , Please let Adam know if there would be any charges for this future are previous service. Best Regards, [cid:2bf29044-f8aa-4166-a3dc-32fd8ac97f18] ________________________________ From: Adam Evans Sent: Tuesday, June 23, 2026 1:06 PM To: Saqib Toor / OEI Subject: Re: Control file how-to Saqib, So I can present our leadership with the wipe and create a new DB scenario, can you reiterate what exactly we will lose please? You mentioned that the programs would not be touched and historical failure data would be lost from the images, but would there be anything else? From: Adam Evans Date: Tuesday, June 23, 2026 at 9:15 AM To: [email] Subject: Re: Control file how-to I just refreshed the files and team viewer is open. ID: 911 315 961 Password: r5gb24 From: [email] Date: Tuesday, June 23, 2026 at 8:35 AM To: Adam Evans Subject: Re: Control file how-to CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. The ORA-12528 error code is for database is in restricted mode. That is probably better than the file mismatch we had yesterday. We changed the status yesterday to Mount and it may have remembered that last status. If it is taking only 37 seconds to move the file the I can try to help. I would make sure that Omron applications are not running and bogging down the memory. The collection application was consuming lots of resources yesterday. Please let me know if the team viewer is open and I can help. I have a meeting at 10:00 and schedule is open before 10:00. Best Regards, [cid:7271aeac-0529-4b5a-ad3d-c74604441843] ________________________________ From: Adam Evans Sent: Tuesday, June 23, 2026 8:13 AM To: Saqib Toor / OEI Subject: Re: Control file how-to So after I dropped the files down, this was the new error that was presented, 'ORA-12528: TNS:listener: all appropriate instances are blocking new connections’ I ran through the recovery process and control02.ctl which is in the flash recovery area, triggered a file inconsistency error. I took the control file from the prismDB area and copied it to the flash recovery area, overwriting the control file that was there. I still couldn’t open the database so I ran the recovery process again but was met with the same ‘file is more recent than control file’ error. After doing some research last night, there is an rman module that may work better than the sqlplus module. The files pulled from the image I have in a temp area on the server so in the event we hit a roadblock, its a quick 20 second copy overwrite to start over. From: [email] Date: Tuesday, June 23, 2026 at 8:05 AM To: Adam Evans Subject: Re: Control file how-to CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. HI Adam, We do not have a dedicated Oracle support team. However, I can reach out to our team in Japan, and they can coordinate with the software developers to review this issue. I will need to collect the Oracle logs as well as the VDB logs to proceed so that we can share them for further analysis. In the meantime, did you notice any improvement on the AOI side after replacing the files? If the files were not mismatched, we should not need to make additional changes on the Oracle side. Please let me know what you observed, and we can determine the next steps from there. Best Regards, [cid:06017d70-53ac-49d2-a52c-9c2faa61b03e] ________________________________ From: Adam Evans Sent: Tuesday, June 23, 2026 7:30 AM To: Saqib Toor / OEI Subject: Re: Control file how-to You don't often get email from [email] Learn why this is important I placed the copied files on the server and tried to go through the steps that we did yesterday but we are still receiving errors, however the files appear to be in a more stable state as Oracle is not doing weird things like it was yesterday with the listener and what not. You mentioned that the Omron Oracle team isn’t online until the evening? From: [email] Date: Monday, June 22, 2026 at 2:27 PM To: Adam Evans Subject: Re: Control file how-to CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Adam, Please make sure that all servies using prism account log on are enabled. I would restart the server and check if HTTP error goes away. Please let me know what you find out. Best Regards, [cid:7bc4c0d4-bd4c-44fa-a5e5-9deceadd4c55] ________________________________ From: Adam Evans Sent: Monday, June 22, 2026 2:23 PM To: Saqib Toor / OEI Subject: Re: Control file how-to You don't often get email from [email] Learn why this is important Ok, vendor got us the files. I am working on getting those copies to a thumb drive. Just so I am clear, I am stopping all the Oracle services on the Prism server, dropping the files from the thumb drive into that prismdb folder location, overwriting what is there and then once everything is copied over, starting up all the Oracle services? Get Outlook for Android ________________________________ From: Adam Evans Sent: Monday, 22 June 2026 12:10:15 To: [email] Subject: Control file how-to https://fatdba.com/2013/01/21/recovery-error-ora-01207-file-is-more-recent-than-control-file-old-control-file/ Get Outlook for Android [email_sig_logo] Whenever, wherever, we make your experience better. [LCI YouTube] [LCI facebook] [LCI linkedin] [LCI Instagram] NYSE:LCII This message and any attachments (collectively, the "Message") are only intended for the use of the intended recipient(s) and contain information that may be confidential, subject to privilege, and/or exempt from disclosure under applicable law. If you are not the intended recipient of this Message, you are hereby notified that you have received this Message in error and any distribution, disclosure, printing, copying, storage, modification, or the taking of any action in reliance upon this Message is strictly prohibited. If you have received this Message in error, please immediately notify the sender and delete the Message from your system(s). For details on your privacy rights, including how we may gather, use, and share your personal information, please see our privacy notice available here. WARNING! This is an email from an external party. Do not click on any link or open any attachment if you cannot ascertain that it is safe. [email_sig_logo] Whenever, wherever, we make your experience better. [LCI YouTube] [LCI facebook] [LCI linkedin] [LCI Instagram] NYSE:LCII This message and any attachments (collectively, the "Message") are only intended for the use of the intended recipient(s) and contain information that may be confidential, subject to privilege, and/or exempt from disclosure under applicable law. If you are not the intended recipient of this Message, you are hereby notified that you have received this Message in error and any distribution, disclosure, printing, copying, storage, modification, or the taking of any action in reliance upon this Message is strictly prohibited. If you have received this Message in error, please immediately notify the sender and delete the Message from your system(s). For details on your privacy rights, including how we may gather, use, and share your personal information, please see our privacy notice available here. WARNING! This is an email from an external party. Do not click on any link or open any attachment if you cannot ascertain that it is safe. [email_sig_logo] Whenever, wherever, we make your experience better. [LCI YouTube] [LCI facebook] [LCI linkedin] [LCI Instagram] NYSE:LCII This message and any attachments (collectively, the "Message") are only intended for the use of the intended recipient(s) and contain information that may be confidential, subject to privilege, and/or exempt from disclosure under applicable law. If you are not the intended recipient of this Message, you are hereby notified that you have received this Message in error and any distribution, disclosure, printing, copying, storage, modification, or the taking of any action in reliance upon this Message is strictly prohibited. If you have received this Message in error, please immediately notify the sender and delete the Message from your system(s). For details on your privacy rights, including how we may gather, use, and share your personal information, please see our privacy notice available here. WARNING! This is an email from an external party. Do not click on any link or open any attachment if you cannot ascertain that it is safe. [email_sig_logo] Whenever, wherever, we make your experience better. [LCI YouTube] [LCI facebook] [LCI linkedin] [LCI Instagram] NYSE:LCII This message and any attachments (collectively, the "Message") are only intended for the use of the intended recipient(s) and contain information that may be confidential, subject to privilege, and/or exempt from disclosure under applicable law. If you are not the intended recipient of this Message, you are hereby notified that you have received this Message in error and any distribution, disclosure, printing, copying, storage, modification, or the taking of any action in reliance upon this Message is strictly prohibited. If you have received this Message in error, please immediately notify the sender and delete the Message from your system(s). For details on your privacy rights, including how we may gather, use, and share your personal information, please see our privacy notice available here. WARNING! This is an email from an external party. Do not click on any link or open any attachment if you cannot ascertain that it is safe.