Oracle数据库维护培训胶片.ppt

* * Practice 3: Managing an Oracle Instance 1 Connect to the database as user SYS AS SYSDBA and shutdown the database. 2 With the database shutdown, create an SPFILE from the PFILE. Place the SPFILE in directory $HOME/ADMIN/PFILE with the file name format spfileSID.ora, use your instance name in place of SID. Create the SPFILE from the PFILE located in $HOME/ADMIN/PFILE. 3 From the operating system, view the SPFILE. 4 Connect as user SYS AS SYSDBA, and start the database using the SPFILE. 5 Shutdown the database and open it in read-only mode. Connect as user HR password HR and and insert the following into the REGIONS table. INSERT INTO regions VALUES ( 5, ‘Mars’ ); What happens? Put the database back in read-write mode. 6 Connect as user HR password HR and insert the following row into the table REGIONS; do not commit or exit. INSERT INTO regions VALUES ( 5, ‘Mars’ ); In a new telnet session start SQL*Plus. Connect as SYS AS SYSDBA and perform a shut down transactional. What happens? Rollback the insert in the HR session and exit, what happens? Note: Parameter UNDO_RETENTION, which will be discussed in Managing Undo Data, is set to 15 minutes by default. Because of this parameter it could be 15 minutes before the database shuts down after the ROLLBACK command is executed. Connect to another session as SYS AS SYSDBA and execute the following command to speed up the process. ALTER SYSTEM SET undo_retention=0 SCOPE=MEMORY; 7 Make sure the database is started. Keep the two SQL*Plus sessions open, one session as user SYS AS SYSDBA and one as user HR. As user SYS AS SYSDBA enable restricted session. As user HR select from the regions table. Is the select successful? In the HR session exit SQL*Plus then reconnect as HR. What happens? Disable restricted session. Schedule: Topic Timing Lecture 20 minutes Total 20 minutes * Lesson Aim You may want to create SELECT st