Oracle Enterprise Manager Administrator's Guide Release 2.1 A75683-01 |
|
This chapter describes how to use the Oracle Enterprise Manager Backup Management wizards to administer your database backup and recovery environment.
The following topics are covered:
The Oracle Enterprise Manager Backup, Recovery, and Catalog Maintenance wizards, Backup Configuration Library, and the Create Backup Configuration property sheets are only available for Oracle8 and above databases.
The wizards provide a graphical user interface to Recovery Manager, an Oracle utility you use to back up, restore, and recover database files.
For more information on backup and recovery strategies, see your Oracle8i Backup and Recovery Guide.
The Backup Management wizards and property sheets consist of:
You can access the Backup Management wizards and property sheets using one of the following methods:
Note: The Backup Management wizards and property sheets are only available when you are connected to a Management Server.
The Backup Wizard provides an intuitive graphical user interface for the backup facility of Recovery Manager, an extremely powerful and flexible command line backup and recover utility designed for the Oracle8 and above databases. This wizard guides you through the entire backup process.
Before attempting to use the Backup Wizard, make sure the following requirements are met:
You can access the wizard through the Console and Storage Manager if you are connected to a Management Server.
For more information on backups and related strategies, see your Oracle8i Backup and Recovery Guide.
The Backup wizard helps you perform a backup of the various objects like database, datafiles, tablespaces, and archivelogs. It guides you through the process of specifying the backup strategy and submits a backup job through the Enterprise Manager to complete the operation.
A checkbox "Display this page next time" is available where you can specify not to show this page once you are familiar with the Backup Wizard. By default, the checkbox is selected. If you deselect the checkbox, the wizard starts on the Strategy Choice page the next time.
The Strategy Choice page allows you to specify whether you want to use a predefined backup strategy or customize your own. There are two options from which to choose:
After choosing your strategy choice, press Next to continue.
Proceed to Predefined Backup Strategy on page 8-5 if you have chosen Predefined Backup Strategy as your strategy choice.
Proceed to Customize Backup Strategy on page 8-8 if you have chosen Customize Backup Strategy as your strategy choice.
The following pages appear if you choose "Predefined backup strategy" as your strategy choice:
The Backup Frequency page allows you to specify how often you want to perform a backup and on which day of the week.
Choose the type of description that best fits your database.
Choose the backup day from the scroll-down list.
Choose the full backup day from the scroll-down list.
After choosing your backup frequency, press Next to continue. Proceed to Backup Wizard: Backup Time on page 8-6.
The Backup Time page allows you to specify the start time for performing the backup.
If your database is running in ARCHIVELOG mode, the backup is taken when the database is open. When you run a database in ARCHIVELOG mode, you allow Oracle to archive the online redo log. You can either perform the archiving manually or enable automatic archiving.
If the database is running in NOARCHIVELOG mode, the backup job closes the database, takes the backup, and then reopens the database. When you run your database in NOARCHIVELOG mode, you disable the archiving of the online redo log. The choice of whether to enable the archiving of filled groups of online redo log files depends on the availability and reliability requirements of the application running on the database.
Refer to the Oracle8i Backup and Recovery Guide for information on choosing between NOARCHIVELOG and ARCHIVELOG mode.
Refer to the Instance Manager online help for information on setting up backup modes.
After specifying your backup time, press Next to continue. Proceed to Backup Wizard: Configuration on page 8-6.
The Configuration page allows you to choose the configuration for backup and view the details that you have set up previously using the Create Backup Configuration option.
Allows you to choose a configuration you have previously set up using the Create Backup Configuration Property Pages.
The description of the configuration.
Refer to "Create Backup Configuration" on page 8-20 for information on creating a backup configuration.
After choosing your configuration, press Next to continue. Proceed to Backup Wizard: Multiple Destination on page 8-7.
The Multiple Destination page allows you to specify the destination database(s) to submit the job. You can select from the list of databases shown on the Available Databases window.
Move the selection(s) to and from the Available databases and Selected databases windows by using arrow buttons between them. By default, the database to which you are connected is shown in the Selected Databases window.
Note: To submit the same backup to multiple destinations, the databases must have the same structure and the same disk/tape configuration.
The Summary page appears when you click the Finish button. Information about the backup management job you just created using the Wizard is summarized before submission to the Oracle Enterprise Manager job system.
Clicking OK submits the job the Oracle Enterprise Manager job system.
Clicking Cancel returns you to the wizard.
Customize backup strategy allows you to elect the information you want to backup and the schedule for the execution of the backup.
Refer to the guidelines documented in the Oracle8i Backup and Recovery Guide.
Your database contains a wide variety of types of data. When developing your backup strategy, you must decide what information you want to backup. The basic principle you should use when deciding what to back up is to prioritize data depending on its importance and the degree to which it changes.
Note: If your database is in NOARCHIVELOG mode, you can only perform a full database backup. If the database is in NOARCHIVELOG mode and open at the time of the backup job, it is shut down during the backup, started in MOUNT mode, backed up, and then brought up once the backup is complete.
Choose from the following basic backup types:
Entire database backup contains the control file along with all database files that belong to a database. Whole database backups are the most common type of backup. This option backs up the whole database at once. If you operate in ARCHIVELOG mode, you also have the option of backing up different parts of the database over a period of time, thereby constructing a whole database backup piece by piece.
A tablespace backup is a backup of a subset of the database. Tablespace backups are only valid if the database is operating in ARCHIVELOG mode.
A datafile backup is a backup of a single datafile. Datafile backups, which are not as common as tablespace backups, are only valid if you run the database in ARCHIVELOG mode.
An archived redo log is an online redo log that Oracle has filled with redo entries, rendered inactive, and copied to one or more log archive destinations. Archive redo logs do not change, for example, but they are crucial for recovering your database, so you should maintain multiple copies if possible. This option is available only in ARCHIVELOG mode.
After choosing your backup type, press Next to continue.
Proceed to Backup Wizard: Archive Logs on page 8-10 if you have chosen Entire database or Archive Logs as your backup type.
Proceed to Backup Wizard: Tablespaces on page 8-9 if you have chosen Tablespace as your backup type.
Proceed to Backup Wizard: Datafiles on page 8-9 if you have chosen Datafiles as your backup type.
You can submit a backup job directly from the Job System, but the recommended method is through the wizard.
Note: If the database was OPEN and in ARCHIVELOG MODE when the backup job was created and the database is in MOUNT state when the job runs; then, the backup job will fail because of "Alter System Switch Logs."
A tablespace backup is a backup of a subset of the database. Tablespace backups are generally valid if the database is operating in ARCHIVELOG mode.
The Tablespace page allows you to select the tablespaces you want to back up. Choose from the list of tablespaces shown on the Available Tablespaces window.
Move the selection(s) to and from the Available Tablespaces and Selected Tablespaces windows by using arrow buttons between them.
You may choose to include the control files with the backup.
After selecting the tablespaces you want to back up, press Next to continue.
Proceed to Backup Wizard: Archive Logs on page 8-10.
A datafile backup is the backup of a single datafile. Datafile backups, which are not as common as tablespace backups, are only valid if you run the database in ARCHIVELOG mode.
The Datafiles page allows you to select the datafiles you want to back up. Choose from the list of datafiles shown on the Available Datafiles window. Full path and name of the datafile are shown.
Move the selection(s) to and from the Available Datafiles and Selected Datafiles windows by using arrow buttons between them.
You may choose to include the control files with the backup.
After selecting the datafiles you want to back up, press Next to continue.
Proceed to Backup Wizard: Archive Logs on page 8-10.
The Archive Logs page allows you to specify the following options:
Date and time for the first archive logs to backup. These fields are enabled when you select "Yes, selected archive logs."
Archive date and time for the last archive logs to backup. These fields are enabled when you select "Yes, selected archive logs."
Deleting archive logs saves space.
An archived redo log is an online redo log that Oracle has filled with redo entries, rendered inactive, and copied to one or more log archive destinations. Archive redo logs do not change, for example, but they are crucial for recovering your database, so you should maintain multiple copies if possible.
After specifying the archive log options, press Next to continue.
Proceed to Backup Wizard: Backup Options on page 8-11 if you have chosen Entire database, Tablespace, or Datafile as your backup type.
Proceed to Backup Wizard: Configuration on page 8-12 if you have chosen Archive Logs as your backup type.
The Backup Options page allows you to choose from a full or an incremental backup.
A full backup backs up all blocks into the backup set, skipping only datafile blocks that have never been used. The server process does not skip blocks when backing up archived redo logs or control files.
A full backup has no effect on subsequent incremental backups, which is why it is not considered part of the incremental strategy. In other words, a full backup does not affect which blocks are included in subsequent incremental backups.
Incremental backups are a method by which you only backup modified blocks. An incremental level 0 backup, performs the same function as a full backup in that they both backup all blocks that have ever been used except a level 0 will affect what blocks are copied out by subsequent incremental backups.
Incremental backups of levels greater than 0 back up only blocks that have changed since previous incremental backups. Blocks which have not changed will not be backed up.
A type of incremental backup in which you back up all blocks that have changed since the most recent backup at level n or lower. For example, in a differential level 2 backup you back up all blocks modified since the last level 2, level 1, or level 0 backup.
A non-cumulative backup copies less data and therefore takes a shorter time than the cumulative backup, but recovery time is longer.
A type of incremental backup that allows you to back up all the blocks used since the most recent backup at level n-1 or lower. For example, in a cumulative level 2 backup you back up all blocks used since the most recent level 1 or level 0 backup.
A cumulative backup copies more data and therefore takes longer than the non-cumulative backup, but recovery time is shorter.
Proceed to Backup Wizard: Configuration on page 8-12 if you have chosen your backup option.
The Configuration page allows you to choose the configuration for backup and view the details that you have set up previously using the Create Backup Configuration option.
Allows you to choose a configuration you have previously set up using the Create Backup Configuration Property Pages.
The description of the configuration.
After choosing your configuration, press Next to continue. Proceed to Backup Wizard: Schedule on page 8-12.
The Schedule page enables you to schedule the execution of a backup.
Select the frequency of backup. The choices are Immediately, Once, On Interval, On Day of Week, and On Date of Month.
Note: If you choose a day, such as 31, that is not in a month, the job will not be run in that month. Choose the first day of the month.
Choose the first date and time that you want the task executed. This is the starting time for any task scheduled on an interval.
Choose the last date and time that you want the task executed. This option does not apply if you chose the Immediately or Once execution options.
Shows the time zone. The agent schedules the task execution at each destination based on the actual system time of each agent. Tasks are not necessarily run simultaneously.
The Run on Multiple databases option allows you to access the Multiple Destination page so that you can specify the destination database(s) to submit the job.
After specifying the scheduling options, press Next to continue.
Proceed to Backup Wizard: Job Information on page 8-14.
The Job Information page allows you to specify the name and description for the backup job and what you would like to do with the job as it will appear in the Oracle Enterprise Manager Console Job System.
The choices for what to do with the job are listed below:
You can view the status of the job by selecting the Active and History page tabs in the Console's Job window.
The Summary page appears when you click the Finish button. Information about the backup management job you just created using the Wizard is summarized before submission to the Oracle Enterprise Manager job system.
Clicking OK submits the job the Oracle Enterprise Manager job system.
The Recovery wizard helps you restore and recover various objects like databases, datafiles, and tablespaces.
Before attempting to use the Recovery Wizard, make sure the following requirements are met:
You can access the wizard through the Console and Storage Manager if you are connected to a Management Server.
Note: You can submit a recovery job directly from the Job System, but the recommended method is through the wizard.
The Recovery Wizard guides you through the process of specifying what you want to restore and recover and submits a recovery job through the Enterprise Manager to complete the operation.
A checkbox "Display this page next time" is available where you can specify not to show this page once you are familiar with the Recovery Wizard. By default, the checkbox is selected. If you deselect the checkbox, the wizard starts on the Recovery Selection page the next time.
Press Next to continue. Proceed to Recovery Wizard: Recovery Selection on page 8-16.
The Recovery Selection page of the Recovery Wizard allows you to select from the following types of recovery operations:
Note: If the database is mounted, but not open, all three options are available.
If the database is open and in ARCHIVELOG MODE, only tablespaces and datafiles are available.
The type of recovery you select determines which procedure the Restore Wizard guides you through.
Note: Depending on the status of the target database (ARCHIVELOG, NOARCHIVELOG, mounted and open, mounted only, or started), some options will be disabled or not displayed.
For more information on recovery operations and related strategies, see the Oracle8i Administrator's Guide or the Oracle8i Backup and Recovery Guide.
A recovery of an entire database is a recovery of all database files that belong to a database. This selection only appears if the database is in the "MOUNT" state.
Note: Use Instance Manager or the Console to open the database once 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.
A tablespace recovery is a recovery of a subset of the database. Tablespace recoveries are generally valid if the database is operating in ARCHIVELOG mode.
A datafile recovery is a recovery of a single datafile. Datafile backups, which are not as common as tablespace recoveries, are generally valid if you run the database in ARCHIVELOG mode.
Note: If you are in NOARCHIVELOG mode, your database must be mounted in order to perform a restore. To perform a full database recovery, your database must be in the MOUNTED mode. Use Instance Manager 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.
A checkbox "Perform recovery without restoring the datafiles" is available. By default, the checkbox is deselected. If you select the checkbox, a recover is performed without a restore. The Rename page will not appear if you have selected the "Perform recovery without restoring the datafiles" option.
Use the "Perform recovery without restoring the datafiles" option if the datafile exists and is not corrupted and the database only requires to recover (apply the redo logs) to the datafile.
After choosing your recovery selection, press Next to continue.
Proceed to Recovery Wizard: Restore Until on page 8-17 if you have chosen Entire database as your recovery selection.
Proceed to Recovery Wizard: Tablespaces Page on page 8-17 if you have chosen Tablespace as your recovery selection.
Proceed to Recovery Wizard: Datafiles Page on page 8-18 if you have chosen Datafiles as your recovery selection.
If you press the Finish button now, the database will be restored to the most recent time possible.
If you want to restore to a point previous to now, then you must check the Until checkbox and enter a date and time when the date and time fields are activated.
Note: Use Instance Manager 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.
This feature is available if your database is in the MOUNTED mode.
Press Next to continue. Proceed to Recovery Wizard: Rename Page on page 8-18.
A tablespace backup is a backup of a subset of the database. Tablespace backups are generally valid if the database is operating in ARCHIVELOG mode.
The Tablespace page allows you to select the tablespaces you want to recover. Choose from the list of tablespaces shown on the Available Tablespaces window.
Note: Tablespaces are displayed with a different icon if they require recovery.
Move the selection(s) to and from the Available Tablespaces and Selected Tablespaces windows by using arrow buttons between them.
Press Next to continue. Proceed to Recovery Wizard: Rename Page on page 8-18.
A datafile recovery is the recovery of a single datafile. Datafile recoveries, which are not as common as tablespace recoveries, are generally valid if you run the database in ARCHIVELOG mode.
The Datafiles page allows you to select the datafiles you want to recover. Datafiles which require recovery are displayed with a different icon. Choose from the list of datafiles shown on the Available Datafiles window. Full path and name of the datafile are shown.
Move the selection(s) to and from the Available Datafiles and Selected Datafiles windows by using arrow buttons between them.
You may choose to include the control files with the recovery.
Press Next to continue. Proceed to Recovery Wizard: Rename Page on page 8-18.
The Rename page enables you to restore the selected datafile(s) to a new location. When datafiles are restored to a new location, they are considered datafile copies. For this reason, a switch is automatically performed.
The full path and filename of the selected datafile(s). This field is not editable.
Enter a new filename and/or a new path.
You can copy all or sections of the Original Name entry and paste it into the New Name field by highlighting the desired text and selecting the desired action from the context-sensitive right mouse menu.
Press Next to continue. Proceed to Recovery Wizard: Configuration Page on page 8-19.
The Configuration page allows you to choose the configuration for recovery and view the details that you have set up previously using the Create Backup Configuration option.
Allows you to choose a configuration you have previously set up using the Create Backup Configuration Property Pages.
The description of the configuration.
The Summary page appears when you click the Finish button. Information about the backup management job you just created using the Wizard is summarized before submission to the Oracle Enterprise Manager job system.
Clicking OK submits the job the Oracle Enterprise Manager job system.
Clicking Cancel returns you to the wizard.
A configuration is a set of defaults you set up for backup and recovery. You can use the configuration for one database or many databases depending if the systems are the same.
Before attempting to use the Oracle Enterprise Manager Backup Management wizards, make sure the following requirements are met:
You can access the wizards through the Console and Storage Manager if you are connected to a Management Server.
The General page allows you to give a name and description to a set of defaults used for backup, recovery, and catalog maintenance operations.
You can access the wizards through the Console and Storage Manager if you are connected to a Management Server.
The Channels page allows you to specify a channel or channels. A channel is an output device for backup and restore operations. Multiple channels can be created to allow parallel backup/recovery by a single job.
Note: At least one channel must exist before performing a backup, restore, or recover operation.
Attention: Oracle8 can only allocate one Recovery Manager channel at a time, thus limiting the parallelism to one stream. The Oracle8 Enterprise Edition allows unlimited parallelism. See the Oracle8i Installation Guide for Windows NT and the Oracle8i Administrator's Guide for Windows NT for more information about the features available with Oracle8i and Oracle8i Enterprise Edition.
Select from one of the following types:
Note: You can have multiple channels, but the channels defined must have the same type of destination.
User-specified name of the channel.
Note: If you want to backup multiple databases on the same machine using the same configuration, you must use %u in the format string in the configuration.
Unique backup set name. The following parameters can be used:
Note: If you want to backup multiple databases on the same machine using the same configuration, you must use %u in the format string in the configuration.
Drive and path where backup sets are stored. The Directory field is active when channel type is set to Disk.
Parameters regarding the device to allocate. The Parameters field is active when channel type is set to Tape. For information on parms
parameter, see the Oracle8i Backup and Recovery Guide.
Press the Limits button to access the Limits page in order to set the limits for any backup.
Allows you to create another channel definition.
Note: The channels defined must have the same type of destination.
Deletes the selected channel.
The Limits page allows you to set the limits for any backup or copy operation. For any setting, you move the slider bar to change its value or type in the value. The number in the field changes according to the position of the slider bar.
When checked, it allows you set the maximum number of megabytes that a backup operation can write to a single backup piece.
When checked, it allows you to control the number of blocks per second read by a backup or copy operation from or to any input datafile. Controlling the read rate ensures that a backup or copy operation does not consume excessive disk bandwidth, which can degrade online performance.
When checked, it allows you to control the maximum number of input files that a backup operation can have open simultaneously. Setting maximum number of open files is particularly useful when backing up a large number of archivelogs into a single backup set.
The Recovery Catalog page allows you to choose where you want the backup information to be stored.
The recovery catalog contains the following information:
The choices are listed below.
The target database's control file. For information regarding the pros and cons of using a recovery catalog rather than a control file, see the Oracle8i Backup and Recovery Guide.
A repository of information that is used and maintained by the Recovery Manager. For information regarding the pros and cons of using a recovery catalog rather than a control file, see the Oracle8i Backup and Recovery Guide.
A user which contains the schema for the recovery catalog.
The password of the user which contains the schema for the recovery catalog.
The service name of the database where the recovery catalog resides.
If you have chosen to use a recovery catalog and clicked OK, the Create Backup Configuration checks that:
Important: The recovery catalog and the Oracle Enterprise Manager repository should not reside in the target database (database to be backed up). The recovery catalog can reside in the same database as your Oracle Enterprise Manager repository. Oracle recommends placing the recovery catalog in a separate tablespace. As with any important data, you should back up your recovery catalog regularly.
See the Oracle8i Backup and Recovery Guide for information on operating with a recovery catalog.
See the Oracle Enterprise Manager Configuration Guide for complete information on setup and configuration.
The Backup Parameters page allows you to set storage parameters for the current backup set.
Check the "Override Recovery Manager defaults" box to use this page to override the Recovery Manager default settings that the Recovery Manager has calculated.
When checked, it allows you to set the maximum number of files that can be placed in a single backup set. If the number of files selected for the current backup exceed this number, multiple backup sets are created. In addition, multiple channels, if defined and available, will also be used.
When checked, it allows you to set the maximum file size of a backup set. You can specify file size in megabytes or kilobytes. Specifying a set size for backup sets permits better load balancing when performing backups.
When checked, it allows you to set the maximum file size of a backup set for archivelogs. You can specify file size in megabytes or kilobytes. Specifying a set size for backup for archivelogs permits better load balancing when performing backups.
The Preferred Credentials page allows you to specify preferred credentials for running backup jobs. These configurations will take precedence over the preferred credentials set in the Console.
Use Preferred Credentials if you do not want to set the login credentials to SYSDBA in the Console. These credentials will only be used for backup and recovery jobs.
If you want to configure your database for remote sysdba operation, see "Configuring a Remote Database for Backup or SYSDBA Administration" on page 8-31.
Note: The Backup Configuration you have set become your default backup configuration if you use the Backup and Recovery wizards and submit a job.
The Catalog Maintenance wizard helps you perform basic recovery catalog operations like register the database, reset the database, and re-synchronize the catalog.
Before attempting to use the Catalog Maintenance wizard, make sure the following requirements are met:
The recovery catalog is a separate database normally residing on a remote system that contains information about the structure and previous backups of the target database.
One recovery catalog can manage many databases. It is recommended that you use resync catalog for every database that uses a recovery catalog on a regular basis.
Note: You can submit a catalog maintenance job directly from the Job System, but the recommended method is through the wizard.
The Catalog Maintenance wizard guides you through the process of defining the recovery catalog operation and submits a catalog maintenance job through the Enterprise Manager to complete the operation.
A checkbox "Display this page next time" is available where you can specify not to show this page once you are familiar with the Catalog Maintenance Wizard. By default, the checkbox is selected. If you deselect the checkbox, the wizard starts on the Operation Choice page the next time.
You can view the status of the job by selecting the Active and History page tabs in the Console's Job window.
Press Next to continue. The Catalog Maintenance Wizard: Operation Choice Page appears.
The Operation Choice page allows you to manage the recovery catalog.
In order for the Backup wizard to use the recovery catalog, the database must be registered first.
Register the target database with the Recovery Catalog. The target database must be registered with the Recovery Catalog before the Backup wizard can use it. You only need to register the database once.
Re-synchronizes the Recovery Catalog with the target database so that the recovery catalog is updated with current information from the control file of the target database. The recovery catalog must be periodically resynced from the target database in order to ensure the catalog is up-to-date. The recovery catalog is not updated automatically when a log switch occurs or when an log is archived. Also, any structural changes to the target database would require re-synchronization of the Recovery Catalog.
Depending on how often your target database structure changes (including archive logs), you must decide how often to resynchronize the catalog. It is recommended that you should resynchronize the catalog at least once a day. If your site generates many archived logs each day, then you should resynchronize the catalog more frequently.
Reset the Recovery Catalog for the target database. Resetting the database is rarely performed and should only be done if all the information has been lost. You must reset the recovery catalog if the target database had been previously opened with the RESETLOGS option. Refer to the "Coordinating Time-Based and Change-Based Distributed Database Recovery" section of the Oracle8i Backup and Recovery Guide for information on the RESETLOGS option.
Press Next to continue. The Catalog Maintenance Wizard: Configuration Page appears.
The Configuration page allows you to choose the configuration which has the recovery catalog information that you have set up previously using the Create Backup Configuration option.
Allows you to choose a configuration you have previously set up using the Create Backup Configuration Property Pages.
The description of the configuration.
For users registering a database or resynchronizing a catalog, press Next continue.
Proceed to Catalog Maintenance Wizard: Multiple Destinations Page on page 8-27 if you have chosen to register a database.
Proceed to Catalog Maintenance Wizard: Schedule on page 8-28 if you have chosen to resynchronize the catalog.
For users resetting the database, press Finish to submit a catalog maintenance job through the Enterprise Manager to complete the operation.
The Multiple Destination page allows you to specify the destination database(s) to submit the job. You can select from the list of databases shown on the Available Databases window.
Move the selection(s) to and from the Available databases and Selected databases windows by using arrow buttons between them. By default, the database to which you are connected is shown in the Selected Databases window.
Press Finish to submit a catalog maintenance job through the Enterprise Manager to complete the operation.
The Schedule page enables you to schedule the execution of a catalog maintenance job.
Select the frequency of catalog maintenance job. The choices are Immediately, Once, On Interval, On Day of Week, and On Date of Month.
Note: If you choose a day, such as 31, that is not in a month, the job will not be run in that month. Choose the first day of the next month instead.
Choose the first date and time that you want the task executed. This is the starting time for any task scheduled on an interval.
Choose the last date and time that you want the task executed. This option does not apply if you chose the Immediately or Once execution options.
Shows the time zone. The agent schedules the task execution at each destination based on the actual system time of each agent. Tasks are not necessarily run simultaneously.
The Run on Multiple databases option allows you to access the Multiple Destination page so that you can specify the destination database(s) to submit the job.
After specifying the scheduling options, press Next to continue.
Proceed to Catalog Maintenance Wizard: Multiple Destinations Page on page 8-27.
The Summary page appears when you click the Finish button. Information about the backup management job you just created using the Wizard is summarized before submission to the Oracle Enterprise Manager job system.
Clicking OK submits the job the Oracle Enterprise Manager job system.
The Backup Configuration Library page displays configurations created and saved using the Backup Configuration option.
Name: The name of the configuration
Description: The description of the configuration
Use Recovery Catalog: Whether the configuration uses a recovery catalog
This is useful if you want to perform the following tasks:
Double-click an entry in the Backup Configuration Library list to start the Backup Configuration option with the stored parameters.
Before using one of the backup management wizards or starting up or shutting down a database through Oracle Enterprise Manager, you need to set up your database for remote sysdba management.
The following procedure outlines the operations you may need to perform on both the server and client if they have not been performed already through the Database Configuration Assistant.
Refer to the operating system-specific documentation for your Oracle database for the exact name of the password file creation utility for your system.
$ORACLE_HOME/bin/orapwd file=<fname> password=<password> entries=<users>
where
fname is the name of password file (mandatory),
password is the password for SYS (mandatory),
entries is the maximum number of distinct DBAs and OPERs (optional),
There are no spaces around the equal-to (=) character.
The <fname>
will be created in the Oracle_Home/Database
directory.
Oracle_Home/Admin/<SID>/pfile
directory. Add or change the following parameter remote_login_passwordfile=exclusive
in the init.ora file.
setenv ORACLE_HOME your_oracle_home
setenv ORACLE_SID your_oracle_sid
dbs
directory in your Oracle home.
cd $ORACLE_HOME/dbs
$ORACLE_HOME/bin/orapwd file=<fname> password=<password> entries=<users>
where
fname is the name of password file (mandatory),
password is the password for SYS (mandatory),
entries is the maximum number of distinct DBAs and OPERs (optional),
There are no spaces around the equal-to (=) character.
The <fname>
will be created in the $Oracle_Home/dbs
directory.
remote_login_passwordfile=exclusive
in the init.ora file.
The recovery catalog is a repository of information that is used and maintained by Recovery Manager. Recovery Manager uses the information in the recovery catalog to determine how to execute requested backup and restore actions.
Because most of this information is also available from the target database's control file, you have the option of using the control file instead of creating a recovery catalog. This operational mode is appropriate for small databases. No setup is required if you are using the control file. However, Oracle recommends using a recovery catalog. If the control file is lost, the database cannot be recovered.
To use Oracle8i Recovery Manager with a recovery catalog, you must first install the recovery catalog and then register your database. It is recommended that you install the recovery catalog on a different location than the target database.
For more information on recovery catalog maintenance, Recovery Manager, and backup and recovery strategies, see the Oracle8i Backup and Recovery Guide.
Your Oracle Enterprise Manager Job system must be functioning properly before attempting to install the recovery catalog. You will need the Job system to register the target database in the recovery catalog.
To set up a recovery catalog, you must complete the following procedures:
catrman
Script (for pre-8i only)
rcvcat
.
c:\orant\oradata\rcvcat01.dbf
.
In the Name field, enter the name of the new user. For example, rman
.
In the Password and Confirm Password fields, enter a password. For example, rman
.
Choose the default tablespace. For example, RCVCAT
.
Choose the temporary tablespace. For example, TEMPORARY_DATA or TEMP.
RCVCAT
.
rman
, password=rman
.
catrman
script located in the Oracle_Home/rdbms/admin
or Oracle_Home\rdbms\admin
directory.
If you are using SQL*Plus Worksheet, type @<full pathname and name of script>
in the SQL*Plus Worksheet input panel and press the Execute button. For example, type @<Oracle_Home>/rdbms/admin/catrman
and press the Execute button.
%> rman rcvcat rman/rman@<service name for database>
The correct output is shown below:
RMAN-06008: connected to recovery catalog database RMAN-06428: recover catalog is not installed
To register the recovery catalog for the first time, follow the steps 1 through 7.
Choose "in a recovery catalog" as where you want your backup information stored.
In the Username field, enter the name of the user. For example, rman
.
In the Password field, enter a password. For example, rman
.
In the Service field, enter the database where the Recovery Catalog resides.
To use the same configuration on subsequent databases, follow steps 8 through 16.
When the job completes successfully, your backup and recovery environment is configured. For more information on recovery catalog maintenance, Recovery Manager, and backup and recovery strategies, see the Oracle8i Backup and Recovery Guide.
If you do no want to maintain a recovery catalog, then you can drop the recovery catalog schema from the tablespace in 8i. The drop catalog command deletes all information from the recovery catalog. Hence, if you have no backups of the recovery catalog schema, then all backups of all target databases managed by this catalog become unusable.
The drop catalog command is not appropriate for "unregistering" a single database from a catalog that has multiple target databases registered. If you try to delete the information for one target database by dropping the catalog, you thereby delete the information for all target databases.
To drop the recovery catalog schema:
%> rman rcvcat rman/rman@rcvcat
RMAN> drop catalog
For drop catalog command syntax, see the Oracle8i Backup and Recovery Guide.
If you use a version of the recovery catalog that is older than that required by the RMAN executable, then you must upgrade it. For example, you must upgrade the catalog if you use an Oracle8i RMAN with an Oracle8i recovery catalog.
Note: You will receive an error if the recovery catalog is already at a version greater than that required by the RMAN executable. RMAN permits the command to be run if the recovery catalog is current, however, so that you can re-create packages if necessary. Check the message log for error messages generated during the upgrade.
To upgrade the recovery catalog:
%> rman rcvcat rman/rman@rcvcat RMAN-06008: connected to recovery catalog database RMAN-06186: PL/SQL package rcat.DBMS_RCVCAT version 08.00.04 in RCVCAT database is too old
RMAN> upgrade catalog RMAN-06435: recovery catalog owner is rman RMAN-06442: enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog RMAN-06408: recovery catalog upgraded to version 08.01.05
For upgrade catalog command syntax, see the Oracle8i Backup and Recovery Guide.
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|