The use of Oracle's Oradim tools ____oracle

1, what is the Oradim Oradim tool is a command-line tool for Oracle on Windows, for manual Oracle service creation, modification, deletion, and so on. The use of Oradim is simple, and you can see the commonly used command examples from the Help file, no longer repeating here.
Oradim is also used in database recovery, many friends have asked the question: On Windows, if the system crashes, the database software may be lost, but the data files, control files, log files and so on, how to restore the Oracle database.
In fact, the process is very simple, usually as long as the original directory structure reinstall ORACLE software, and then through the Oradim tool to rebuild the service, you can start the instance, loading the database (of course, the relevant parameter files and password files need to exist in the $oracle_home/database directory).
Take a look at the following procedure, after you create a service through Oradim, the instance starts:
C:/>oradim-new-sid eygle The net command to see which services the system has started, and that Oracle's services have been started:
C:/>net start
The following Windows services have been started: Oracleserviceeygle
Plug and Play
Print Spooler If you have some UNIX enhancements installed on your system, you can filter through grep:
C:/>net Start |grep Oracle
Oracleserviceeygle
After using the Oradim tool, a log file is generated in the $oracle_home/database directory. 2, the use of Oradim tools to create routines:
-new-sid SID | -SRVC Service [-intpwd password] [-maxusers quantity] [-startmode a|m] [-pfile file] [-timeout sec] Edit routine:
-edit-sid SID [-newsid SID] [-intpwd password] [-startmode auto|manual] [-pfile filename] [-shutmode a|i|n] [-shuttype srvc|inst|srv C,inst] [-timeout seconds] Remove routine:
-delete-sid SID | -SRVC Service name-startup-sid SID [-usrpwd password] [-starttype srvc|inst|srvc,inst] [-pfile filename]-shutdown-sid sid [-usrpwd Password] [- Shuttype Srvc|inst|srvc,inst] [-shutmode a | i | n]-? | -H | -help-sid SID Specifies the name of the instance to start
-SRVC service Specifies the name of the service to start
-usrpwd password Specifies the password for the internal user, if logged on as an NT administrator, do not use this parameter
The-pfile file name is an instance indicating the initialization parameter file, and if the parameter file is in Oracle's default location, this command is not required
-starttype Srvc|inst|srvc,inst indicates what to start srvc-only start the service inst-boot instance, the service must have started and started working srvc,inst-services and instances are started
-shuttype Srvc|inst|srvc,inst indicates what to terminate, parameter options ditto
-startmode A|m represents the mode A-auto (Automatic) M-manual method (manual) used by the startup instance
-shutmode A|i|n indicates the shutdown mode a-abort mode used by the terminating instance i-immediate mode N-normal Mode 1. Generates a new instance management service in the service, starting with a manual
Oradim-new-sid test-startmode Manual-pfile "D:/oracle/admin/test/pfile/inittest.ora
ORADIM-NEW-SRVC oracleservicetest-startmode Manual-pfile "D:/oracle/admin/test/pfile/inittest.ora
Note: The valid service name is "Oracleservice" followed by "SID"
-sid test and-SRVC oracleservicetest equivalent 2. Delete this instance or service
Oradim-delete-sid Test
ORADIM-DELETE-SRVC Oracleservicetest
3. Edit this instance to start with manual
Oradim-edit-sid Test-startmode Manual
4. Edit this instance and start the method automatically
Oradim-edit-sid Test-startmode Auto
5. Start test
Oradim-startup-sid Test
Oradim-startup-sid Test-starttype Srvc,inst
6. Start Test Service only
Oradim-startup-sid Test-starttype SRVC
7. Start test instance only
Oradim-startup-sid Test-starttype Inst
8. Close Test
Oradim-shutdown-sid Test
Oradim-shutdown-sid Test-shuttype Srvc,inst 3, an example of Windows helps to understand how to recover an Oracle database if the system crashes, data files, control files, log files, and so on on Windows. ? If the software is lost, then you need to reinstall the database software to restore information such as Windows related environment variables.
A lot of people complain that my new book is very little about windows, and in fact, there's no difference between windows and Linux/unix, and Windows itself is a UNIX-like system.
Well, I'd like to use a series of articles about the Windows system I'm using, and what I think about database system independence. First, open a CMD command line window.
Start-> Run->cmd
My Oracle software is installed in D:oracle:
D:>dir Oracle
The volume in drive D is privat
The serial number of the volume is 94b0-fd3b
D:oracle's Directory
2006-08-16 14:14 <DIR>.
2006-08-16 14:14 <DIR>.
2006-08-16 14:14 <DIR> ORA10GR2
0 Files 0 bytes
3 directory 941,744,128 Available Bytes My data files are located under D:oradata:
D:>dir D:oradata
The volume in drive D is privat
The serial number of the volume is 94b0-fd3b
D:oradata's Directory
2006-08-16 14:25 <DIR>.
2006-08-16 14:25 <DIR>.
2005-09-12 16:40 <DIR> Flash_recovery_area
2005-09-12 16:40 <DIR> Eygle
0 Files 0 bytes
4 Directory 941,744,128 free bytes Now let's create an instance with Oradim, which is actually creating a Windows service:
C:>oradim-new-sid Eygle We use the net command to see what services the system started, and we see Oracle's services started:
C:>net start
The following Windows services have been started: O&o Defrag
Oracleserviceeygle
Plug and Play
The Print Spooler command completed successfully. If your system has some UNIX enhancements installed, you can filter through grep:
C:>net Start |grep Oracle
Oracleserviceeygle
Unix command tools can be downloaded at SourceForge (http://sourceforge.net/projects/gnuwin32/).
At this point we can start the Oracle database by starting the instance, hooking up the original database. Of course, you may have some other work to do, such as rebuilding password files. C:>oradim-delete-sid Eygle Of course doing a good backup is still the most important, I have seen some enterprises scattered files in many logical partitions, the result with the system crash lost part of the file, the loss is also very heavy.
No service is required on the Linux/unix to start the instance, and there is no such a similar operation. But at the command line, everything is similar. Http://www.eygle.com/archives/2006/08/oracle10g_on_windows.html