Oracle data recovery, only files in the Oradata folder, no backup files for database recovery, re-installation of the system, Oracle 10g Database recovery

Format reload system, only to think of Oracle 10g database did not do backup, began to think very troublesome, did not expect the database recovery is quite smooth
Recovery method:
1, the original database file backup, (D:\ORACLE\PRODUCT\10.2.0\ORADATA\GQXT), rename it, I named Gqxt_old, (otherwise the database will be prompted when the SID already exists).
2, re-install the database to the original path (do not install to the original path is OK, but the original database file must be in the original path can not change, that is, the path oradata\gqxt is not changed), the database name is the name you want to restore.
3. After the installation is complete, open the services in the management tool and stop all services at the beginning of the Oracle. Change the newly installed database file name, I changed to Oradata\gqxt_new, the original database file changed back to the original name, Gqxt_old change back to Gqxt
4. Restart the Oracle service and monitoring that was just turned off. Log in to the database with Sys/password as DBA and open the table prompt when you log in.
5, open the Command window, I use PL/SQL, execute the command ALTER DATABASE open, refresh the table after startup, and find that the original table can be opened. The recovery was successful. Then use the normal user of the original database to enter. Found everything was OK.

Attention:
If you use the Sys/password as DBA to log in to the database to indicate insufficient permissions (ora-01031) modify
(D:\oracle\NETWORK\ADMIN) folder under the Sqlnet.ora file, add sqlnet.authentication_services= (NTS) and increase permissions.