ORACLE 数据库练习册(新).doc

IndexPractice 1、Install -2Practice 2、Oracle structure - 3Practice 3、Oracle network - 4Practice 4、Oracle backup - 6 Practice 1: InstallPart 1 SQL1、Which service does the OracleServiceDB02 start? Choose one of the following: (OracleServiceDB02 启动了什么服务,只选择一个正确答案) （ ）a. The Listener (监听)b. The Names Server (服务)c. The database DB02 (数据库DB02)d. The Agent (代理进程)e. All of the above (所有上面说到的)f. None of the above (上面说的都不对)2、What will be the result of stopping the OracleServiceDB02? (停止 OracleServiceDB02 的结果是什么)( )a. The database DB02 is stopped (数据库DB02被停止)b. All Oracle services are stopped (所有的oracle服务都被停止)c. Only OracleServiceDB02 is stopped (只有OracleServiceDB02 被停止)d. None of the above (上面所有的都不对)3、When is the OracleServiceDB02 created?(OracleServiceDB02 什么时候创建的)( )a. During the Oracle Server installation(服务启动的时候)b. During a manual database creation with the SQL*Plus tool (用sqlplus 服务手动创建数据库的时候)c. During a database creation with the Oracle Database Configuration Assistant (用数据库配置工具创建数据库的时候)d. During the database startup(在数据库启动的时候)4、用户尝试登录但收到ORA-01034 ORACLE 不可用的错误消息，下列哪项可能是出现此问题的原因（ ）a用户提供的口令无效b用户提供的用户名无效c用户连接到的例程没有运行d用户请求的 Oracle 版本未安装5、用户执行 SQL 命令更新 EMP 表中的行哪个进程执行此语句 （ ）a用户进程 (user process)b服务器进程(server process)c. DBWRd. LGWR6、以下哪些内存区域用于高速缓存数据字典信息 （ ）a数据库缓冲区高速缓存( data buffer)bPGAc重做日志缓冲区 (log buffer)d共享池 (shared pool )Practice 2: Oracle structure Managing an Oracle Instance1、Identify the database name, instance name, and size of the database blocks.(用什么指令显示数据库的名字,)2、List the name and size of the data files, online redo log files, and the name of the control files. （显示数据文件、日志文件、控制文件的大小和名称）3、 List the size of the components in SGA. （显示SGA区组件的大小）4、 Display the maximum number of operating system user processes that can simultaneously connect to the instance. （显示并发连接到数据库实例最大的操作系统用户进程）5 、Spools all initialization parameters to the output file para.lst.（查出初始化文件的参数并将结果保存到“para.lst”文件）Practice 3: Oracle networkPart 1: Network of server side1、Create a listener lsnrnn using Net8 Assistant on the Your PC. The listener must also be configured for the TCP/IP protocol only and must listen for incoming connections on the port provided by the instructor. Do not configure the listener to use prespawned dedicated servers. （在您的机器上，用Net 8助手创建一个“lsnrnn”进程，该进程必须接收TCP/IP用户协议请求，不要配置专有服务）2、 View the contents of the listener.ora file to verify the configuration details.（看一下“listener.ora”文件，来检验您的配置结果）3、Using the Listener Control utility, start your listener.（用Listener工具来启动您的“Listener”）4 、Start up your database instance.（启动您的数据库）Part 2: Network of client sideIf you are unsure of the name of your client, please ask the instructor how to obtain the name.1 、Using the local naming method in Net8 Assistant, configure the client side to connect to your DB. The protocol used is TCP/IP. The port number for the listener you should connect to is the port number provided for the listener in the previous practice. SID is Unn.（在客户端，使用Net8助手采用本地命名方法，连接到你的数据库，协议是TCP/IP协议，端口是你前面练习所提示的端口，SID是“Unn”）Note: Use the Oracle8i Release 8.0 Database SID method to connect instead of theOracle8i Release 8.1 Service Name method.2、 Test that the service is operational.（测试服务名）3 、Investigate the contents of the tnsnames.ora file.（看一下“tnsnames.ora ”文件中的内容）4、 Connect to the server as system/manager using SQL*Plus and verify that youare connected to the correct instance by querying the V$INSTANCE view. （以“system/manager”登陆服务器，查询“V$INSTANCE”视图，看一下你连接的实例名称）5 、Using the local naming method in Net8 Assistant, configure the client side to connect to DB server. The protocol used is TCP/IP. The port number for the listener you should connect to is the port number provided for the listener in the previous practice. SID is ORCL.（在客户端，使用Net8助手采用本地命名方法，连接到你的数据库服务器，协议是TCP/IP协议，端口是你前面练习所提示的端口，SID是“ORCL”）Note: Use the Oracle8i Release 8.0 Database SID method to connect instead of theOracle8i Release 8.1 Service Name method.）6、Test that the service is operational.（测试服务名）7、Investigate the contents of the tnsnames.ora file.（看一下“tnsnames.ora”文件中的内容）8、Connect to the server as system/manager using SQL*Plus and verify that youare connected to the correct instance by querying the V$INSTANCE view. （以“system/manager”登陆服务器，查询“V$INSTANCE”视图，看一下你连接的实例名称） Practice 4: BackupPart 1: Oracle Backup and Recovery Configuration1、Connect to SQL*Plus as sysdba and mount the database.（以“sysdba”身份登陆数据库，将数据库启动到“mount”状态）2、List the parameters LOG_ARCHIVE_DEST, LOG_ARCHIVE_START, andLOG_ARCHIVE_FORMAT, and note the values.（查看“LOG_ARCHIVE_DEST, LOG_ARCHIVE_START”和“LOG_ARCHIVE_FORMAT”参数值）3、Check the log mode of the database and whether automatic archival is enabled.（查看数据库的模式，看一下归档模式是否启动）4、Shut down the instance with the IMMEDIATE option.（用“IMMEDIATE”选项关掉数据库）5、Set the parameters LOG_ARCHIVE_DEST, LOG_ARCHIVE_START, andLOG_ARCHIVE_FORMAT.（配置“LOG_ARCHIVE_DEST”，“ LOG_ARCHIVE_START”，“LOG_ARCHIVE_FORMAT”）6、Open the database in mount mode.（将数据库启动到“mount”状态）7、Set the database in archivelog mode.（将数据库配置到归档模式）8、Check the log mode of the database and whether automatic archival is enabled.（查看数据库的模式，看一下归档模式是否启动）9、List the detail status of archive log files（看一下归档日志文件的状态）10、Switch the archivelog files twice, then show the values of the ARCHIVE parameters, list the directory and filename of archived log files（将归档日志文件切换两次，看一下“ARCHIVE”参数值，例出归档日志文件 的名称）11、List the detail status of archive log files（例出归档日志文件的状态）Part 2: Database Backup 1、While the database is open, connect to the database as sys or system and usingV$ and Data Dictionary Views, make a list of all of the files that must be backedup for a whole offline database backup.（以“sys”或“system”的身份，为了执行脱机备份，查看数据字典得知你要备份的数据文件） Note: Copy the redo logs for ease of restore/recovery in noarchivelog mode.2、Shut down the database with the IMMEDIATE option. Make two whole offlinedatabase backups using the operating system commands. Place one in labDONTOUCH directory, and the other in labBACKUP.（以“IMMEDIATE“方式关闭数据库，将你要备份的数据文件脱机，用操作系统命令文件来执行备份）Note: Do not place or remove files from the DONTOUCH directory withoutinstructor supervision. This copy will be used as the base in Scenarios.3、Start the instance.（启动实例）4 、Create a binary copy of the control file and put it in the $HOME/BACKUPdirectory. Name the backup copy cntrl1.bkp.（对控制文件采用2进制的方式进行备份，备份结果放到“$HOME/BACKUP”，备份结果文件名为“cntrl1.bkp”）5、Backup the control file to trace.List the full name of the trace file and the logfile section of this trace file. （以跟踪文件方式来备份控制文件，查看跟踪文件的内容） Part 3: Complete Database Recovery: Archivelog Mode1、List the full name of the datafile of system tablespace（显示系统表空间名和数据文件名）2、Shut down the instance and delete the datafile of system tablespace（关闭数据库删除系统表空间的数据文件）3、Attempt to startup the instance, what happened?（启动实例看有什么情况发生）4、Copy the backup datafile of system tablespace from labbackup .（复制系统表空间的备份结果文件到“labbackup”目录）5、Attempt to open the ins