Introduction to Oracle Startup methods

1, Startup Nomount

Non-installation startup, this way to launch executable: Rebuild control file, rebuild database

Read the Init.ora file, start the instance, that is, start the SGA and background processes, this startup requires only Init.ora files.

2, startup Mount DBName

Install startup, this way to start under executable:

Database log archiving,

Database Media Recovery,

Bring the data file online or offline,

Reposition the data file and redo the log file.

Execute "nomount" and then open the control file to confirm the location of the data file and the online log file.

However, the data file and log files are not checked for verification at this time.

3, Startup Open dbname

Execute "nomount" first, then "Mount", and then open all the database files, including the redo log file,

In this way, Oracle authentication data in the database can be accessed.

4, startup, equal to the following three orders

Startup Nomount

ALTER DATABASE Mount

ALTER DATABASE Open

5, startup restrict

Constraint start

This way the database can be started, but only users with certain privileges are allowed to access

When an unprivileged user accesses, the following prompts appear:

ERROR:

Ora-01035:oracle only allow users with restricted session permissions to use

6, Startup force

Forced start mode

When you cannot close the database, you can use startup force to complete the shutdown of the database

Close the database before performing the normal start database command

7, Startup pfile = parameter filename

Startup method with initialization parameter file

Read the parameter file first, then start the database by setting in the parameter file

Example: Startup Pfile = E:oracleadminoradbpfileinit.ora

8, startup EXCLUSIVE

How to use data dictionary effectively by users

Oracle's data dictionary is one of the important components of the database, which is produced with the database and changes with the database.

Some tables and views are reflected under the SYS user. The data dictionary name is an uppercase English character.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/