oracle11g recovery of the database based on DBF after reloading the system

1. Install an Oracle environment that is consistent with the original system, primarily including version, data name SID, instance name, path, and database encoding

2. Modify the parameters of the Listener.ora

1. Sid_list_listener =
2. (Sid_list =
3. (Sid_desc =
4. (Sid_name = Plsextproc)
5. (Oracle_home = D:\oracle\product\10.1.0\db_1)
6. (program = Extproc)
7. )
8. (Sid_desc =
9. (Global_dbname = ORCL) //If you already have this ORCL, this file will not be modified.
10. (Oracle_home = D:\oracle\product\10.1.0\db_1) //This is to be based on your actual path
11. (Sid_name = ORCL)
12. )
13. )
14. LISTENER =
15. (Description_list =
16. (DESCRIPTION =
17. (Address_list =
18. (ADDRESS = (PROTOCOL = TCP) (HOST = lypch) (PORT = 1521))
19. )
20. (Address_list =
21. (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
22. )
23. )
24. )

3. Modify the parameters of the Tnsnames.ora

1. ammicly =
2. (DESCRIPTION =
3. (ADDRESS = (PROTOCOL = TCP) (HOST = lypch) (PORT = 1521))
4. (Connect_data =
5. (SERVER = dedicated)
6. (service_name = ORCL)
7. (ur=a) The //parameter allows only administrative connections, when the database is Nomount,mount or restricted, when the dynamic listener display status is blocked, the client configuration ur=a the connection.
8. )
9. )
10. Extproc_connection_data =
11. (DESCRIPTION =
12. (Address_list =
13. (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
14. )
15. (Connect_data =
16. (SID = Plsextproc)
17. (PRESENTATION = RO)
18. )
19. )

3.sql>shutdown Immediate Stop service, remove the newly installed Oracle's DBF backup and copy the original DBF to the newly installed directory F:\APP\TOSHIBA\ORADATA\ORCL

4. The Flash_recovery_area directory under the original Oracle Library Master directory is all covered in the newly installed Oracle directory

5. Sql>startup Start the service again

According to the blog operation of the friend feedback, multi-instance when there is doubt, according to the following address operation solved the problem

Http://blog.sina.com.cn/s/blog_a59b6d310102vat0.html

oracle11g recovery of the database based on DBF after reloading the system