Có 40+ tài liệu thuộc chủ đề "database"
tailieu.vn Xem trực tuyến Tải xuống
Managing Undo Data. Explain DML and undo data generation. Monitor and administer undo data. Describe the difference between undo data and redo data. Configure undo retention. Guarantee undo retention. Undo Data. Undo data is:. Transactions and Undo Data. Undo information is stored in undo segments, which are, in turn, stored in an undo tablespace. writable undo tablespace for a given...
tailieu.vn Xem trực tuyến Tải xuống
Apply the principle of least privilege. Maintain the audit trail. Requirements Least Privilege Auditing. Principle of Least Privilege. Least Privilege Auditing. Applying the Principle of Least Privilege. Apply the Principle of Least Privilege Full Notes Page. Standard database auditing. Value-based auditing. Requirements Least Privilege. Audit trail Parameter. Generate audit trail.. Standard Database Auditing. Maintain audit trail.. ALTER SYSTEM SET audit_trail=“XML”...
tailieu.vn Xem trực tuyến Tải xuống
Create Oracle Net Service aliases – Configure connect-time failover – Control the Oracle Net Listener. Use tnsping to test Oracle Net connectivity. Oracle Net Services. Application Oracle Net. RDBMS Oracle Net Client or. Oracle Net configuration files Oracle Net. Oracle Net Listener. Oracle Net configuration files Enterprise. To make a client or middle-tier connection, Oracle Net requires the client to...
tailieu.vn Xem trực tuyến Tải xuống
Manage the Automatic Workload Repository (AWR). Automatic Workload Repository (AWR):. Optimizer Statistics. Automatic Workload Repository . Manage the Automatic Workload Repository
tailieu.vn Xem trực tuyến Tải xuống
13-2 Copyright © 2005, Oracle. Tune SQL by using the SQL Tuning Advisor. Use Automatic Shared Memory Management (ASSM). 13-4 Copyright © 2005, Oracle. 13-6 Copyright © 2005, Oracle. 13-8 Copyright © 2005, Oracle. SQL Tuning Advisor: Overview. Comprehensive SQL tuning. SQL Tuning Advisor. 13-10 Copyright © 2005, Oracle. SQL Tuning Advisor Options and Recommendations. Using the SQL Tuning Advisor....
tailieu.vn Xem trực tuyến Tải xuống
Data file #2 Data file #3 Data file #4 Data file #5 Data file #1. Data file #6 Image copies. Data file #1 Data file #2 Data file #3 Data file #4 Data file #5 Data file #6
tailieu.vn Xem trực tuyến Tải xuống
16-2 Copyright © 2005, Oracle. After completing this lesson, you should be able to recover from the loss of a:. Control file. Data file. 16-4 Copyright © 2005, Oracle. Use Database Control to alter the instance’s status.. 16-6 Copyright © 2005, Oracle. After the instance is open, it fails in the case of the loss of:. A data file belonging...
tailieu.vn Xem trực tuyến Tải xuống
Describe Flashback Database. Restore the table content to a specific point in the past with Flashback Table. Overview Database Table Drop Query Versions Transaction. Table Drop table Drop Recycle bin True. Flashback Database brings the database to an earlier point in time by undoing all changes made since that time.. Flashback Table recovers a table to a point in time...
tailieu.vn Xem trực tuyến Tải xuống
Use SQL*Loader to load data from a non-Oracle database (or user files). Explain the general architecture of Data Pump. Use Data Pump Export and Import to move data between Oracle databases. SQL*Loader Data Pump - Export - Import. Data Pump DBMS_DATAPUMP. Data/Metadata Movement Engine SQL*Loader. SQL*Loader: Overview Directory Obj.. Input data files Control file SQL*Loader. SQL*Loader Overview Full Notes Page....
tailieu.vn Xem trực tuyến Tải xuống
Practice Overview: Configuring RMAN 2-40 3 Using Recovery Manager. Practice Overview: Backing Up Your Database 3-39 4 Recovering from Noncritical Losses. Practice Overview: Recover from Lost TEMPFILE and Redo Log File 4-19 5 Database Recovery. Complete Versus Incomplete Recovery 5-7 Complete Recovery 5-8. Incomplete Recovery 5-9. Situations Requiring Incomplete Recovery 5-11 Types of Incomplete Recovery 5-12. Performing User-Managed Incomplete Recovery...
tailieu.vn Xem trực tuyến Tải xuống
This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license,...
tailieu.vn Xem trực tuyến Tải xuống
Data files Redo log files. Redo log files. Online redo log files
tailieu.vn Xem trực tuyến Tải xuống
Configuring Recovery Manager. Describe the RMAN repository and recovery catalog. Recovery Manager Features (notes only slide). Recovery Manager Components. Disk Flash recovery. Recovery Manager. Recovery Manager Components (notes only slide). Determine the repository location: control file or recovery catalog.. Control file:. Recovery catalog:. Replicates control file data – Has room for more data – Can service many targets – Can...
tailieu.vn Xem trực tuyến Tải xuống
Configuring Recovery Manager. Describe the RMAN repository and recovery catalog. Configure two types of retention policies. Recovery Manager Features (notes only slide). Recovery Manager Components. Disk Flash recovery. Recovery Manager. Recovery Manager Components (notes only slide). Determine the repository location: control file or recovery catalog.. Control file:. Recovery catalog:. Replicates control file data – Has room for more data –...
tailieu.vn Xem trực tuyến Tải xuống
Must be within the braces of a RUN command – Is executed as a group. Backup set. Data file 1 Data file. 2 Data file. 3 Data file. 1 Data file. Only “current” data file backups are usable in ARCHIVELOG mode.. Data file Data file 4. Data file. 6 Data file. 7 Data file 8. Copy of data file 3....
tailieu.vn Xem trực tuyến Tải xuống
Perform complete or incomplete user-managed recovery. Identify situations where incomplete recovery is necessary. Perform complete or incomplete recovery by using RMAN. Perform incomplete recovery based on time, SCN, log sequence, restore points, or the cancel method. Recover an automatically backed up control file. Complete Incomplete Control file RO TBS. User-managed recovery. User-Managed Recovery:. Restore all database files from a backup...
tailieu.vn Xem trực tuyến Tải xuống
Query the recycle bin. Configure Flashback Database. Perform Flashback Database to a point in time. Enable and disable the Flashback Database feature. Use the Enterprise Manager Recovery Wizard to perform Flashback Database. Use guaranteed restore points with Flashback Database. Recycle bin Flashback DB Config. Table Drop table Drop Recycle bin TRUE. Flashback Drop and the Recycle Bin. Recycle Bin. Recycle...
tailieu.vn Xem trực tuyến Tải xuống
7-2 Copyright © 2006, Oracle. DB_BLOCK_CHECKING – DBMS_REPAIR. 7-4 Copyright © 2006, Oracle. 7-6 Copyright © 2006, Oracle. DBMS_REPAIR Logical TRUE. Block media recovery None TRUE. 7-8 Copyright © 2006, Oracle. 7-10 Copyright © 2006, Oracle. 7-12 Copyright © 2006, Oracle. DB_BLOCK_CHECKING. The DB_BLOCK_CHECKING initialization parameter:. DB_BLOCK_CHECKSUM. 7-14 Copyright © 2006, Oracle. 7-16 Copyright © 2006, Oracle. DBMS_REPAIR Package. Using...
tailieu.vn Xem trực tuyến Tải xuống
Describe the memory components in the SGA. Implement Automatic Shared Memory Management. Configure automatic PGA memory management. Memory Management: Overview. DBAs must consider memory management to be a crucial part of their job because:. Java pool Database buffer cache Shared pool. Redo log buffer Large pool Streams pool. Keep buffer cache Recycle buffer cache nK block size buffer caches. Buffer...
tailieu.vn Xem trực tuyến Tải xuống
9-2 Copyright © 2006, Oracle. SQL tuning. 9-4 Copyright © 2006, Oracle. 9-6 Copyright © 2006, Oracle. 9-8 Copyright © 2006, Oracle. Optimizer statistics – System statistics. 9-10 Copyright © 2006, Oracle. wait_class. wait_class#. 9-12 Copyright © 2006, Oracle. 9-14 Copyright © 2006, Oracle. 9-16 Copyright © 2006, Oracle. V$SESSION_WAIT – V$SYSTEM_EVENT – V$SYSSTAT. 9-18 Copyright © 2006, Oracle. 9-20...