User's Guide and Reference
Part Number A82950-01
This chapter provides a brief overview of the database administration tools available in SQL*Plus, and discusses the following topics:
For more information on database administration, see the
Oracle8i Concepts manual.
Special operations such as starting up or shutting down a
database are performed by a database administrator (DBA). The DBA has certain
privileges that are not assigned to normal users. The commands outlined
in this chapter would normally be used by a DBA.
For more information about security and roles in SQL*Plus,
see Appendix E.
An Oracle database may not always be available to all users.
To open or close a database, or to start up or shut down an instance, you
must have dba privileges or be connected as SYSOPER or SYSDBA. Other users
cannot change the current status of an Oracle database.
Starting a database involves three steps:
To start an Oracle instance, without mounting the database, enter
To start an instance, mount the database, but leave the database closed, enter
To start an instance using the Oracle8i Server parameter file INITSALE.ORA, mount and open the database named SALES in exclusive mode, and restrict access to administrative personnel, enter
Shutting down a database involves three steps:
To shut down the database normally after it has been opened and mounted, enter
The redo log is used to record changes made to data. If,
for example, there is a database failure, the redo log is used to recover
the database. To protect against a failure involving the redo log itself,
Oracle allows a mirrored redo log so that two or more copies of
the redo log can be maintained on different disks.
For more information about redo log files and database archiving
modes, see the Oracle8i Concepts manual.
For information about using the ARCHIVE LOG
command, see the "Command Reference" in Chapter
To automatically begin archiving, enter
To list the details of the current log file being archived, enter
SQL*Plus displays results similar to the following:
Database log mode Archive Mode Automatic archival Enabled Archive destination /vobs/oracle/dbs/arch Oldest online log sequence 221 Next log sequence to archive 222 Current log sequence 222
If a damaged database is in ARCHIVELOG mode, it is a candidate
for either complete media recovery or incomplete media recovery operations.
To begin media recovery operations use the RECOVER command. For more information
about using the RECOVER command, see the
"Command Reference" in Chapter 8.
To recover the database up to a specified time using a control backup file, enter
To recover two offline tablespaces, enter