TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 18

Oracle Database Administration for Microsoft SQL Server DBAs part 18 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 152 Oracle Database Administration for Microsoft SQL Server DBAs this will take all of the application databases and copy them over to the new database server. Managing Backups Managing backups is not just about purging and maintaining the retention policy but also about knowing which backups are available for restores. Oracle provides several ways to get information about backup sets. Viewing Backups RMAN has a LIST command that will return the backup sets that are present in the catalog or control file. The listing shows the different backup pieces and details including the checkpointed SCN the date full or incremental and tablespaces that were backed up. In the following example the archive logs were included as part of the full backup so they are also listed. rman list backup using target database control file instead of recovery catalog List of Backup Sets BS Key Type LV Size Device Type Elapsed Time Completion Time 13 Full DISK 00 01 20 08-MAR-10 BP Key 13 Status AVAILABLE Compressed NO Tag TAG20100308T200144 Piece Name E APP FLASH_RECOVERY_AREA MMDEV1 BACKUPSET 2010_03_08 List of Datafiles in backup set 13 File LV Type Ckp SCN Ckp Time Name 1 Full 1760175 08-MAR-10 D ORADATA MMDEV1 2 Full 1760175 08-MAR-10 D ORADATA MMDEV1 3 Full 1760175 08-MAR-10 D ORADATA MMDEV1 4 Full 1760175 08-MAR-10 D ORADATA MMDEV1 BS Key Type LV Size Device Type Elapsed Time Completion Time 14 Full DISK 00 00 07 08-MAR-10 BP Key 14 Status AVAILABLE Compressed NO Tag TAG20100308T200144 Piece Name E APP FLASH_REC0VERY_AREA MMDEV1 BACKUPSET 2010_03_08 Chapter 6 Database Backup Restore and Recovery 153 SPFILE Included Modification time 08-MAR-10 SPFILE db_unique_name MMDEV1 Control File Included Ckp SCN 1760265 Ckp time 08-MAR-10 BS Key Type LV Size Device Type Elapsed Time Completion Time 15 Full DISK 00 00 06 12-MAR-10 BP Key 15 .

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên