Oracle7 Server Manager User's Guide

Library

Product

Contents

Index

Backing Up and Recovering the Database

This chapter describes how to use Server Manager to manage online backups, apply log files during recovery, and manage your redo log files. This chapter assumes that you have read Chapter 2, "Overview of the Administration Manager," and are familiar with the interface elements of the Administration Manager.

This chapter describes the commands available in the Recovery drawer's folders:

Backup

Recovery

Redo Logs

The Backup Folder

When you click the Backup folder tab, the Backup folder opens and the Backup object list and menu appear. The Backup folder object list displays the size and backup status of each tablespace in the database.

The following figure illustrates the Backup object list.

Figure 6 - 1. Backup Object List

Backup Object List

The columns of the Backup object list are described below:

Tablespace

Name of the tablespace.

Size (K)

Size of the tablespace (in kilobytes).

Backup Status

Status of the tablespace: ONLINE, Offline, or Ready for Backup (marked for online backup).

Started

Time the online tablespace backup started.

Starting or Ending an Online Backup

To prepare the datafiles of an online tablespace for backup, select the tablespace to be backed up and choose Start Online Backup from the Backup menu. In the Backup object list, the status of the tablespace changes to Ready for Backup.

Tablespaces that are offline can be backed up at any time, so there is no need to mark offline tablespaces for online backup.

After you have marked a tablespace as ready for backup, you can back up the datafiles that belong to the tablespace. You must back up the datafiles through your operating system. You can use the Datafiles folder in the Storage drawer to identify all datafiles belonging to a tablespace.

Attention: In order to perform an online backup, you must be operating in ARCHIVELOG mode. See the Oracle7 Server Administrator's Guide for information about ARCHIVELOG mode.

Additional Information: For information about performing backups on your operating system, see your platform-specific Oracle documentation.

Once you have completed your backup of the tablespace, mark the end of the backup. To mark the completion of an online tablespace backup, choose End Online Backup from the Backup menu.

Attention: If you forget to indicate the end of an online tablespace backup and subsequently shut down the database, Oracle assumes that media recovery is necessary at the next instance startup. Recovery may require the use of the archived redo log files.

The Recovery Folder

When you click the Recovery folder tab, the Recovery folder opens and the Recovery object list and menu appear. The Recovery object list displays information about archived log files needed for recovery. If no recovery is needed, the object list contains the message "No data found".

The following figure illustrates the Recovery object list.

Figure 6 - 2. Recovery Object List

Recovery Object List

The columns of the Recovery object list are described below:

Sequence

Sequence number of the archived log.

Time

Time at which the log was archived.

Archive Name

Name of the file when archived.

Applying a Log File

To apply archived redo log files during media recovery, choose Apply from the Recovery menu. The Apply Recovery Archives dialog box appears.

The following figure illustrates the Apply Recovery Archives dialog box.

Figure 6 - 3. Apply Recovery Archives Dialog Box

The Apply Recovery Archives dialog box is described below:

History

An output pane that displays prompts and status messages as recovery proceeds.

Next Archive File

Text entry field that displays the next archived log file to apply.

The Next Archive File field displays the default next log file. You can edit the name of the file or enter the name of a different file to apply.

Remaining Archives

Scrolling list that displays the archived redo logs that still need to be applied.

Save History

Saves the contents of the History pane to a file. Displays the standard file selection dialog box for your platform and allows you to specify the file.

Find Archive

Displays the standard file selection dialog box for your platform, and allows you to select a file to apply next.

Apply Next

Applies the file specified in the Next Archive File field.

Apply All

Applies all remaining archived redo log files. When the last log has been applied, the button's name changes to "Done".

Cancel

Stops the recovery operation. Database is recovered up through the last log file applied.

Additional Information: For information about the standard file selection dialog box for your system, see your operating system-specific documentation.

The Redo Logs Folder

The Redo Log object list displays information about the redo log files in the database. When you click the Redo Logs folder tab, the Redo Logs folder opens and the Redo Log object list and Redo menu appear.

The following figure illustrates the Redo Log object list.

Figure 6 - 4. Redo Log Object List

Redo Log Object List

The columns of the Redo Log object list are described below:

Member Filename

Name of the redo log file.

Group

Group number of the redo log group to which the log file belongs.

Status

Status of the redo log group: Current, Active, or Inactive.

Archived

Whether the redo log file has been archived.

Size (K)

Size of the redo log file (in kilobytes).

Sequence

Sequence number of the redo log group.

Adding a Log File Group

To add a new redo log group to your database, choose Add Logfile Group from the Redo menu. The Add Redo Logfile Group property sheet appears. The Add Redo Logfile Group property sheet consists of one page, called the Group Specification page.

The following figure illustrates the Add Redo Logfile Group property sheet.

Figure 6 - 5. Add Redo Logfile Group Property Sheet

Group Specification Page

The Group Specification page is described below:

Group Number

Group number for the redo log group.

The group number uniquely identifies the redo log group. Server Manager generates the default value automatically. You can enter a different group number in this field, if you desire.

Use existing file(s)

Allows Oracle to reuse existing file(s).

New file(s) size

Instructs Oracle to create new file(s).

Specify the size of the new file(s) in the New file(s) size field. Use the pop-up menu to specify kilobytes or megabytes.

Files scrolling list

Scrolling list of members to be included in the redo log group.

New

Displays the New Logfile dialog box and allows you to specify a member to add to the redo log group.

When you add a new member to the group, its name appears in the Files scrolling list. See "New Logfile Dialog Box" for a description of the New Logfile dialog box.

Edit

Displays the Edit Logfile dialog box.

Select the filename you wish to edit from the Files scrolling list and click Edit to edit the filename. See "Edit Logfile Dialog Box" for a description of the Edit Logfile dialog box.

Remove

Removes a member from the redo log group.

Select the member to be removed from the Files scrolling list and click Remove.

New Logfile Dialog Box

Use the New Logfile dialog box to specify the name of a log file to add to the redo log group. The following figure illustrates the New Logfile dialog box.

Figure 6 - 6. New Logfile Dialog Box

Enter the name of the new group member in the Filename text entry field. The file must be fully specified according to the conventions of your operating system. You can also click the Find File button to bring up the standard file selection dialog box for your platform.

Additional Information: For information about specifying filenames for your system, see your operating system-specific Oracle documentation.

Edit Logfile Dialog Box

Use the Edit Logfile dialog box to edit the name of a log file in a redo log group. The following figure illustrates the Edit Logfile dialog box.

Figure 6 - 7. Edit Logfile Dialog Box

You can edit the filename in the Filename field. You can also click the Find File button to bring up the standard file selection dialog box for your platform.

Dropping a Log File Group

To drop a redo log group, select a member of the group to be dropped from the Redo Log object list and choose Drop Logfile Group from the Redo menu. The Drop Logfile Group alert box appears.

The following figure illustrates the Drop Logfile Group alert box.

Figure 6 - 8. Drop Logfile Group Alert Box

Attention: Dropping a log file group drops all of its members. You cannot drop the active redo log group.

Adding a Log File Member

To add a new member to a redo log group, choose Add Logfile Member from the Redo menu. The Add Redo Logfile Member property sheet appears. The Add Redo Logfile Member property sheet consists of one page, called the Member Specification page.

The following figure illustrates the Add Redo Logfile Member property sheet.

Figure 6 - 9. Add Redo Logfile Member Property Sheet

Member Specification Page

The Member Specification page is described below:

Filename

Name of the file to add to the redo log group.

Enter the name of the file in the Filename field. The file must be fully specified according to the conventions of your operating system.

Find File

Displays the standard file selection dialog box for your platform.

Use Existing File

Allows Oracle to reuse an existing file.

New File

Instructs Oracle to create the specified file.

Group

Scrolling list of existing redo log groups.

To specify the new file's group, select the group number from the Group scrolling list.

Dropping a Log File Member

To drop a log file member from a redo log group, select the log file to be dropped from the Redo Log object list and choose Drop Logfile Member from the Redo menu. The Drop Logfile Member alert box appears.

The following figure illustrates the Drop Logfile Member alert box.

Figure 6 - 10. Drop Logfile Member Alert Box

Renaming a Log File Member

To rename a log file, select the log file to be renamed from the Redo Log object list and choose Rename Logfile Member from the Redo menu. The Rename Logfile Member dialog box appears. For information about renaming redo log files, see the Oracle7 Server Administrator's Guide.

The following figure illustrates the Rename Logfile Member dialog box.

Figure 6 - 11. Rename Logfile Member Dialog Box

The Rename Logfile Member menu command only renames the log file in the control file. It does not actually rename the file in your operating system. You must rename the file manually.

Additional Information: For information about renaming files on your system, see your operating system-specific Oracle documentation.

Forcing a Log Switch or a Checkpoint

To switch redo log groups, choose Switch Logfile from the Redo menu. The next redo log group becomes the current group.

To force a checkpoint, select Force Checkpoint from the Redo menu. During a checkpoint, all modified database buffers are written to the appropriate datafiles.

Prev Next

Library

Product

Contents

Index