Shulou(Shulou.com)06/01 Report--

Preface due to some reasons, the Windows operating system needs to be reinstalled, usually the system disk is C disk, the database is installed to D disk or other disk letters, do not store with the system disk. After the system is reinstalled, we need to restore the database. Prepare for system installation before system installation, we need to close the monitoring and database first, and it is best to make a backup. The specific steps are as follows: 1. Turn off listening lsnrctl stop2. Close the database shutdown immediate;3. Back up the entire database installation directory using the copy-paste command if space permits, or you can make a compressed backup. Because it is a Windows system, we can operate it with a mouse. The original installation directory needs to be renamed, such as renaming to oracle_1021_ Bak III, installing the operating system slightly, usually the host engineer to install, do not install the system on the data disk. Data recovery due to the existence of database-related files, we only need to restore the files to the original path. Then first of all, we should install the database software, and then set up monitoring and copy the database-related files. 4.1 install database software 4.2 configure monitor 4.3 install database database installation path is the same as the original database path, instance name is the same. After the installation is complete, we need to shut down the newly installed database. Replace all database-related files. 4.3 recovery of database files database-related files recovery is mainly through the mouse copy and paste operation, the key point is that we should know which files to restore, as well as the path to store these files, if individual files do not exist need further analysis and processing, such as parameters need to be modified, or control file damage and so on. This article only discusses the data recovery without damage to the database file. The steps are as follows: 1. Restore the password file, which is PWD$ORACLE_SID.ora2 under $ORACLE_HOME/database. Restore SPFILE, and the parameter file is $ORACLE_HOME/admin/SPFILE$ORACLE_SID.ora3. Restore control files, data files, log files, usually, control files and data files and log files in the same directory, we start the database to the nomount state, and then through the parameter control_files to find the location of the control file. 4. Restore the tnsnames.ora file in the $ORACLE_HOME/NETWORK/AMDINM directory 5. 0. Restore the * dump directory, and restore the directory under $ORACLE_HOME/admin 6. Start the database startup7. Start listening lsnrctl start8. Verify that you use business users to remotely connect to the database and check the database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.