Danh mục
Giáo dục phổ thông
Tài liệu chuyên môn
Bộ tài liệu cao cấp
Văn bản – Biểu mẫu
Luận Văn - Báo Cáo
Trắc nghiệm Online
Oracle net
Oracle Net Architecture
Client-Server Application Connection Oracle Net enables a network connection between a client and an Oracle database server. Oracle Net is a software component that resides on both the client and on the Oracle database server. It is layered on top of the network protocol. When a connection is initiated from a client to the Oracle database server, data is passed down a stack on the client, over the network, and up a similar stack to the Oracle database server. The following explains the structure of each essential component of the Oracle Net stack communication architecture at a high-level: Client Application The client application such...
18 trang
76 lượt xem
6 lượt tải
Workshop
Workshop Methodology Group-Oriented and Interactive Structure The workshop is structured to allow individuals to work in groups to perform database backup, restore, and recovery operations. Each group is encouraged to share its approach to resolving database failures with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through backup and recovery scenarios. Experience and knowledge gained from the course will play a major role toward successfully completing the objectives of each session....
18 trang
79 lượt xem
3 lượt tải
RMAN Maintenance
Cross Checks of RMAN Backups and Copies Performing a cross check provides you with a way to ensure that data about backup sets and image copies in the RMAN repository is synchronized with corresponding data on disk or in the media management catalog. You can use the LIST command to obtain a report of the backups and copies that you have made and then use the CROSSCHECK command to check that these files still exist. If RMAN cannot find a file, it updates the repository records to EXPIRED. You can determine which files are marked EXPIRED by issuing a LIST EXPIRED command....
18 trang
50 lượt xem
5 lượt tải
Tuning Workshop
Small shared pool Small database buffer cache Small redo log buffer cache Missing indexes Rollback segments and undo tablespace Sort area size incorrectly set Assorted
16 trang
59 lượt xem
6 lượt tải
Redundant Arrays of Inexpensive Disks Technology (RAID)
Redundant Arrays of Inexpensive Disks Technology (RAID)
12 trang
60 lượt xem
6 lượt tải
Worldwide Support Bulletins
In either case, the easiest way is to drop the entire tablespace that contains the datafile. The steps that are to be executed from within SQL*Plus are: 1. STARTUP MOUNT 2. For each deleted datafile, issue the command ALTER DATABASE DATAFILE ’full path of filename’ OFFLINE [DROP]; Note: You must use the DROP option if the database is in NOARCHIVELOG mode, because you cannot recover this file if you apply incomplete media recovery on it via the command ALTER DATABASE OPEN RESETLOGS. See the SQL Reference for details. 3. ALTER DATABASE OPEN; 4. DROP TABLESPACE INCLUDING CONTENTS [CASCADE CONSTRAINTS];...
14 trang
59 lượt xem
4 lượt tải
RMAN Complete Recovery
Restoration and Datafile Media Recovery Using RMAN RMAN automates the procedure for restoring files. When you issue the RESTORE command, RMAN uses a server session to restore the correct backups and copies. The RMAN repository is used to select the best available backup set or image copies to use in the restoration. By default, RMAN does not restore a file if the file is already in the correct place and its header contains the correct information. In releases before Oracle9i, the files were always restored. When you issue the RMAN RECOVER command, RMAN applies changes from online redo log files and archived...
16 trang
62 lượt xem
7 lượt tải
RMAN Incomplete Recovery
Using Oracle Enterprise Manager You can use the Recovery Wizard to restore and recover your database. On the Range Selection page you must enter a date and time to restore to a previous point. You use Instance Management or the Console to open the database after the job has completed. You can view the status of the job by selecting the Active and History page tabs in the Console’s Job window.
12 trang
57 lượt xem
4 lượt tải