Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use oradim tools". In daily operation, I believe many people have doubts about how to use oradim tools. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts about "how to use oradim tools". Next, please follow the editor to study!

Oradim tool is a command line tool of Oracle on Windows, which is used to manually create, modify, delete and so on Oracle services.

Oradim is also used in database recovery. On Windows, if the system crashes due to the loss of database software (but data files, control files, log files, parameter files, etc.), oradim can be used to restore the database.

1. Reinstall the Oracle software according to the original directory structure

two。 Copy data files, control files, log files, parameter files, etc., to the original directory

3.oradim create service

C:\ Users\ Administrator > oradim-new-sid OA

The instance has been created.

At this point, the instance has been started:

C:\ Users\ Administrator > net start

The following Windows services have been started:

...

OracleServiceOA

...

4. Start the database

C:\ Users\ Administrator > set ORACLE_SID=OA

C:\ Users\ Administrator > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Monday February 18 13:37:04 2019

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle routine.

SQL > startup

The ORACLE routine has been started.

Total System Global Area 1286066176 bytes

Fixed Size 2175408 bytes

Variable Size 352325200 bytes

Database Buffers 922746880 bytes

Redo Buffers 8818688 bytes

The database is loaded.

The database is already open.

At this point, the study on "how to use the oradim tool" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.