ORACLE9I 1Z0-032认证知识点总结摘要（完）

You must instruct Oracle to gather statistics on the buffer cache by setting the value of the DB_CACHE_ADVICE parameter to ON. The default value for this parameter is OFF. DB_CACHE_ADVICE can take on a third value, READY, which specifies that memory is allocated, but it does not gather statistics. The activity of collecting statistics affects the performance of the system. DB_CACHE_ADVICE is a dynamic parameter and can be changed to ON using ALTER SYSTEM command.

 

The TRACE option of the ALTER DATABASE BACKUP CONTROLFILE command prompts Oracle to write SQL statements, for re-creating the control file, to a trace file. The trace file would exist in the location defined by the initialization parameter USER_DUMP_DEST on your system.

 

When importing a table into a database, the import process performs these tasks:

1,New tables are created.

2,Data is imported.

3,Indexes are built.

4,Triggers are imported.

5,Integrity constraints are enabled on the new tables.

6,Any bitmap, functional, and/or domain indexes are built.

 

The CATALOG command is used to record the existence of user-managed copies of Oracle release 8.0 or later databases created before RMAN was installed.

 

Name of the service is resolved using the tnsnames.ora file. Destination is an Oracle Net alias specified by using the SERVICE keyword in the init.ora initialization file. Specify the archive destination by adding the following entry to the primary database init.ora file:

Log_archive_dest2=”SERVICE=standby_db1 MANDATORY REOPEN=600”

 

RMAN can automatically back up the control file and server parameter file whenever the database structure metadata in the control file changes and whenever a backup or copy record is added. If CONFIGURE CONTROFILE AUTOBACKUP is ON(by default it is OFF), then RMAN automatically backs up the control file and the current server parameter file(if used) in the following circumstances:

After every BACKUP or COPY command issued at the RMAN prompt.

Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP or COPY.

At the end of every RUN block if the last command in the block was either BACKUP or COPY.

 

To use the host naming method for connection resolution, Oracle Net Services, the TCP/IP protocol, and the TCP/IP protocol adapter must be installed on both the client and the server. When using the host naming method, the server listener must be started on port 1521. When instance registration is not implemented, the listener.ora file must contain the global database name.

 

Connection Manager features are not supported with the host naming. Host naming is used in a two-tier environment whereas Connection Manager works with three-tier environment.

 

You can obtain the information pertaining to full database backup sets created using RMAN from the V$BACKUP_SET dynamic performance view that is present in the target database. This view reflects the information stored in the target database’s control file. If you use a recovery catalog, then you can also see the records in the RC_BACKUP_SET catalog view.

 

RMAN uses the packages DBMS_RCVCAT and DBMS_RCVMAN. These are undocumented packages. The DBMS_RCVCAT package is responsible for maintaining information in the recovery catalog or the control file.