DBAII_R1_1_Les08_E

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Configuring the Database Archiving Mode : 

Configuring the Database Archiving Mode

Objectives : 

Objectives After completing this lesson, you should be able to do the following: Describe the differences between ARCHIVELOG and NOARCHIVELOG modes Configure a database for ARCHIVELOG mode Enable automatic archiving Perform manual archiving of logs Configure multiple archive processes Configure multiple destinations, including remote destinations

Redo Log History : 

Online redo log files No redo history LGWR Redo history 054 053 052 Redo Log History 051 052

NOARCHIVELOG Mode : 

Online redo log files No redo history 053 LGWR 054 053 052 053 054 053 052 052 NOARCHIVELOG Mode

ARCHIVELOG Mode : 

ARCHIVELOG Mode 053 053 053 051 053 051 051 052 053 Archivedlog files Online redo log files LGWR 054 052 054 052 Redo history

Changing the Archiving Mode : 

Changing the Archiving Mode SHUTDOWN NORMAL/IMMEDIATE/TRANSACTIONAL 1 STARTUP MOUNT ALTER DATABASE ARCHIVELOG 3 ALTER DATABASE OPEN 4 5 2 Initialization parameters Control file Full database backup

Setting the Archiving Mode : 

Setting the Archiving Mode

Automatic and Manual Archiving : 

Automatic and Manual Archiving Automatic archiving: LOG_ARCHIVE_START=TRUE Manual archiving: LOG_ARCHIVE_START=FALSE DBA ARC0 053 053 053 053

Enabling Automatic Archiving : 

Enabling Automatic Archiving

Specifying Multiple ARCn Processes : 

Specifying Multiple ARCn Processes The dynamic parameter LOG_ARCHIVE_MAX_PROCESSES controls the number of archive processes started at instance startup. A maximum of ten ARCn processes can be specified. The number of ARCn processes can be changed with ALTER SYSTEM.

Stop or Start Additional Archive Processes : 

Stop or Start Additional Archive Processes LOG_ARCHIVE_MAX_PROCESSES=2 Archived redo logs 053 Online redo logs ARC0 ARC1 ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES = 3; ARC2 053 053

Enabling Automatic Archiving at Instance Startup : 

Enabling Automatic Archiving at Instance Startup 051 Archived log files 051 052 Archived Archived Current LOG_ARCHIVE_START=TRUE LOG_ARCHIVE_MAX_PROCESSES=n Online redo logs 051 052 052 051 ARC0 053

Enabling Automatic Archiving After Instance Startup : 

Enabling Automatic Archiving After Instance Startup ALTER SYSTEM ARCHIVE LOG START; 2 051 052 052 051 1 3 051 ARC0 Online redo logs

Disabling Automatic Archiving : 

ARC0 Disabling Automatic Archiving 1 2 ALTER SYSTEM ARCHIVE LOG STOP; LOG_ARCHIVE_START 051 052 Online redo logs 052 051 Initialization parameters

Manually Archiving Online Redo Log Files : 

Manually Archiving Online Redo Log Files 1 2 052 051 053 Online redo logs 051 052 ServerProcess ALTER SYSTEM ARCHIVE LOG CURRENT;

Manually Archive Redo Log Files : 

Manually Archive Redo Log Files

Specifying the Archive Log Destination : 

Specifying the Archive Log Destination Use LOG_ARCHIVE_DEST_n to specify up to ten archival destinations. Use LOG_ARCHIVE_FORMAT to include the log sequence number and thread number as part of the filename.

Specifying Multiple Archive Log Destinations : 

Specifying Multiple Archive Log Destinations Use LOG_ARCHIVE_DEST_n to specify up to ten archival destinations, which can be on a: Local disk Remote standby database log_archive_dest_1 = "LOCATION=/archive1" log_archive_dest_2 = "SERVICE=standby_db1"

LOG_ARCHIVE_DEST_n Options : 

LOG_ARCHIVE_DEST_n Options Set archive location as MANDATORY or OPTIONAL. Define time before retry in case of failures. log_archive_dest_1="LOCATION=/archive/ MANDATORY REOPEN" log_archive_dest_2="SERVICE=standby_db1 MANDATORY REOPEN=600" log_archive_dest_3="LOCATION=/archive2/ OPTIONAL"

Specifying a Minimum Number of Local Destinations : 

Specifying a Minimum Number of Local Destinations LOG_ARCHIVE_MIN_SUCCEED_DEST parameter An online redo log group can be reused only if: Archiving has been done to all mandatory locations The number of local locations archived is greater than or equal to the value of the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter LOG_ARCHIVE_MIN_SUCCEED_DEST = 2

Controlling Archiving to a Destination : 

Controlling Archiving to a Destination An archival destination can be disabled by using the dynamic initialization parameter LOG_ARCHIVE_DEST_STATE_n. Archiving to a destination can be enabled again. LOG_ARCHIVE_DEST_STATE_2 = DEFER LOG_ARCHIVE_DEST_STATE_2 = ENABLE ALTER SYSTEM SET log_archive_dest_state_3 = ENABLE; ALTER SYSTEM SET log_archive_dest_state_3 = DEFER;

Specifying the Filename Format : 

Specifying the Filename Format ARC0 LOG_ARCHIVE_DEST_n LOG_ARCHIVE_FORMAT /ORADATA/archive/ Archived log file arch%s.arc 052 Group 1 053 052 053 052 053 053 ARC0 052 Online redo log files Group 2

Obtaining Archive Log Information : 

Obtaining Archive Log Information V$ARCHIVE_DEST V$ARCHIVED_LOG V$LOG_HISTORY Dynamic Views Command Line ARCHIVE LOG LIST V$DATABASE V$ARCHIVE_PROCESSES

Summary : 

Summary In this lesson, you should have learned how to: Configure a database for ARCHIVELOG mode Enable automatic archiving Perform manual archiving of logs Configure multiple archive processes Configure multiple destinations

Practice 8 Overview : 

Practice 8 Overview This practice covers the following topics: Enabling and disabling automatic archiving Configuring multiple archiver processes Configuring multiple archiving destinations Performing manual archiving of redo log files

authorStream Live Help