网络运行分析-数据库基础-关系数据库基本原理.ppt

* * * * Parameter Description MY_SERVICE.US. … Net service name and domain name. DESCRIPTION Keyword for describing the connect descriptor. Descriptions are always specified the same way. ADDRESS Keyword for the address specification. If multiple addresses are specified, use the keyword ADDRESS_LIST prior to the ADDRESS PROTOCOL Specifies the protocol used. HOST Protocol-specific information for TCP/IP-Specifies the host name of the server or IP address. Can differ for another protocol. PORT Protocol specific information for TCP/IP-Specifies the port number on which the server side listener is listening. CONNECT_DATA Specifies the database service to which to connect. Schedule: Timing Topic 40 minutes Lecture 25 minutes Practice 65 minutes Total * * * * * * * * * * * * * * * * * * * * * * * * Practice 7: Maintaining Redo Log Files 1 List the number and location of existing log files and display the number of redo log file groups and members your database has. Hints: - Query the dynamic view V$LOGFILE. - Use the dynamic view V$LOG. 2 In which database mode is your database configured? Is archiving enabled? Hints: - Query the dynamic view V$DATABASE. - Query the dynamic view V$INSTANCE. 3 Add a redo log member to each group in your database located on u04, using the following naming conventions: Add member to Group 1: log01b.rdo Add member to Group 2: log02b.rdo Verify the result. Hints: - Execute the ALTER DATABASE ADD LOGFILE MEMBER command to add a redo log member to each group. - Query the dynamic performance view V$LOGFILE to verify the result. 4 Add a redo log group in your database with two members located on u03 and u04 using the following naming conventions: Add Group 3: log03a.rdo and log03b.rdo Verify the result. Hints: - Execute the ALTER DATABASE ADD LOGFILE command to create a new group. - Query the Dynamic View V$LOGFILE to display the name of the new members of