oracle11g Poisoning Recovery

Unfortunately, Win2003server lax management, poisoning, after cleaning up the virus. Oracle is paralyzed, too. Last backup was a week ago, what about this week's data?

The first idea is to find another machine, with an identical oracle. Then copy the deleted files.
Implemented to find the deleted files more than a few exe so simple, DLL files and Oracle services have been deleted, recovery is quite troublesome.


Then choose the second route. Re-install Oracle. First, remember to back up the original Oracle home folder.

1th attempt:

Choose not to create a database, install software only, select the original folder, and then error, said installation location conflict

[INS-32025] The selected installation conflicts with the software that is installed in the specified Oracle home folder

Workaround: Delete the C:\Program files\oracle folder and install continue

Then prompted the original folder has content, choose to continue, the installation is complete.

But after the installation, nothing has changed. The deleted file did not come back.

2nd attempt

Delete the original product folder and reload it. This time the deleted EXE and DLL files are back, but the Oracle service is not restored. Executes the database configuration Assistant. It is also not identified and loaded into the original database file.

3rd attempt

First uninstall, prompt to use Deinstall.exe, do, all the way to enter, uninstall complete. Then completely delete the original Oracle, including the registration form, home folder, and other files. See the Web article for details.

Install again, this time choose to create the database, the instance name remains the same as the original.

Installation process has some problems, such as the right to change the key, listen to create failure, database creation failure, and so on, the heart is cold, can only ignore the continuation.

After loading found service back, manually start Tnslistener monitoring services. Start the Oracleservice instance service. Fortunately, there was no impact. Normal startup, you can log in properly to connect with the familiar Scott. Oh, too.

Then the data is restored and the Oracleservice service is stopped. Overwrite all the Oradata folders under the home folder of the original repository of the backup.

Connection tip: Ora-12528:tns: Listener: All applicable routines cannot establish a new connection

Don't panic. Open the Listener.ora file under the home folder \product\11.2.0\dbhome_1\network\admin, and change the Sid_list_listener configuration to:

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 = DB instance name)
(Oracle_home = c:\oracle\product\10.1.0\db_1)
(Sid_name = DB instance name)
)
)

Blue is added, save and restart Tnslistener.

This seems to be a success, SYSDBA can connect, but connect Scott when the error: Ora-01033:oracle Initializationg or shutdown in progress

In cmd mode. Run Sqlpuls/nolog, open Sqlplus,

Sql>connect Sys/[email protected] As SYSDBA connection database with SYSDBA

Sql>shutdown Immediate Stop Service

There is a ORA-01507 error, just still show the sample routine has been closed, then leave this wrong.

Sql>startup Start Service

Error found:

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 "

That's the problem with this file, lo.
Sql>shutdown Immediate Stop service again

Overwrite all the Flash_recovery_area folders under the home folder of the original repository of the backup.

Sql>startup Start the service again

Connect Scott. Success.

Connect the production user. Success..!

Almost cried ...

Assuming that God gave me another chance, I must make a daily backup of my own initiative.

oracle11g Poisoning Recovery