Oracle Database Reference guide has a table listing all commands. And since You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. E Email: sher hotmail. This entry was posted in Performance and Tuning , scripts. Bookmark the permalink.
March 23, at pm. Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Search for:. Blog at WordPress. Follow Following. Sign me up. At this level, the archivelog process generates appropriate alert and trace entries for error conditions.
For example:. You can display information about the archived redo logs using the following sources:. Several dynamic performance views contain useful information about archived redo logs, as summarized in the following table.
This display tells you all the necessary information regarding the archived redo log settings for the current instance:. What Is the Archived Redo Log? The archiving of filled groups has these advantages: A database backup, together with online and archived redo log files, guarantees that you can recover all committed transactions in the event of an operating system or disk failure.
Controlling Archiving This section describes how to set the archiving mode of the database and how to control the archiving process. Back up the database. Start a new instance and mount, but do not open, the database. Performing Manual Archiving To operate your database in manual archiving mode, follow the procedure shown in "Changing the Database Archiving Mode".
Specifying the Archive Destination Before you can archive redo logs, you must determine the destination to which you will archive and familiarize yourself with the various destination states. The following topics are contained in this section: Specifying Archive Destinations Understanding Archive Destination Status Specifying Archive Destinations You can choose whether to archive redo logs to a single destination or multiplex them.
The default for this parameter is operating system dependent. Specifying the Mode of Log Transmission The two modes of transmitting archived logs to their destination are normal archiving transmission and standby transmission mode. Normal Transmission Mode In normal transmission mode, the archiving destination is another disk drive of the database server.
Standby Transmission Mode In standby transmission mode, the archiving destination is either a local or remote standby database. Caution: You can maintain a standby database on a local disk, but Oracle strongly encourages you to maximize disaster protection by maintaining your standby database at a remote site.
Managing Archive Destination Failure Sometimes archive destinations can fail, causing problems when you operate in automatic archiving mode. No destination is a standby database. In this situation, consider the following options: Archive manually to the failed destination.
Drop the destination. When using the REOPEN keyword, note the following: ARC n reopens a destination only when starting an archive operation from the beginning of the log file, never during a current operation. Controlling Trace Output Generated by the Archivelog Process Background processes always write to a trace file when appropriate.
The following values can be specified: Trace Level Meaning 0 Disable archivelog tracing. This is the default. See Also: Oracle Data Guard Concepts and Administration for information about using this parameter with a standby database.
See Also: Oracle Database Reference for detailed descriptions of dynamic performance views. Automatic archiving is enabled. The oldest filled redo log group has a sequence number of The next filled redo log group to archive has a sequence number of The current redo log file has a sequence number of Remote archival through Oracle Net service name.
The user has properly initialized the destination, which is available for archiving. The user has not provided or has deleted the destination information. An error occurred creating or writing to the destination file; refer to error data. The user manually and temporarily disabled the destination. A parameter error occurred; refer to error data. Disable archivelog tracing. Track archival status for each archivelog destination. Track detailed archivelog destination activity.
Track archivelog destination parameter modifications. Track ARC n process state activity. Track FAL fetch archived log server related activities. Displays historical archived log information from the control file. Describes the current instance, all archive destinations, and the current value, mode, and status of these destinations. Displays information about the state of the various archive processes for an instance.
Contains information about any backups of archived logs. Displays all redo log groups for the database and indicates which need to be archived. Contains log history information such as which logs have been archived and the SCN range for each archived log.
0コメント