Are four ways to start Oracle Database

Aug 26 posted in Oracle Database (RSS), 61 views.
1, startup nomount
Non-installation boot: in this way to start the next executable: rebuild control file, rebuild the database, start instance, that launched SGA and background processes, which started just init.ora file.

2, startup mount dbname
Installation start: this way to start the next executable: Database log archiving, database recovery, re-naming of some database files, such as: system table space or log file. Implementation of the "nomount", then open the control file

3, startup open dbname
First, implementation of the "nomount", then run the "mount", then open the Redo log file, including all the database files, including this manner can access data in the database.

4, startup is equal to the following three command startup nomount
alter database mount
alter database open
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of Are four ways to start Oracle Database

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
Red Hat ftp cluster iowait NFS c# oracle query too big delete a table forcefully in oracle + nowait Merge SQL_TEXT and SQL_BIND how to find a first letter in a string pl/sql rename directory data pump snapshot too old error 10g using datapump linux multiple path .bash_profile +"create table as select" +drop +constraint +Oracle unix+set+SQLPLUS+ARRAY view recompilation and 11gR2 ebs concurrent parameter extract ddl in oracle user can we link 2 dblink max record  in oracle + duplicate set oracle enterprise linux + disable script at startup svrmgr oraclexe select * from utl_dir oracle mksample sp2-0640 oracle 8i and windows 2003 optimization sql prime number student oracle err 1034 $ORACLE_HOME/bin/genclntsh avoid logging to db2 database for cur in loop end loop ubuntu 10.04 install gcc 3.3 oracle9i INITRANS steps to install oracle 11g to coexist with 10g show parameter SERVICE_NAME
Random Entries
Latest Comments
Categories
Related