26.oracleocp題庫dba經(jīng)典輔助學(xué)習(xí)

1、Controlling the DatabaseObjectivesAfter completing this lesson, you should be able to do the following:Start and stop iSQL*PlusStart and stop Enterprise Manager Database ControlStart and stop the Oracle ListenerStart up and shut down Oracle Database 10gStarting and Stopping iSQL*Plus$ isqlplusctl st

2、artiSQL*Plus 10.1.0.2.0Copyright (c) 2004 Oracle. All rights reserved.Starting iSQL*Plus .iSQL*Plus started.$ isqlplusctl stopiSQL*Plus 10.1.0.2.0Copyright (c) 2004 Oracle. All rights reserved.Stopping iSQL*Plus .iSQL*Plus stopped.Management FrameworkThe three components of the Oracle Database 10g m

3、anagement framework are:Database instance ListenerManagement interface Database ControlManagement agent (when using Grid Control)ListenerDatabase ControlManagementagentManagement interface-or-Starting and Stopping Database Control$ emctl start dbconsoleTZ set to US/PacificOracle Enterprise Manager 1

4、0g Database Control Release 10.1.0.2.0Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. Starting Oracle Enterprise Manager 10g Database Control started.Logs are generated in directory _orcl/sysman/log$ emctl stop dbconsoleTZ set to US/PacificOracle Enterprise Manager 10g Database Con

5、trol Release 10.1.0.2.0Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved. Stopping Oracle Enterprise Manager 10g Database Control . . Stopped.Accessing Database ControlSYSOPER and SYSDBADatabase Home PageChanging the Listener StatusStartup and ShutdownClick Advanced Options to select

6、startup options and shutdown modeStarting Up a DatabaseNOMOUNTOPENMOUNTNOMOUNTSHUTDOWNInstance startedSTARTUPStarting Up a DatabaseMOUNTOPENMOUNTNOMOUNTSHUTDOWNControl file opened for this instanceInstance startedSTARTUPSHUTDOWNStarting Up a DatabaseOPENOPENMOUNTNOMOUNTSHUTDOWNAll files opened as de

7、scribed by the control file for this instanceControl file opened for this instanceInstance startedSTARTUPSHUTDOWNShutting Down the DatabaseShutdown mode:A = ABORTI = IMMEDIATET = TRANSACTIONALN = NORMALANoNoNoNoTNoNoYesYesINoNoNoYesShutdown ModeAllow new connectionsWait until current sessions end Wa

8、it until current transactions endForce a checkpoint and close filesNNoYesYesYesSHUTDOWN OptionsOn the way down:Database buffer cache written tothe data files mitted changes rolledbackResources releasedOn the way up:No instance recoveryDuring SHUTDOWN NORMALorSHUTDOWN TRANSACTIONALorSHUTDOWN IMMEDIAT

9、EConsistent database(clean database)SHUTDOWN OptionsOn the way down:Modified buffersare not written to the data files mitted changes are not rolled backOn the way up:Online redo log files used to reapply changesUndo segments used to roll back mitted changesResources releasedDuring SHUTDOWN ABORTorIn

10、stance FailureorSTARTUP FORCEInconsistent database(dirty database)spfiledb01.oraInitialization Parameter FilesViewing Initialization ParametersViewing the Alert LogSummaryIn this lesson, you should have learned how to:Start and stop iSQL*PlusStart and stop Enterprise Manager Database ConsoleStart and stop the listenerStart up and shut down the databasePractice 5: Controlling the DatabaseThis practice covers the following topics:Connecting to the database using SQL*Plus and iSQL*PlusStoppin