Sunday, September 21, 2008
Database and Instance Startup and Shutdown
Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an Oracle Instance. The memory and processes of an instance manage the associated database's data efficiently and serve the one or multiple users of the database.
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2008
(48)
-
▼
September
(48)
- How an Oracle Instance Is Started
- Overview of Instance and Database Startup
- How Initialization Parameter Values Are Changed
- Initialization Parameter Files and Server Paramete...
- The Instance and the Database
- Database and Instance Startup and Shutdown
- Managing PFILE and SPFILE
- The Oracle SPFILE
- Oracle Startup and Parameter File
- Oracle's PFILE
- Removing a Password File
- Replacing a Password File
- Expanding the number of password file users if the...
- Viewing Password File Members
- Granting and Revoking SYSDBA and SYSOPER Privilege...
- Creating a Password File and Adding New Users to It
- Setting REMOTE_LOGIN_ PASSWORDFILE
- Setting REMOTE_LOGIN_ PASSWORDFILE
- Using ORAPWD
- Oracle Password File
- Dropping Control Files
- Control File V$ Views
- Recovering a Control File
- Recovering a Control File
- Backing Up Control Files
- Troubleshooting After Creating Control Files
- Steps for Creating New Control Files
- CREATE CONTROLFILE Statement
- When to Create New Control Files
- Creating Additional Copies of Control Files
- Creating Control Files
- Size of Control Files
- Multiplexed control files
- Control Files Init.ora parameter
- Oracle Control file
- Datafile Backups
- Oracle Datafile backup - part1
- v$datafile_header view
- v$datafile view
- Renaming and Relocating Datafiles for Multiple Tab...
- Relocating and Renaming Datafiles in a Single Tabl...
- Renaming and Relocating Datafiles for a Single Tab...
- Determine the Number of Datafiles
- Oracle datafiles
- Oracle Startup - Third Stage - Open Database
- Oracle Startup - Second Stage
- Oracle Startup - First Stage
- Oracle Startup
-
▼
September
(48)
No comments:
Post a Comment