ORACLE11g poisoning recovery, oracle11g poisoning

ORACLE11g poisoning recovery, oracle11g poisoning

Unfortunately, the win2003 server is neglected to manage and poisoned. After the virus is cleared, oracle is paralyzed. What should I do if the last backup is still one week ago?

The first idea is to find another machine, install the same oracle, and copy the deleted file.
After implementation, it was found that more than a few exe files were deleted, and the dll files and oracle services were also deleted, which was quite troublesome to restore.


Then select the second path to reinstall oracle. First, remember to back up the original oracle Home Directory.

1st attempts:

Choose not to create a database, only install software, select the original directory, and then report an error, indicating that the installation location conflict

[INS-32025] the selected installation conflicts with the software installed in the specified Oracle Home Directory.

Solution: Delete the C: \ Program Files \ Oracle directory and install

Then, the system prompts that the original directory contains content. Select "continue" and the installation is complete.

However, after the installation is complete, nothing is changed, and the deleted file is not returned.

2nd attempts

Delete the original product directory and install it again. The deleted exe and dll files are returned, but the oracle service is not recovered. After running the Database Configuration assistant, It is not identified and loaded to the original database file.

3rd attempts

Run deinstall.exe, and press enter to uninstall deinstall.exe. Then delete the original oracle, including the registry, main directory, and other files. For more information, see network articles.

Re-install, this time select to create a database, the Instance name remains the same.

Some problems have occurred during the installation process, such as having no permission to modify the key, failed to listen for creation, and failed to create the database. The problem can only be ignored all the way.

After installation, I found the service was back. I manually started the TNSListener listening service and started the OracleService instance service. Fortunately, it didn't affect the normal start. I was able to log on to scott, who is familiar with the connection.

Then the data is restored, the OracleService service is stopped, And the oradata directory in the home directory of the original database is overwritten.

Connection tip: ORA-12528: TNS: listeners: all applicable routines cannot create a new connection

Do not panic. Open the listener. ora file under the main directory \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN, and modify the SID_LIST_LISTENER configuration:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C: \ oracle \ product \ 10.1.0 \ db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = database instance name)
(ORACLE_HOME = c: \ oracle \ product \ 10.1.0 \ db_1)
(SID_NAME = database instance name)
)
)

Blue is added. Save and restart TNSListener.

This seems to have succeeded, sysdba can be connected, but when scott is connected, an error is reported: ora-01033: oracle initializationg or shutdown in progress

Run sqlpuls/nolog in cmd mode to enable sqlplus,

SQL> connect sys/password @ orcl as sysdba connect to the database with sysdba

SQL> shutdown immediate

The error of a ORA-01507 appears, but it still shows that the routine is closed, so don't worry about this error.

SQL> startup

Error reported:

The ORACLE routine has been started.
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 234882472 bytes
Database Buffers 536870912 bytes
Redo Buffers 5259264 bytes
ORA-00211 :???????????????
ORA-00202 :???? : 'D: \ ORACLE11G \ FLASH_RECOVERY_AREA \ ORCL \ CONTROL02.CTL''

This file is faulty.
SQL> shutdown immediate stop the service again

Overwrite the FLASH_RECOVERY_AREA directory in the home directory of the original database.

SQL> startup restart the service

Scott connected. Successful!

Connection to production user. Successful !!!

Almost cried ......

If God gives me another chance, I will make it an automatic backup every day!

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.