18 trang
76 lượt xem
6 lượt tải
Oracle net
Oracle Net ArchitectureClient-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...
WorkshopWorkshop 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 MaintenanceCross 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
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 BulletinsIn 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 RecoveryRestoration 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 RecoveryUsing 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
Chịu trách nhiệm nội dung: Nguyễn Công Hà. ©2025 Công ty TNHH Tài Liệu trực tuyến Vi Na.
Địa chỉ: 54A Nơ Trang Long, P. Bình Thạnh, TP.HCM - Điện thoại: 0283 5102 888 - Email: info@tailieu.vn
Giấy phép Mạng Xã Hội số: 670/GP-BTTTT cấp ngày 30/11/2015