After the ORACLE11g system is reinstalled, follow the dbf recovery database tutorial, oracle11gdbf

After the ORACLE11g system is reinstalled, follow the dbf recovery database tutorial, oracle11gdbf

1. install an oracle environment consistent with the original system, including version, data name sid, Instance name, path, and database code

2. Modify the parameters of listener. ora.

<Span style = "color: #455353;"> SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1) (PROGRAM = extproc) </span> <span style = "color: # ff0000;"> (SID_DESC = (GLOBAL_DBNAME = orcl) // If the orcl already exists, this file does not need to be modified (ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1) // This file must be based on your actual path (SID_NAME = orcl )) </span> <span style = "color: #455353;">) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = lypch) (PORT = 1521) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC) </span>

3. Modify the parameters of tnsnames. ora

AMMICLY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = lypch) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (UR = A) // The parameter allows only management connections. When the database is nomount, mount, or restricted and the status of dynamic listening is BLOCKED, the client configures UR = A to connect. ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO )))

4. SQL> shutdown immediate stop the service, back up and delete the newly installed dbf from oracle, and copy the original dbf to the newly installed directory F: \ app \ toshba \ oradata \ orcl

5. The FLASH_RECOVERY_AREA directory in the home directory of the original oracle Database overwrites the directory of the newly installed oracle database.

6. SQL> startup start the service again