HP 3PAR Recovery Manager 4.2.0 Software for Oracle User’s Guide Abstract This document provides the information needed to install, configure, and use the HP 3PAR Recovery Manager 4.2.0 Software for Oracle on Solaris, Red Hat Linux, Oracle Linux, and HP UX. This document is for system administrators and database administrators who are responsible for backing up databases and who understand Sun™ Solaris™ and/or Linux and/or HP UX, and are familiar with the Oracle10g™ and Oracle11g™ Databases.
© Copyright 2012 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents 1 Overview of Recovery Manager Operations..................................................7 Virtual Copies..........................................................................................................................7 About the Recovery Manager for Oracle Repository......................................................................7 Interacting with Oracle..............................................................................................................
3 Configuring Recovery Manager for Oracle..................................................31 Setting Up SSH Connections for Recovery Manager....................................................................31 SSH Restrictions.................................................................................................................32 Modifying the SSH Daemon Configuration............................................................................32 Generating an SSH Key Pair for the Backup Server...
Using the Recovery Manager for Oracle Graphical User Interface..................88 Starting and Stopping the Recovery Manager for Oracle GUI......................................................88 Starting the GUI................................................................................................................88 Stopping the GUI...............................................................................................................88 Creating Configuration Files........................
Systems and Software Configurations......................................................................................107 Configuration Diagram.....................................................................................................108 Preparing for Remote Copy Operation.....................................................................................108 Recovering to the Synchronous Backup System when the Local System is Unavailable.....................
1 Overview of Recovery Manager Operations Recovery Manager for Oracle offers a specific data protection solution that has been enhanced to provide rapid online recovery from space-efficient online point-in-time snapshots of an Oracle database. Further, Recovery Manager for Oracle enables off-host backup of an Oracle database to tape, minimizing any impact to the production Oracle server.
The following example displays the location of the Recovery Manager for Oracle repository on the backup server for Oracle database instance test that is running on database server Host1. /etc/3par/solutions/Host1.ora.test If the database is a Real Application Cluster (RAC) database, there will be multiple repositories, one for each RAC instance.
Database log mode Automatic archival Archive destination Oldest online log sequence Next log sequence to archive Current log sequence Archive Mode Enabled /rac9i_db/rac9i_arch2 764 764 765 Oracle standby databases are supported. An Oracle standby database is a synchronized copy of the production database. The following are required for standby database support: • Only Oracle 10g and 11g are supported. • A standby database must be a physical database.
NetBackup Policies for NBU (User-Managed) Backup” (page 39) or “Setting Up NetBackup Policies for Oracle RMAN Backup” (page 41) for detailed information). Recovery Manager for Oracle Utilities Read this section for general information regarding HP 3PAR Recovery Manager for Oracle utilities available through the Recovery Manager for Oracle command line interface and graphical user interface.
When creating an online virtual copy, the create utility performs the following actions: • Discovers devices (3PAR virtual volumes) used by the datafiles and archive log destination. • Puts the database in backup mode. • Creates a virtual copy for the datafile virtual volumes. • Takes the database out of backup mode. • Switches online redo logs and archives them to archive log destination.
• A Datafile virtual copy indicates that the virtual copy for the database was created while it was OPEN (online) and contains only datafiles (no archive log destination). • An Archlog virtual copy indicates that the virtual copy was created for archive log destination only. A virtual copy's status can be either Available, Removed, Mounted, Mounted(P), or Database. • Available status indicates that the virtual copy exists and is not currently mounted or cloned.
NOTE: The ASM major release version on the backup server must be higher than the ASM major release version on the database server. • On Linux systems, if the database files reside on OCFS2 1.4.1 or above file systems, Recovery Manager for Oracle supports multiple virtual copies per database being mounted at the same time. For versions lower than OCFS2 1.4.1, only one virtual copy per database can be mounted at any time on the backup server.
• Deports the read-write virtual copy from the backup server. • Removes the read-write virtual copy. The Virtual Copy Export Utility HP 3PAR Recovery Manager Software for Oracle’s virtual copy export utility exports an existing virtual copy to an alternate backup server (rmora_export command). The exported virtual copy can then be mounted, backed up or cloned at the alternate backup server. The virtual copy must have Available status in order to be exported.
• The number of multiplex redo log locations must be equal to, or less than, the original database when creating the clone database. Otherwise, the extra redo log multiplex location will be ignored. • If the locations of the redo logs and control files are not specified, they will be created at the repository location for the virtual copy (/etc/3par/solutions/.ora./).
There are a few ways to enforce the retention time for read-only virtual copies. • During configuration, the retention value specified will be the default value for new read-only virtual copies created via rmora_create, rmora_rsync, and rmora_backup (without the -t option). • Use rmora_create -r or rmora_rsync -r to override the default value specified during configuration. • Use the rmora_set command for the specified virtual copy to extend its retention time.
The Database Rollback Utility HP 3PAR Recovery Manager Software for Oracle’s database rollback utility (rmora_rollback) promotes a virtual copy's volumes back to its base virtual volumes. In other words, the base virtual volumes used by the database are rolled back to the virtual copy volumes. Once the rollback process completes successfully, the base virtual volumes are exactly the same as the virtual copy volumes.
backup or Oracle RMAN backup). However, incremental (differential or cumulative) backup of a whole Oracle database is only available using Oracle RMAN backup. Incremental (differential or cumulative) backup of archive log destination is only available for the NBU (user-managed) backup method. The following restrictions apply when backing up a database using the Recovery Manager for Oracle database backup utility.
NOTE: The RMAN backup scripts (rmora_rman_dbbackup.sh and rmora_rman_archbackup.sh) are generated at /etc/3par/solutions/.ora. during the creation of the Recovery Manager Configuration file. Automatic Backup NOTE: NBU automatic backup can be used when Recovery Manager for Oracle is configured to run as either root user or Oracle owner.
For an RAC database, archive log destinations of all RAC instances must be on shared storage (same cluster file systems or same ASM disk groups). The Database Restoration Utility HP 3PAR Recovery Manager Software for Oracle’s database restoration utility restores databases, tablespaces, datafiles, or archive logs from a virtual copy's backup image. The virtual copy must have been previously backed up using the rmora_backup command. The virtual copy must have a backup status of Y in order to be restored.
Recovery Manager for Oracle with Oracle Standby Database All HP 3PAR Recovery Manager Software for Oracle’s utilities can be run against an Oracle physical standby database instead of the production database. This completely eliminates the performance impact on the production database.
Recovery Manager for Oracle with Remote Copy Recovery Manager for Oracle integrates with HP 3PAR Remote Copy Software to copy database virtual volumes from one HP 3PAR storage system (local/primary) to another (remote/secondary). Once copied, database virtual copies (application consistent snapshots) are created on the remote/secondary storage system. The virtual copies can be used for disaster recovery or other off-host processing purposes.
2 Installing and Deinstalling Recovery Manager This chapter describes how to install, verify, and remove HP 3PAR Recovery Manager Software for Oracle on systems running Linux, Solaris, and HP UX. Referencing the Support Matrix For information about supported platforms, refer to the latest HP 3PAR Configuration Matrix. To obtain a copy of this documentation, go to http://www.hp.com/go/3par/, navigate to your product page, click Support for your product, and then click Manuals.
user and Oracle owner group must exist on the NetBackup master server. No Oracle binary is required. • If you choose Oracle RMAN for the backup method, you must create an Oracle RMAN Recovery Catalog and configure Oracle TNS Service and Listener to allow connecting to the Recovery Catalog from both the database and backup servers. The Recovery Catalog can be created on any host. Recovery Manager for Oracle recommends that the Recovery Catalog is created on the backup server.
Starting Installation The following section describes the steps necessary for installing Recovery Manager for Oracle on a Linux system: CAUTION: When upgrading to a newer version of 3PAR Recovery Manager, any previously installed versions of Recovery Manager must be removed. Use the rpm -e command to remove the previously installed package. For versions prior to, or equal to, 3.0.4, the package name is VCDBAora. Starting with version 4.1.0, the package name is RMOra.
3. After the installation is complete on all the required servers, you can allow Oracle users and Database Administrators group access to the Recovery Manager commands and utilities by changing the owner and permissions of the following directories (required for Oracle users): • /opt/3PAR/RMOra • /etc/3par/solutions/tasks • /etc/3par/solutions • /etc/3par/solutions/log • /etc/3par/solutions/lock • a. /etc/3par/solutions/.ora.
If you are not using the backup server as the NetBackup master server, be sure to install Recovery Manager for Oracle on the NetBackup master server. CAUTION: Before you upgrade to a new version of 3PAR Recovery Manager, deinstall any previously installed versions of Recovery Manager. To remove a previously installed package, log on as the root user and use the pkgrm command. For versions prior to, or equal to, 3.0.4, the package name is VCDBAora. Starting with version 4.1.
INSTDATE: HOTLINE: EMAIL: STATUS: FILES: 3. 4. Jan 18 2000 05:40 1-800-786-7967 www.hp.com completely installed 386 installed pathnames 8 shared pathnames 39 directories 61 executables 3 setuid/setgid executables 228424 blocks used (approx) Enter the pkginfo -l RMOra command and verify: • The Name entry displays the correct package name (RMOra). • The Version entry displays the correct version (4.2.0).
2. Use the pkgrm command as follows: # pkgrm For versions prior to, or equal to, 3.0.4, the package name is VCDBAora. Starting with version 4.1.0, the package name is RMOra. Installing Recovery Manager for Oracle on HP UX Systems Use the instructions in this section to install Recovery Manager for Oracle on the database and backup servers. If you are not using the backup server as the NetBackup master server, be sure to install Recovery Manager for Oracle on the NetBackup master server.
• /etc/3par/solutions/log • /etc/3par/solutions/lock • a. /etc/3par/solutions/.ora. Change the owner of the Recovery Manager utilities and repository as follows, where the Database Administrator user name is and the group name is : #chown #chown #chown #chown #chown NOTE: b.
3 Configuring Recovery Manager for Oracle Recovery Manager for Oracle requires that an SSH connection be configured for the backup server, the database server, the Symantec NetBackup master server, and the HP 3PAR storage system. Since Recovery Manager for Oracle can be run by either the root user or Oracle user (Oracle owner), configure SSH for the root or Oracle user. NOTE: user.
Figure 2 SSH Connection Relationship for Remote Copy Support SSH Restrictions Recovery Manager for Oracle has the following SSH restrictions: • The ssh and scp commands must be located in the /usr/bin/ directory. Create symbolic links if necessary. For example, if SSH and SCP are located at /usr/local/bin, create symbolic links as follows: #ln -s /usr/local/bin/ssh /usr/bin/ssh #ln -s /usr/local/bin/scp /usr/bin/scp • SSH keys on the database and backup servers must be generated with no passphrase.
3. If you are using HP UX, verify that the SSH daemon has strict mode disabled: a. Check the sshd_config file for the following line: StrictModes no b. If StrictModes is set to yes, change the entry to no. Generating an SSH Key Pair for the Backup Server To generate an SSH key pair for the backup server: 1. Log on to the backup server as the root or Oracle owner user. 2. Create a key pair with no passphrase using the ssh-keygen command. If a key-pair already exists, skip this section.
Setting Up Connections from the Backup Server to the Database Server To set up an SSH connection from the backup server to the database server, perform the following: • Copy the public key (id_rsa.pub) of the backup server to the authorized_keys file of the database server. # scp ~/.ssh/id_rsa.pub :~/.ssh/authorized_keys If the authorized_keys file already exist, add the public key (from ~/.ssh/id_rsa.
NOTE: setup. If you are prompted for a password, the setup is incorrect and you must redo the previous # ssh @ The authenticity of host '' can't be established. DSS key fingerprint is xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:x:xx:xx. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '' (DSS) to the list of known hosts.
4. Copy the public key of the backup server to the HP 3PAR storage system. You can find the public key in the location specified when generating an SSH key pair; for more information, see “Generating an SSH Key Pair for the Backup Server” (page 33). # ssh @ 's password: cli% setsshkey Please enter the SSH public key below. When finished, press enter twice. The key is usually long. It's better to copy it from inside an editor and paste it here.
for Oracle uses the same CLI user to access the HP 3PAR storage system from either the backup server or database server. If you created a different CLI user for the database server, perform the following to set up an SSH connection from the database server to the HP 3PAR storage system. 1. SSH to the database server and log in as the root or Oracle owner user. 2. Make sure the SSH key pair exists as follows: # ls ~/.ssh id_rsa id_rsa.pub authorized_keys known_hosts 3.
4. Copy the public key of the database server to the HP 3PAR storage system. # ssh @ 's password: cli% setsshkey Please enter the SSH public key below. When finished, press enter twice. The key is usually long. It's better to copy it from inside an editor and paste it here. (Please make sure there are no extra blanks.) The maximum number of characters used to represent the SSH key (including the "from" option, key type, and additional comments) is 4095.
Setting up National Language Host Support The Recovery Manager for Oracle message catalog and the symbolic link are installed in the following locations: OS Recovery Manager for Oracle Message Catalog Location Symbolic Link Location Solairs /opt/3PAR/msg/en_US /usr/lib/locale/en_US Linux /opt/3PAR/RMOra/msg/en_US /usr/lib/locale/en_US HP UX /opt/3PAR/msg/en_US /usr/lib/nls/msg/C • To retrieve the text messages properly, you must set the NLSPATH path environment; for example: # NLSPATH=$NLSPAT
NOTE: This section assumes that you are familiar with the Oracle Database and Symantec NetBackup (NBU). For more information on creating a NetBackup policy, refer to Symantec NetBackup documentation. Configuring the NetBackup Policy for Database Backup For Recovery Manager for Oracle to perform backup and restoration correctly, you must use the following guidelines in conjunction with Symantec NetBackup documentation when configuring a NBU policy: Backup Attribute 1.
For example, to set the BPSTART_TIMEOUT and BPEND_TIMEOUT parameters to 600 seconds (5 minutes), modify the corresponding parameters in /usr/openv/netbackup/bp.conf on the backup server as follows: BPSTART_TIMEOUT = 600 BPEND_TIMEOUT = 600 Setting Up NetBackup Configuration Parameters for the Database Server If a database is setup for High Availability (HA), then the CLIENT_NAME parameter in the /usr/openv/netbackup/bp.
For Recovery Manager for Oracle to perform backup and restoration correctly, you must use the following guidelines in conjunction with Symantec NetBackup documentation when configuring a NBU policy: Backup Attribute Select the Oracle type for the policy. Backup Selections 1. Enter the location of RMAN backup script (/etc/3par/solutions/.ora/rmora_nbu_dbbackup.sh). 2.
1. 2. Create a database for housing the Recovery Catalog. Oracle suggests the following disk space requirements: • System tablespace: 100 MB • Temp tablespace: 5 MB • Rollback segment: 5 MB • Online redo log: 1 MB (each) • Recovery Catalog: 10 MB Create a tablespace for the Recovery Catalog as follows: $ export ORACLE_SID= $ export ORACLE_HOME= $ sqlplus "/as sysdba" SQL> create tablespace datafile '' size 10M; SQL> exit where: 3.
6. Configure the Oracle listener for the Recovery Catalog database by adding an entry in the $ORACLE_HOME/network/admin/listener.ora file on the host where the Recover Catalog is created as follows: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ) (ORACLE_HOME = ) (SID_NAME = ) ) ) 7. Log in as the Oracle owner user and register the database on the database server.
2. When prompted, press ENTER. • ORACLE_SID of the database instance [h=help,q=quit]? Enter ORACLE_SID of the database instance that you want to configure. If the database is an RAC database, enter ORACLE_SID of any RAC instance. • Hostname of the database server [h=help,q=quit]? Enter the host name of the corresponding database server where the specified database instance is running.
• HP 3PAR storage system user name for the database server [h=help,q=quit]? Recovery Manager for Oracle requires that a 3PAR InForm user must have been created on the HP 3PAR storage system to allow access from the database server to the HP 3PAR storage system.
The default maximum number is 500 read-only virtual copies for each volume. • Do you want to remove oldest virtual copy when the maximum number of virtual copy is reached [y=yes,n=no,q=quit]? You will be prompted with this question if you set the maximum number of virtual copies in the previous question. Enter n if you do not want to remove the oldest virtual copy when maximum number of virtual copy is reached. Otherwise, enter y.
Enter a schedule name for the policy provided for the previous question that is used to perform full database backup. • NetBackup policy name for archive log backup [h=help,s=skip,q=quit]? A separate Symantec NetBackup policy must have been created for archive log backup if you want to perform back up of archive logs only. Enter the archive log backup policy, or press s to skip archive log backup.
6. Click Finish. If Recovery Manager for Oracle successfully connects to the database, it retrieves the database tablespaces, datafiles, the archive log destination, and the virtual volumes where the database resides. After verification is completed, Recovery Manager for Oracle creates a virtual copy repository on the backup server (/etc/3par/solutions/.ora.) and two configuration files are generated along with one subdirectory for database files mapping information.
• Oracle Home of the database instance on the database server [h=help,q=quit]? Recovery Manager for Oracle provides a default value for the ORACLE_HOME of the specified database instance if it can be retrieved from the oratab file. Press ENTER to accept default value, or enter ORACLE_HOME location of the specified database instance.
• Enter virtual copy retention time in days(d|D) or hours(h|H) [h=help,s=skip,q=quit]? Specifies the amount of time relative to the creation time that the virtual copy will be retained. Input value should be a positive integer and in the range of 1 hour to 43800 hours (1825 days). d/D means days. h/H means hours. A value of 0 specifies that there is no retention time set for read-only virtual copies. This question is only prompted for InForm 2.3.1 or above.
1. Start the Recovery Manager for Oracle GUI on the backup server. a. Ensure the X11 server is running on the destination host where the GUI is displayed. If the X11 server is not running, issue the following command: # xhost + b. Ensure the DISPLAY environment variable is set. # echo $DISPLAY c. Start the Recovery Manager for Oracle GUI.
4 Using the Recovery Manager Command Line Interface This chapter describes the Recovery Manager for Oracle command line utilities. NOTE: The command line utilities are located in /opt/3PAR/RMOra/bin. To view error messages, their explanations, and appropriate troubleshooting actions in a web browser, select Help→Event Messages from the menu bar. Alternatively, see “Troubleshooting” (page 135).
rmora_backup SYNTAX rmora_backup -s -p [-t ] [-o full|incr|cinc] [-v] or rmora_backup -s -p [-o online|offline|datafile|archlog|archonly[,full|incr|cinc]] [-v] DESCRIPTION Recovery Manager for Oracle integrates HP 3PAR Virtual Copy Software feature with Symantec NetBackup (NBU) and Oracle RMAN to perform snapshot off-host backup.
For Oracle RMAN backup (to tape or local disk): • The backup server must have an equal or higher Oracle major release version than the Oracle major release version on the database server. • To perform RMAN backup to tape, the Symantec NetBackup client must be installed on the backup server and database server. In addition, Symantec NetBackup for Oracle (Oracle Agent) must be installed on the backup server, database server, and the NBU master server.
The Oracle SID of the database instance. For Real Application Cluster (RAC) database, an Oracle SID of any RAC instance can be specified. -p The host name of the database server, on which the Oracle database instance is running. The value of the database server name must match the output of the hostname command. -t The timestamp of a virtual copy to be backed up. The virtual copy name can be obtained using the rmora_display command.
-o cinc Performs a cumulative incremental backup of a virtual copy. If Symantec NetBackup is selected as the backup method, this option can be used with the -o archlog option to perform a cumulative incremental backup of an archlog virtual copy. Recovery Manager for Oracle will only use one incremental schedule name for either differential incremental or cumulative incremental backup, which is predefined in the NBU schedule.
rmora_checkconfig SYNTAX rmora_checkconfig -s -p [-o all|skipdatabase|databaseonly] [-v] DESCRIPTION The rmora_checkconfig command validates a Recovery Manager for Oracle configuration file for a specified database. A configuration file must have been created prior to using this command. By default, all configured parameters in the specified configuration file will be validated. One can select to validate only database parameters or non-database parameters.
rmora_config SYNTAX rmora_config [-s -p ] DESCRIPTION The rmora_config command creates or modifies the Recovery Manager for Oracle configuration file for a database. A configuration file for each database must be created prior to using any database snapshot (virtual copy) utilities provided by Recovery Manager for Oracle. The configuration file will be created at /etc/3par/solutions/.ora./config. An equivalent environment file (config_exp.
the current time, that the volume will be retained. To specify a retention time, specify a value between 1 to 43,800 hours (1825 days). Retention time considerations: 60 ◦ This feature requires a separate HP 3PAR Virtual Lock license. ◦ The maximum retention time (VVRetentionTimeMax) is either the system's VVRetentionTimeMax (1825 days) or the virtual domain's VVRetentionTimeMax.
• RMAN_BACKUP_DEST - The backup destination to store RMAN backup image. This option is only required if the specified RMAN channel type is DISK. • RMVC_AFTER_BACKUP - Specifies whether the virtual copy should be removed after a successful backup. You must run this command as a super user or Oracle owner user from the backup server. To allow the Oracle Database Administrator (Oracle Owner) to run this command, an identical Oracle Database Administrator user must exist on the backup server.
rmora_create SYNTAX rmora_create -s -p [-o online|offline|archlog|archonly|datafile] [-r
will be then taken out of backup mode. An archive log switch will be performed before virtual copies of archive log virtual volumes are created. • If the specified database instance is a physical standby database, the database will be temporarily taken out of managed recovery mode before the virtual copy of the datafile virtual volumes is created. The database will then be put back into the original managed recovery mode. A datafile virtual copy alone cannot be used to restore and recover the database.
The Oracle SID of the database instance. For Real Application Cluster (RAC) database, an Oracle SID of any RAC instance can be specified. -p The corresponding host name of the database server where the specified Oracle database instance is running. The value of the database server name must match the output of the hostname command. -o online Creates a virtual copy for datafile and archive log virtual volumes while the database is online. This is the default option.
NOTE: If the database volumes do not belong to any domain, then the read-only virtual copy's retention time cannot exceed the value of the system's VVRetentionTimeMax. The default value for the system's VVRetentionTimeMax is 14 days. If the database volumes belong to a domain, then the read-only virtual copy's retention time cannot exceed the value of the domain's VVRetentionTimeMax, if set. The retention time cannot be removed or reduced once it is set.
rmora_createdb SYNTAX rmora_createdb -s -p -t [-n ] [-h ][-o ascii|binary|for_backup[,recovery|norecovery]] [-d ] [-v] DESCRIPTION The rmora_createdb command creates a fully functional single-instance database or starts up a clone database in MOUNTED mode for RMAN backup purposes. The fully functional single-instance database can be used for any off-host processing purpose.
Database Administrator user must exist on the backup server. In addition, permission on the Recovery Manager for Oracle Installation and Repository directories must be changed appropriately. OPTIONS The following options are supported: -s The Oracle SID of the database instance. For Real Application Cluster (RAC) database, an Oracle SID of any RAC instance can be specified.
rmora_display SYNTAX rmora_display -s -p [-t ] [-r] DESCRIPTION The rmora_display command displays database virtual copies, along with other information including creation time, type, status and backup status. A virtual copy's type can be either Online, Offline, Datafile, or Archlog. • Online or Offline virtual copy - Indicates that the virtual copy was created for the database while it was OPEN (online) or CLOSED (offline), respectively.
============ ======================== ======= ========= ======== • 1. 012403154751 Fri Jan 24 15:47:51 2003 Offline Available N 2. 012403154650 Fri Jan 24 15:46:50 2003 ArchLog Available N 3. 012403153912 Fri Jan 24 15:39:12 2003 Online Available N 4. 012303174743 Thu Jan 23 17:47:43 2003 Datafile Available N 5.
rmora_export SYNTAX rmora_export -s -p -t -r -e [-l ] [-v] DESCRIPTION The rmora_export command exports a virtual copy's repository from the current backup server to an alternate backup server. The exported virtual copy can then be mounted or cloned at the alternate backup server.
system user can be created using the InForm CLI createuser command. The created user must be assigned the edit role (privilege) or 3PAR_RM role. -v Runs the command in verbose mode.
rmora_mount SYNTAX rmora_mount -s -p -t [-m ] [-r] [-v] DESCRIPTION The rmora_mount command mounts an existing virtual copy created by the rmora_create command or rmora_rsync command on the backup server. The mounted virtual copy can be used for off-host processing purposes such as backup or database cloning.
• • For virtual copies from an ASM-managed database, based on the different ASM database releases on the backup server, the operation is different. ◦ For ASM versions 10.2.0.5, 11.0.1.7 or above, if an ASM instance exists and is up on the backup server, then all diskgroups from the virtual copy are mounted in this ASM instance. Otherwise, an ASM instance is started up on the backup server, and all ASM disk groups in the virtual copy are mounted.
rmora_remove SYNTAX rmora_remove -s -p -t [-v] DESCRIPTION The rmora_remove command removes a database virtual copy that was created using the rmora_create command. The virtual copy must have a status of Available to be removed. (To view the status of the virtual copy, use the rmora_display command.
rmora_removedb SYNTAX rmora_removedb -s -p -t [-n ] [-h ] [-f] [-v] DESCRIPTION The rmora_removedb command removes a clone database that was created using the rmora_createdb command. The clone database is shutdown with the shutdown immediate option. All files (Oracle parameter file, control files, and redo logs), previously created with the rmora_createdb command are removed. The virtual copy remains mounted.
rmora_restore SYNTAX rmora_restore -s -p [-t ] [-T ] [-D ] [-m ] [-h ] [-S ] [-H ] [-c] [-v] DESCRIPTION Restores database files from a virtual copy backup image. The rmora_restore command restores databases, tablespaces, data files, and/or archive logs from a virtual copy backup image. The virtual copy must have been previously backed up using the rmora_backup command.
image cannot be seen from the Recovery Catalog from the primary (production) database. To restore, the following steps must be performed manually: ◦ The backup image (pieces) must be manually copied from the backup server to the primary (production) server. ◦ The backup pieces must be then cataloged manually with the Recovery Catalog from the primary (production) server. ◦ Perform restore manually using Oracle RMAN.
-t The timestamp of a virtual copy whose backup image is used for restoration. Use the rmora_display command to retrieve a list of the virtual copy names. If a name is not specified, the most recent virtual copy’s backup (full) image is used for the restoration. -T The tablespace(s) that need to be restored. Use commas to separate multiple tablespace names (no space between the tablespace names). -D The datafile(s) that need to be restored.
rmora_rmrep SYNOPSIS rmora_rmrep -s -p [-t ] [-f] [-v] DESCRIPTION The rmora_rmrep command removes a virtual copy repository, specified by the parameter. If the is not specified, the entire database repository will be removed. If removing a virtual copy repository, the virtual copy's status must be Removed and its backup status must be N. If the virtual copy’s status is Y, the -f option can be used to force the removal of the repository.
rmora_rollback SYNOPSIS rmora_rollback -s -p -t [-o data|arch] [-v] [-w] [-f] DESCRIPTION The rmora_rollback command promotes a database virtual copy's volumes back to their base virtual volumes. Once promoted, the database virtual volumes will be exactly the same as the database virtual copy's volumes. If the virtual copy is the snapshot image of a standby database, it can only be used to promote back to the standby database virtual volumes.
-t The timestamp of a virtual copy from which to promote. The virtual copy name can be obtained using the rmora_display command. -o [data|arch] • data Promotes only the virtual copy’s datafile volumes back to their base virtual volumes. • arch Promotes only the virtual copy’s archive log volumes back to their base virtual volumes. -v Runs the command in verbose mode. -w Promotes the read-write virtual copy instead of the read-only virtual copy back to its base.
rmora_rsync SYNTAX rmora_rsync -s -p [-l ] [-o online|offline|validate|checkonly] [-r {d|D|h|H} -f] [-e {d|D|h|H}] [-v] DESCRIPTION The rmora_rsync command can be used to create an online of offline database virtual copy on the remote/secondary and local/primary HP 3PAR storage system in a Remote Copy or Synchronous Long Distance Remote Copy configuration.
• The online redo logs and control files should not reside on the same 3PAR virtual volumes used by the datafiles and archive logs to avoid being restored when using Recovery Manager rollback (promote) feature. However, the online redologs and control files can share the same 3PAR virtual volumes. • If database files reside on Symantec VxVM volumes, the datafiles and archive logs must reside on separate VxVM disk groups.
-o coldbkup This option is the same as the -o offline and is deprecated. -o validate Validates the Remote Copy configuration. -o checkonly Same as the -o validate option. This option is deprecated. -v Runs the command in verbose mode. -f Force to create a database virtual copy with a retention time. If retention time is specified either through the Recovery Manager for Oracle configuration file or through the -r option, this option must be specified.
rmora_set SYNTAX rmora_set -s -p -t [-r
• The retention time set during configuration time serves as the default value all virtual copies created thereafter. • The retention time can be specified during a virtual copy creation to overwrite the retention value set during the Recovery Manager for Oracle configuration. • The retention time can be modified but it can not be lower than the original setting. • The retention time can be specified in hours or days.
rmora_umount SYNTAX rmora_umount -s -p -t [-f] [-v] DESCRIPTION The rmora_umount command unmounts a mounted database virtual copy, which was previously mounted using the rmora_mount command. The virtual copy must have Mounted or Mounted(P) status in order to be unmounted. The virtual copy unmounting process only removes the read-write virtual copy; the read-only virtual copy remains intact.
5 Using the Recovery Manager for Oracle Graphical User Interface Starting and Stopping the Recovery Manager for Oracle GUI The Recovery Manager for Oracle Graphical User Interface (GUI) is installed when the RMOra package is installed. Starting the GUI To start the Recovery Manager for Oracle GUI: 1. Ensure that the DISPLAY environment variable is set. 2. Verify that the X11 server is running on the destination host where the GUI is displayed.
For additional details on creating configuration files with or without the Remote Copy feature, see “Recovery Manager for Oracle Configuration Files” (page 44). NOTE: The configuration file cannot be recreated if it already exists in the repository. You can modify the configuration as needed, or remove the configuration before a new one can be created. Modifying Configuration Files Configuration files can only be modified from the host node level. Modifications are made in the config and config_exp.
5. 6. 43,800 (hours). Deselecting the checkbox indicates there is no expiration and/or retention time. Click Next. (Optional) If you wish to schedule a task for the virtual copy, perform the following: NOTE: If you are using HP UX; before you can schedule tasks, the system administrator must add your user name to the relevant permissions file: /usr/lib/cron/cron.allow a. b. Select Schedule task. (Optional) Select Email result to recipient when task is finished for Email notification.
5. Click Finish. NOTE: The virtual copy policy is effective immediately. Setting up a Numeric-Based Virtual Copy Policy This feature allows you to control of the number of virtual copies on an HP 3PAR storage system using a numeric-based policy. When the maximum number of virtual copies is reached, the oldest copy can either be removed or retained. If you choose to retain the oldest copy, you will not be allowed to create new virtual copies.
3. 4. 5. Select the unit of measure for the Expiration time and/or the Retention Time as Days or Hours. Enter a numeric value from 0 to 1,825 (Days) or 0 to 43,800 (Hours) in the adjacent fields for Expiration time. Enter 0 if you want to remove the expiration time. Enter a numeric value from 1 to 1,824 (Days) or 1 to 43,800 (Hours) in the adjacent fields for Retention time. Removing retention time is not allowed in this release. Click Finish.
Rolling Back Using a Virtual Copy To roll back the primary database to a virtual copy’s point-in-time image, perform the following: 1. Right-click the virtual copy you wish to roll back under Virtual Copy Management in the navigation tree and select Rollback. The Rollback Virtual Copy dialog box appears. 2. 3. 4. If the virtual copy is an online full backup, select Full Rollback, Rollback Archive Log, or Rollback Datafile. (Optional) Select Rollback using Read/Write Virtual Copy. Click Finish.
when necessary. After the virtual copy repository is removed, the virtual copies have a status of Removed and all information related to this virtual copy set is lost. 1. Right-click the virtual copy name to be removed from the entire repository. 2. Click Remove Virtual Copy Repository. 3. Click Yes when prompted for confirmation to remove the repository. The removed repository is no longer displayed on the virtual copy management screen.
2. 3. On the Export Virtual Copy screen, provide the following information: • Alternate backup host name - the name of the backup server to which the virtual copy is exported. • Storage system SSH username - the storage server user name for the alternate backup server. This text field will display if SSH is selected. • Backup host name in storage system - the alternate backup server name defined in the HP 3PAR storage system. Click Finish to start exporting the virtual copy.
copy on the remote (secondary) HP 3PAR storage system, updates the navigation view, and sends notification to the user. Starting Periodic Synchronization To start periodic synchronization on a Remote Copy node: 1. Right-click a Remote Copy node on the navigation tree and click Initiate Sync. The Periodic Synchronization Virtual Volumes screen appears. 2. 3. 4. 5. Depending on the setup of your database, select either Online (Hot) Backup or Offline (Cold) Backup.
Log Destination Only option. After the virtual copy creation is completed, the database is taken out of backup mode. • Archive Log Destination Only - The involved database instance must be open for this operation. The database is forced to switch logs before a virtual copy of archive logs is created. 3. Select the Backup Type. a. Full backup - Performs a full backup of a virtual copy.
Viewing Online Help To view online help for Recovery Manager for Oracle, select Help→Online Help. Recovery Manager for Oracle Online Help appears in a web browser. Using a Web Browser to Access Online Help and Event Messages Recovery Manager for Oracle supports the latest versions of Firefox. If the Recovery Manager for Oracle GUI is unable to launch online help or event messages in Firefox, it attempts to launch your system’s default browser.
6 Using the Recovery Manager Rollback Utility Recovery Manager for Oracle provides a way to rollback a database to a point-in-time image by promoting a read-only or read-write virtual copy back to the base (database) virtual volumes. The base (database) virtual volume must not be exported to any host during the rollback process. In other words, the database LUNs of the corresponding database virtual volumes must be removed from the database server prior to the rollback process.
7. From the backup server, perform a rollback of the database virtual volumes using a database read-only virtual copy. Example: # rmora_rollback -s TEST920 -p pilot -t 042903142921 -v NOTE: 8. Use with the -f option if the database virtual volumes are in Remote Copy groups. On the HP 3PAR storage system, export the database volumes back to the database server with the same VLUNs saved in step 6. Example: cli>createvlun Oracle_data1 101 pilot 9.
NOTE: • Use with the -f option if the database virtual volumes are in Remote Copy groups. Additionally, perform step 8 through step 11 to startup the clone database again if required. NOTE: The binary or ascii control file in the Recovery Manager for Oracle repository can be used to perform the incomplete recovery on the database server.
7 Using Remote Copy with Recovery Manager Overview HP 3PAR Remote Copy Software helps you safeguard against disasters by copying (syncing) virtual volumes from one HP 3PAR Storage Server to another.
On the backup server: • Run /opt/3PAR/RMOra/bin/rmoragui to start the Recovery Manager for Oracle Graphical User Interface (GUI). or • Run /opt/3PAR/RMOra/bin/rmora_config to start the Command Line Interface (CLI). Refer to “Creating a Recovery Manager for Oracle Configuration File for Remote Copy Configuration” (page 49) in order to set up the configuration file for Remote Copy.
Figure 4 Asynchronous Periodic Remote Copy Configuration A Remote Copy configuration can also be configured as a Synchronous Long Distance configuration. Typically, a synchronous long distance Remote Copy configuration involves three HP 3PAR storage systems. Database virtual volumes are synced from one system to the two other systems. One is synced using synchronous mode. The other is synced using asynchronous periodic mode. See Figure 5 (page 105).
Figure 5 Synchronous Long Distance Remote Copy Configuration Creating Virtual Copies To create virtual copies, use the rmora_sync command or the Recovery Manager for Oracle GUI.
8 Support and Other Resources Related Documents The following documents also provide information related to the HP 3PAR Storage Server: For Information About… Read the… CLI commands and their usage HP 3PAR InForm OS Command Line Interface Reference Identifying storage server components and detailed alert information HP 3PAR InForm OS Messages and Operator’s Guide Using the Command Line Interface (CLI) to configure and manage HP 3PAR Storage Servers HP 3PAR InForm OS CLI Administrator’s Manual Using
A Case Study: Remote Copy with Recovery Manager for Oracle Introduction HP 3PAR Recover Manager Software for Oracle provides a utility, rmora_rsync, which can be used to support one-to-one synchronous or asynchronous periodic HP 3PAR Remote Copy configurations or Synchronous Long Distance configurations, and provides a quick restore and recovery for Oracle databases when failures occur.
The database ASM11GR2 uses SPFILE, which is located on one of the ASM disk groups. $cat initASM11GR21.ora SPFILE='+ASM11GR2_DATADG/ASM11GR2/spfileASM11GR2.ora' Configuration Diagram Preparing for Remote Copy Operation 1. 2. Refer to the HP 3PAR Remote Copy Software User’s Guide for instructions on setting up a Remote Copy environment.
NOTE: Recovery Manager for Oracle requires online redo logs and control files to be in a Remote Copy group separate from datafiles and archive log destinations on the local storage system and remote synchronous storage system. Recovery Manager for Oracle does not require a Remote Copy group for redo logs and control files on the asynchronous periodic storage system as Recovery Manager for Oracle will not synchronize redo logs and control files to the remote periodic storage system.
Taking the database out of backup mode ... Archiving online redo logs ... Initiating synchronization for archive log volumes ... Synchronization request issued for group linux_asm11gr2_arch task ID = 9771 9772 9773 In this case study, we used the virtual copy created using the rmora_rsync command for asynchronous periodic backup and recovery, instead of using base volumes on the remote system directly. We used the synced base volumes directly for synchronous remote system backup and recovery.
1. Failover to the synchronous storage system S347. If the Remote Copy groups have not been stopped, stop the groups on S256 by issuing the following: # stoprcopygroup -f linux_asm11gr2_data # stoprcopygroup -f linux_asm11gr2_arch # stoprcopygroup -f linux_asm11gr2_redo • The failover operation changes the role of the secondary groups on the remote synchronous storage system from Secondary to Primary-Rev.
Name Target Status Role Mode Options linux_asm11gr2_arch.r256 S256 Stopped Secondary Sync LocalVV ID RemoteVV ID SyncStatus LastSyncTime lux_asm11gr2_arch1_347 4447 lux_asm11gr2_arch1 6517 Stopped 2011-06-08 15:12:11 PDT lux_asm11gr2_arch2_347 4448 lux_asm11gr2_arch2 6518 Stopped 2011-06-08 15:12:11 PDT lux_asm11gr2_arch3_347 4449 lux_asm11gr2_arch3 6519 Stopped 2011-06-08 15:12:11 PDT Name Target Status Role Mode Options linux_asm11gr2_arch.
a. From the remote synchronous system S347, issue the following commands to failover the database ASM11GR21 related Remote Copy groups to S347: # setrcopygroup failover -f -t S256 linux_asm11gr2_data.r256 # setrcopygroup failover -f -t S256 linux_asm11gr2_arch.r256 # setrcopygroup failover -f -t S256 linux_asm11gr2_redo.r256 b. After the failover operation completes, issue the InForm showrcopy command on S347. Name Target Status Role Mode Options linux_asm11gr2_arch.
c. After failover, any LUNs associated with volumes on storage system S347 will become writable by the connected host panther. If VLUNs have not yet been created for the database volumes, issue the createvlun command from storage system S347 to create VLUNs for the corresponding database volumes on the synchronous storage system. # # # # # # # # # d.
2. Recover the Remote Copy groups from the synchronous storage system S347. • The recover operation initiates reverse replication and synchronizes the changes from the backup system to the primary system for the Remote Copy groups. Once executed, the role of the Remote Copy groups on the source system becomes Secondary-Rev. Any LUNs associated with volumes in the groups become non-writable on the source system.
On S347: Name Target Status Role Mode Options linux_asm11gr2_arch.r256 S256 Started Primary-Rev Sync LocalVV ID RemoteVV ID SyncStatus LastSyncTime lux_asm11gr2_arch1_347 4447 lux_asm11gr2_arch1 6517 Synced NA lux_asm11gr2_arch2_347 4448 lux_asm11gr2_arch2 6518 Synced NA lux_asm11gr2_arch3_347 4449 lux_asm11gr2_arch3 6519 Synced NA Name Target Status Role Mode Options linux_asm11gr2_arch.
From this output, note that the Status and Role of the three Remote Copy groups with target S356 are Started and Primary-Rev, respectively.
3. Restore the Remote Copy groups from the synchronous storage system S347. • The restore operation restores the replication for the Remote Copy groups to a pre-failover state. Once the restore operation is executed, the role of the Remote Copy groups on the source system will become Primary, and the Remote Copy groups on the backup system will become Secondary, which are the original settings.
On S347: Name Target Status Role Mode Options linux_asm11gr2_arch.r256 S256 Started Secondary Sync LocalVV ID RemoteVV ID SyncStatus LastSyncTime lux_asm11gr2_arch1_347 4447 lux_asm11gr2_arch1 6517 Synced NA lux_asm11gr2_arch2_347 4448 lux_asm11gr2_arch2 6518 Synced NA lux_asm11gr2_arch3_347 4449 lux_asm11gr2_arch3 6519 Synced NA Name Target Status Role Mode Options linux_asm11gr2_arch.
In the output above, note that the Status and Role of the three Remote Copy groups on S347 are Started and Secondary, respectively.
4. Recover the RAC database ASM11GR2. Assume the Oracle binary is available and crs is up. Mount all necessary file systems if the file systems are used. In this case, asmlib is used, so scan the oracleasm disks and then mount all database diskgroups. a. Scan oracleasm devices. dl160g6-13:# oracleasm scandisks b. Mount ASM diskgroups. alter alter alter alter alter c.
The best recovery option is recovering from the asynchronous periodic backup system S336. To recover, perform the following sequence of actions: 122 • Perform the failover operation on the asynchronous periodic backup system S336. Since we are not sure if the last periodic synchronization was completed, to avoid using fractured data, use the valid virtual copy created from using the Recovery Manager for Oracle command rmora_rsync.
1. Failover to the asynchronous periodic backup system S336. If the Remote Copy groups have not been stopped, stop the groups on S256 by issuing the following: # stoprcopygroup -f linux_asm11gr2_data # stoprcopygroup -f linux_asm11gr2_arch The failover operation changes the role of secondary groups on the backup system from Secondary to Primary-Rev. Any LUNs associated with the volumes in the Remote Copy group become writable by hosts connected to the backup system.
Name Target Status Role Mode Options linux_asm11gr2_arch.r256 S256 Stopped Primary-Rev Periodic over_per_alert LocalVV ID RemoteVV ID SyncStatus LastSyncTime lux_asm11gr2_arch1_336 1651 lux_asm11gr2_arch1 6517 Stopped 2011-06-08 17:49:41 PDT lux_asm11gr2_arch2_336 1652 lux_asm11gr2_arch2 6518 Stopped 2011-06-08 17:49:41 PDT lux_asm11gr2_arch3_336 1653 lux_asm11gr2_arch3 6519 Stopped 2011-06-08 17:49:41 PDT Name Target Status Role Mode Options linux_asm11gr2_arch.
2. Clone the database on the remote backup server using the desired virtual copy. a. Mount the virtual copy; in this example, virtual copy 060311173319. pe2950-24:# rmora_mount -s ASM11GR21 -p dl160g6-13 -t 060311173319 -v Verifying ssh between the backup server and the HP 3PAR storage system ... Creating database read-write Virtual Copy ... Exporting database read-write Virtual Copy to host 'pe2950-24.3pardata.com' ... Mounting ASM disk groups ... The Virtual Copy '060311173319' is mounted successfully.
3. Back up the binary control file from the cloned database and prepare to rollback the virtual copy. a. Issue the RMAN command to backup the control file in the cloned database while the database is in the Mounted state. RMAN> backup current controlfile format '/tmp/clone_control'; RMAN> shutdown immediate; b. Connect to the +ASM instance on the remote backup server pe2950-24 and then unmount the related ASM diskgroups used by the cloned database.
4. Rollback the read-write virtual copy to the base volumes from the remote system S336. Promote the read-write virtual copy to its base volume by issuing the rmora_rollback -w command. a. The rmora_rollback command with the -w option requires LUNs to be removed for the base volumes. In this example, the virtual copy used to clone the database is 060311173319.
5. Recover the Remote Copy groups from the asynchronous periodic backup system S336 to the local system S256. The recover operation initiates reverse replication and synchronizes the changes from the backup system to the primary system for the Remote Copy groups. Once executed, the role of the Remote Copy groups on the source system becomes Secondary-Rev. Any LUNs associated with volumes in the groups become nonwritable on the source system.
On S336 Name Target Status Role Mode Options linux_asm11gr2_arch.r256 S256 Started Primary-Rev Periodic Last-Sync 2011-06-09 17:07:17 PDT , over_per_alert LocalVV ID RemoteVV ID SyncStatus LastSyncTime lux_asm11gr2_arch1_336 1651 lux_asm11gr2_arch1 6517 Synced 2011-06-09 17:15:07 PDT lux_asm11gr2_arch2_336 1652 lux_asm11gr2_arch2 6518 Synced 2011-06-09 17:15:04 PDT lux_asm11gr2_arch3_336 1653 lux_asm11gr2_arch3 6519 Synced 2011-06-09 17:14:51 PDT Name Target Status Role Mode Options linux_asm11gr2_arch.
From this output, note that the role of the Remote Copy groups from S336 are Primary-Rev.
6. Restore the Remote Copy groups from the asynchronous periodic system S336. The restore operation restores the replication for the remote copy groups to a pre-failover state. Once the restore operation is executed, the role of the Remote Copy groups on the source system will become Primary, and the Remote Copy groups on the backup system will become Secondary, which are the original settings.
From this output, note that the Status and Role of the Remote Copy groups on S336 are Started and Secondary, respectively.
7. Bring up the primary database from the database server. a. Bring up the +ASM1 instance from the node dl160g6–13, mount all diskgroups, and create a new disk group for redo files and control files. If the same name of the disk group for redo logs exists, drop it and recreate it.
[vcdba@dl160g6-13 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 9 21:59:32 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.
B Troubleshooting This appendix provides Recovery Manager for Oracle error messages, their explanations, and appropriate actions. MESSAGE ID 1003 SYMBOLIC NAME RMO_ERROR_USER_NOTFOUND MESSAGE 3PAR1003: ERROR: Could not retrieve user id and group id for username . REASON Failed to retrieve the user information for a given username. SOLUTION Review the configuration file and make sure all parameters have up-to-date values.
3PAR1007: ERROR: Cannot determine archive log mode for database . REASON Failed to retrieve the archive log mode for the specified database. SOLUTION Manually log onto the database and check if the database is running normally. Most likely, either the database is not open or the archive log destination is full, which could cause the database to hang. MESSAGE ID 1008 SYMBOLIC NAME SymbolicName = RMO_ERROR_ORAHOME_BACKUP MESSAGE 3PAR1008: ERROR: Oracle binary location on the backup server is required.
MESSAGE ID 1012 SYMBOLIC NAME RMO_ERROR_MULTIPLE_PARTITION MESSAGE 3PAR1012: ERROR: Disk has multiple partitions. REASON In Linux, the specified disk has multiple partitions defined. SOLUTION Multiple partitions are not supported by Recovery Manager for Oracle. This is to avoid the possible rollback overwriting the data on other partitions. MESSAGE ID 1013 SYMBOLIC NAME RMO_ERROR_TARGET_PWWN_NOTFOUND MESSAGE 3PAR1013: ERROR: Could not find target port WWN for port .
REASON Failed to retrieve the hostname defined in the HP 3PAR storage system for the backup system. SOLUTION Execute InForm CLI command showhost to verify if the backup system is defined in the HP 3PAR storage system. Call customer support for further investigation. MESSAGE ID 1018 SYMBOLIC NAME RMO_ERROR_RESOLVE_PATH MESSAGE 3PAR1018: ERROR: Could not resolve the file path for . REASON Recovery Manager for Oracle fails to retrieve the real path for the specified file or directory.
REASON Using RMAN to backup the virtual copy to media with NetBackup, Recovery Manager for Oracle could not find the backup tag parameter, which should be passed from NetBackup. SOLUTION Contact customer support for further investigation. MESSAGE ID 1022 SYMBOLIC NAME RMO_ERROR_DB_STATUS MESSAGE 3PAR1022: ERROR: Could not determine status of database instance . REASON Failed to retrieve the database instance status. SOLUTION Verify if the database is healthy.
MESSAGE 3PAR1031: ERROR: is neither a regular file, directory, block nor character device. REASON When discovering devices used by the Oracle database, Recovery Manager for Oracle failed to determine the type of the specified device. SOLUTION Make sure the device is a supported device type.
MESSAGE ID 1048 SYMBOLIC NAME RMO_ERROR_ARCHDEST_ERROR MESSAGE 3PAR1048: ERROR: One or more archivelog destinations have error status. REASON When trying to retrieve archive log destinations, one or more archive log destination were found with "ERROR" status. SOLUTION Make sure all archive log destinations have enough space and have no errors. MESSAGE ID 1049 SYMBOLIC NAME RMO_ERROR_BKUP_TYPE_NOT_SPECIFIED MESSAGE 3PAR1049: ERROR: Backup type (full, incr, or cinc) not specified.
Change to use a different host as the alternate host. MESSAGE ID 1054 SYMBOLIC NAME RMO_ERROR_INVALID_ARGUMENT MESSAGE 3PAR1054: ERROR: Invalid argument. REASON rmora_exec or tpdcli_exec received an invalid argument. SOLUTION Verify the configuration file contains all parameters up to date. Contact customer support for further investigation. MESSAGE ID 1055 SYMBOLIC NAME RMO_ERROR_RMAN_SCRIPT MESSAGE 3PAR1055: ERROR: RMAN script not found. Please run rmora_config first.
MESSAGE 3PAR1061: ERROR: Could not find file system for file . REASON The specified file or directory is a regular file or qio file, but the operation could not retrieve its file system type. SOLUTION Make sure the mnttab contains the file system for the specified file or directory. Contact customer support for further investigation. MESSAGE ID 1062 SYMBOLIC NAME RMO_ERROR_CONVERT_ORAASM_DISK MESSAGE 3PAR1062: ERROR: Could not convert oracleasm disks.
MESSAGE ID 1066 SYMBOLIC NAME RMO_ERROR_SHARED_ASMDG MESSAGE 3PAR1066: ERROR: Archive logs and datafiles are on the same ASM disk group. REASON Recover Manager requires datafiles and archive log destinations reside on different ASM disk groups. The Virtual Copy for datafiles volumes and archive log destination volumes are taken at different times in order to recover the database to a point-in-time image. SOLUTION Put datafiles and archive log destinations on separate ASM disk groups.
During configuration, the retention or expiration value provided exceeds the maximum system allowed value, which is in the range of 1 to 43800 hours (1825 days). SOLUTION Specify a value within system allowed range. MESSAGE ID 1072 SYMBOLIC NAME RMO_ERROR_DB_NOT_RUNNING MESSAGE 3PAR1072: ERROR: Oracle instance is not currently running. Use -f option to force to remove the cloned database. REASON The operation trying to execute rmora_removedb to remove a cloned database failed.
3PAR1080: ERROR: Failed to retrieve the retention/expiration time for Virtual Copy . REASON Failed to retrieve the retention and/or expiration time from the HP 3PAR storage system for the specified virtual copy. SOLUTION Make sure all parameters in the configuration file are up to date. Make sure the HP 3PAR storage system is functioning properly. Contact customer support for further investigation.
MESSAGE ID 1097 SYMBOLIC NAME RMO_ERROR_SNAPDEV_NOTFOUND MESSAGE 3PAR1097: ERROR: Could not find Virtual Copy device for . REASON The command rmora_mount failed to find the OS device for the specified virtual copy. SOLUTION Make sure the configuration on the backup server is supported, such as a multipath configuration, and make sure related daemons are up.
MESSAGE ID 1101 SYMBOLIC NAME RMO_ERROR_REMOVE_ORAASMDISK MESSAGE 3PAR1101: ERROR: Could not delete oracleasm disk . REASON Failed to use the command oracleasmdeletedisk to delete the specified Oracle asmlib disk. SOLUTION Most likely the disk is still busy. Check the /var/log/oracleasm logfile for more information. Make sure there are no other processes accessing this disk. Normally the +ASM instance could still hold the resource.
MESSAGE 3PAR1104: ERROR: The number of virtual copies has exceeded the maximum of . REASON The maximum number of virtual copies specified in configuration file is reached. SOLUTION Either remove one or more virtual copies, or increase the number in the configuration file by running rmora_config or the GUI to modify the configuration.
Check if device is valid. Ignore the error message for non-3PAR devices. Check log files for more information. Contact customer support for further investigation. MESSAGE ID 1109 SYMBOLIC NAME RMO_ERROR_NONE_RCVV_FOUND MESSAGE 3PAR1109: ERROR: There is no Remote Copy volumes found on HP 3PAR storage system . REASON Could not find any volumes used by Remote Copy from the specified HP 3PAR storage system. SOLUTION Check if Remote Copy is configured correctly.
Try the operation at a later time. If you are certain that there are no similar operations going on, remove the lock file specified on the screen as it could be a result from a previous inappropriate or corrupted operation. MESSAGE ID 1112 SYMBOLIC NAME RMO_ERROR_UNKNOWN_BACKUP_MODE MESSAGE 3PAR1112: ERROR: Unknown backup mode . REASON The error happens when NetBackup calls the bpstart_notify.policy_name script. The script finds out the backup mode is not recognized.
SYMBOLIC NAME RMO_ERROR_RETRIEVE_LDVV MESSAGE 3PAR1116: ERROR: Could not retrieve logical disks for volume . REASON The InForm CLI command showld failed. SOLUTION Check the log file for more detailed information. Make sure TPDSYSNAME and TPDUSERNAME are set correctly from the configuration file. Make sure the HP 3PAR storage system is working properly. MESSAGE ID 1117 SYMBOLIC NAME RMO_ERROR_RETRIEVE_DEVINFO MESSAGE 3PAR1117: ERROR: Could not retrieve device information for .
MESSAGE ID 1128 SYMBOLIC NAME RMO_ERROR_RETRIEVE_CTRLFILE MESSAGE 3PAR1128: ERROR: Could not retrieve location of the control files from . REASON rmora_createdb failed to retrieve the control file location from the saved init.ora file. SOLUTION Make sure the init.ora file or spfile from the primary database has the control file location specified correctly. Contact customer support for further investigation.
REASON Before using the rmore_rsync command, all of the volumes within the Remote Copy groups that are used by the Oracle database should be in Synced status. SOLUTION Wait until the specified volume finishes syncing. MESSAGE ID 1132 SYMBOLIC NAME RMO_ERROR_RCVV_STOPPED MESSAGE 3PAR1132: ERROR: Remote Copy volume has been stopped. REASON Before using the rmore_rsync command, all of the volumes within the Remote Copy groups that are used by the Oracle database should be in Synced status.
MESSAGE ID 1135 SYMBOLIC NAME RMO_ERROR_CONFIG_PARAM_NOTFOUND MESSAGE 3PAR1135: ERROR: Parameter
Contact customer support for further investigation. MESSAGE ID 1139 SYMBOLIC NAME RMO_ERROR_ORA_VERSION MESSAGE 3PAR1139: ERROR: Could not determine Oracle release version. REASON During rmora_restore, Recover Manager failed to retrieve the Oracle software release. SOLUTION Check if Oracle is installed properly and if the configuration file contains valid values. MESSAGE ID 1140 SYMBOLIC NAME RMO_ERROR_UMOUNT_FS MESSAGE 3PAR1140: ERROR: Could not unmount file system .
When running rmora_createdb to clone the database on the backup server using the binary control file, and if the original datafiles/archive log destinations are symbolic links, rmora_createdb will try to create the links to point to the virtual copy, and the operation failed. SOLUTION Make sure the user running rmora_createdb has the correct permission to create the symbolic links. Check the log file for more details.
RMO_ERROR_VC_NOTMOUNTED_AT_ROOT MESSAGE 3PAR1145: ERROR: The Virtual Copy is not currently mounted at . REASON Trying to clone a database with the specified virtual copy using the binary control file option failed. The virtual copy must be mounted at the file system to be able to use the binary control file to clone. SOLUTION Use rmora_umount to unmount the virtual copy and use rmora_mount with the -m option to mount the virtual copy.
MESSAGE ID 1149 SYMBOLIC NAME RMO_ERROR_RESTORE MESSAGE 3PAR1149: ERROR: Could not restore backup to host . REASON The operation rmora_restore failed to use NetBackup to restore a backup image to the specified host. SOLUTION Check the NetBackup log file and Recovery Manager for Oracle log file for more detail information. MESSAGE ID 1150 SYMBOLIC NAME RMO_ERROR_RAWDEV_BINDING MESSAGE 3PAR1150: ERROR: Could not bind raw device .
When Recovery Manager for Oracle tries to execute the command createvlun, it has to make sure there is no other identical operation going on to take the next available LUN away. This is an exclusive operation. The lock file is in /etc/3par/solutions/lock/.vlun. SOLUTION Make sure there is no other createvlun process running. If the lock file is not cleaned up by previous failed operation, manually remove it.
Make sure the HP 3PAR storage system is working properly. Retry the operation. If the same error persists, contact customer support for further investigation. MESSAGE ID 1161 SYMBOLIC NAME RMO_ERROR_QUERY_ASM_REBALANCE MESSAGE 3PAR1161: ERROR: Could not determine if ASM rebalancing is in progress.
MESSAGE ID 1164 SYMBOLIC NAME RMO_ERROR_SET_RETENTEXP MESSAGE 3PAR1164: ERROR: Could not set retention/expiration for Virtual Copy . REASON Using rmora_set to set the retention time and/or expiration time for the specified virtual copy failed. SOLUTION Check the screen the output and log files for more detailed information. Check the system by issuing showsys -param and the maximum domain limit by issuing showdomain -d for the maximum allowed retention time.
3PAR1168: ERROR: One or more Virtual Copy's repository exist. REASON Trying to execute rmora_rmrep to remove the backup repository for a database configuration failed as there one or more virtual copy repositories still exist. SOLUTION Run rmora_remove to remove the all of the virtual copies before running rmora_rmrep. Make sure the virtual copies are no longer being used. MESSAGE ID 1169 SYMBOLIC NAME RMO_ERROR_UNSUPPORTED_DEVFMT MESSAGE 3PAR1169: ERROR: Unsupported device format: %s.
RMO_ERROR_SET_PROTECTION_MODE MESSAGE 3PAR1173: ERROR: Could not set the database protection mode to maximum performance. REASON After using the binary control file to clone a database, trying to set the protection mode to the default maximum performance failed. SOLUTION Check the alert.log for more detailed information. MESSAGE ID 1174 SYMBOLIC NAME RMO_ERROR_RETRIEVE_EQUIVALENT_FPATH MESSAGE 3PAR1174: ERROR: Could not retrieve the equivalent file path for on the backup server.
SOLUTION Check the alert log and Recovery Manager for Oracle log file for more details. Manually query the cloned the database to see if there are any problems. MESSAGE ID 1178 SYMBOLIC NAME RMO_ERROR_NBUMASTER_NOTFOUND MESSAGE 3PAR1178: ERROR: Could not retrieve NBU master server. REASON During configuration, retrieval of the NetBackup master server from the file /usr/openv/netbackup/bp.conf failed. SOLUTION Make sure NetBackup is installed and configured correctly on the backup server.
SYMBOLIC NAME RMO_ERROR_PHYSDEV_NOTFOUND MESSAGE 3PAR1182: ERROR: Could not find device '%s'. REASON Failed to retrieve the OS device used by the database while executing rmora_create or rmora_rsync. SOLUTION Check the log file from both the database server and the backup system to find out more information. Contact customer support for further investigation. MESSAGE ID 1183 SYMBOLIC NAME RMO_ERROR_CONNECT_TO_HOST MESSAGE 3PAR1183: ERROR: Could not connect (ssh) to host .
SOLUTION Check the log file for more details. Contact customer support for further investigation. MESSAGE ID 1192 SYMBOLIC NAME RMO_ERROR_DB_NOTIN_STANDBY MESSAGE 3PAR1192 ERROR: The database is not in managed recovery mode. REASON The database Recovery Manager for Oracle runs against is a physical standby database. However, the database is not in managed recovery mode and there is no MRP process in the database.
SOLUTION Make sure that the –d argument entered under rmora_createdb is entered and enclosed within double quotes (“), and make sure that the shell’s environment variable Internal Field Separator (IFS) is not set to a comma. MESSAGE ID 1202 SYMBOLIC NAME RMO_ERROR_UDUMP_NOTFOUND MESSAGE 3PAR1202 ERROR: Could not retrieve udump location for database . REASON Failed to retrieve the user_dump_dest value from the specified database. SOLUTION Check the alert.log file.
SYMBOLIC NAME RMO_ERROR_ARCHLOG_GAP MESSAGE 3PAR1208 ERROR: Archive log gap exists between the primary and standby database. REASON Recovery Manager for Oracle runs against a physical standby database. Trying to create an online or archive log only virtual copy fails because there is a gap for archive log files. SOLUTION Transfer the archive log files from the database server to the physical standby database.
MESSAGE ID 1216 SYMBOLIC NAME RMO_ERROR_SETVV MESSAGE 3PAR1216: ERROR: Could not set retention time for virtual copy . REASON Recovery Manager for Oracle failed to execute the InForm CLI command setvv -f -retain . SOLUTION Check the log file to get more information. Verify the retention time is correct and does not exceed the system or domain allowable maximum value. Verify the retention time is in the correct format.
SOLUTION Try to upgrade the InForm OS, or do not use this feature. MESSAGE ID 1220 SYMBOLIC NAME RMO_ERROR_INVALID_RETENTEXP MESSAGE 3PAR1220: ERROR: Invalid virtual copy retention or expiration value . REASON The retention or expiration value for a virtual copy should be a positive number and in the range of 1 to 43800 hours (1825 days). d/D means days. h/H means hours. A value of 0 indicates that the virtual copy will have no retention or expiration time.
3PAR1224: ERROR: Oracle ASMLib has not been installed. REASON In Linux, the required file /etc/sysconfig/oracleasm or /etc/sysconfig/Oracleasm-_dev_oracleasm which contains the oracleasm configurations is missing. SOLUTION Install asmlib and configure oracleasm correctly. MESSAGE ID 1225 SYMBOLIC NAME RMO_ERROR_DM_SCANORDER MESSAGE 3PAR1225: ERROR: The ORACLEASM_SCANORDER from does not include .
Make sure the TPDSYSNAME and TPDUSERNAME have correct values in the configuration file. Make sure the volumes were not removed, which can cause the error. Contact customer support for further investigation. MESSAGE ID 1228 SYMBOLIC NAME RMO_ERROR_VXVM_ASM_MOUNT_LOCK MESSAGE 3PAR1228: ERROR: Another database virtual copy is currently mounted. Only one virtual copy per database can be mounted at any time when ASM or VxVM is in use.
SYMBOLIC NAME RMO_ERROR_RETRIEVE_VV MESSAGE 3PAR1231: ERROR: Could not retrieve virtual volume information from the HP 3PAR storage system. REASON Failed to run the InForm CLI command showvv -d. SOLUTION Make sure the SSH connection from the current server to the specified HP 3PAR storage system is valid, all parameters in configuration files are up to date, and permissions are correct for the user to execute commands. Contact customer support for further investigation.
MESSAGE ID 1235 SYMBOLIC NAME RMO_ERROR_SV_NOTFOUND MESSAGE 3PAR1235: ERROR: virtual copy volume not found from the HP 3PAR storage system. REASON Could not find the specified virtual copy volume from the HP 3PAR storage system. SOLUTION Make sure the specified virtual copy exists in HP 3PAR storage system and all parameters in configuration files are up to date. Contact customer support for further investigation.
3PAR1238: ERROR: Could not shutdown ASM instance on host . REASON Could not shutdown the ASM instance on the backup server. SOLUTION Make sure the parameter values in configuration files are up to date, and check the alert.log file for more information. MESSAGE ID 1239 SYMBOLIC NAME RMO_ERROR_RETRIEVE_ASMSID MESSAGE 3PAR1239: ERROR: Could not retrieve ASM instance SID for database . REASON Failed to retrieve the ASM instance SID from the specified database.
RMO_ERROR_RETRIEVE_ASMDISK MESSAGE 3PAR1242: ERROR: Could not retrieve ASM disks for database '%s'. REASON Failed to retrieve ASM disks used by the specified database from ASM instance. SOLUTION Check the alert log for more details. Make sure the parameters in configuration files are up-to-date and that the ASM instance is in healthy state. MESSAGE ID 1243 SYMBOLIC NAME RMO_ERROR_ASMDG_NOTFOUND MESSAGE 3PAR1243: ERROR: Could not find ASM disk group .
MESSAGE ID 1246 SYMBOLIC NAME RMO_ERROR_BACKUP_ASM_METADATA MESSAGE 3PAR1246: ERROR: Could not backup ASM metadata. REASON Failed to execute the ASM command md_backup. SOLUTION Check the alert log and Recovery Manager for Oracle log file for more details. MESSAGE ID 1247 SYMBOLIC NAME RMO_ERROR_CREATE_SPFILE MESSAGE 3PAR1247: ERROR: Could not create spfile from pfile . REASON Failed to run the SQL command to create an spfile from a specified pfile.
MESSAGE ID 1250 SYMBOLIC NAME RMO_ERROR_SET_ARCHLOG MESSAGE 3PAR1250: ERROR: Please explicitly set value for parameter log_archive_dest_n. REASON The detail can be found in bug 41996. If there is no explicit value set for this parameter, it could cause rmora_createdb tasks to fail. SOLUTION Set this parameter value explicitly. MESSAGE ID 1251 SYMBOLIC NAME RMO_ERROR_RECONFIG MESSAGE 3PAR1251: ERROR: Please run rmora_config then try again.
SOLUTION Make sure the OS is in valid state on the database server. Manually remount the file system. Contact customer for further investigation. MESSAGE ID 1254 SYMBOLIC NAME RMO_ERROR_CREATE_ROVC MESSAGE 3PAR1254: ERROR: Could not create read-only virtual copy. REASON The InForm CLI command creategroupsv failed to create a read-only virtual copy. SOLUTION Check the log file for more details. Make sure parameters have up to date values. Contact customer support for further investigation.
REASON Using the command vxvol -g dgname to start up all VxVM volumes failed. SOLUTION Check the log file to get more details. Make sure VxVM is in a valid state. Contact customer support for further investigation. MESSAGE ID 1259 SYMBOLIC NAME RMO_ERROR_MOUNT_ASM MESSAGE 3PAR1259: ERROR: Could not start up the ASM instance or mount the ASM snapshot disk groups. REASON Failed to startup the ASM instance or mount the ASM disk groups on the backup server. SOLUTION Check the log file to get more details.
MESSAGE 3PAR1262: ERROR: Could not drop one or more ASM snapshot disk groups. REASON The SQL command to drop one or more ASM snapshot disk groups on the backup server fails. SOLUTION Check the log file for more details. Contact customer support for further investigation. MESSAGE ID 1263 SYMBOLIC NAME RMO_ERROR_RETRIEVE_DMPNODE MESSAGE 3PAR1262: ERROR: Could not retrieve VxVM DMP node for disk . REASON Could not find the VxVM snapshot device (DMP node) from the output of the vxdmpdbprint command.
MESSAGE ID 1266 SYMBOLIC NAME RMO_ERROR_BACKUP_NOT_CONFIGURE MESSAGE 3PAR1266: ERROR: Recovery Manager has not been configured for backup/restore. REASON The operation to backup or restore failed as the configuration file does not contain the backup information. SOLUTION Run rmora_config to add the backup configuration portion. MESSAGE ID 1267 SYMBOLIC NAME RMO_ERROR_NBU_INCBACKUP_UNSUPPORTED MESSAGE 3PAR1267: ERROR: Incremental backup using Symantec NetBackup is not supported.
The operation to use Oracle RMAN and a NetBackup policy with Oracle type to backup a database failed. SOLUTION Check NetBackup log files and the Recovery Manager for Oracle log file for more details. MESSAGE ID 1270 SYMBOLIC NAME RMO_ERROR_RETRIEVE_VCTSTMP MESSAGE 3PAR1270: ERROR: Could not retrieve the created virtual copy's timestamp. REASON This error occurs when using NetBackup to backup a virtual copy.
MESSAGE ID 1273 SYMBOLIC NAME RMO_ERROR_RETRIEVE_DBNAME MESSAGE 3PAR1273: ERROR: Could not retrieve the current database name. REASON During rmora_restore, Recovery Manager for Oracle failed to retrieve the name of the database to be restored. SOLUTION Make sure the database to be restored to is started in started mode to be able to query the v$instance view. MESSAGE ID 1274 SYMBOLIC NAME RMO_ERROR_VC_NOT_BACKUP MESSAGE 3PAR1274: ERROR: The virtual copy has no backup image.
SYMBOLIC NAME RMO_ERROR_ARCHLOG_RESTORE MESSAGE 3PAR1276: ERROR: Archive logs will be restored automatically during media recovery using Oracle RMAN. REASON Trying to restore archive log files using RMAN fails. SOLUTION There is no need to restore archive log files alone. RMAN will automatically restore necessary archive log files during media recovery. MESSAGE ID 1277 SYMBOLIC NAME RMO_ERROR_RESTORE_DIFFERENT_DB MESSAGE 3PAR1277: ERROR: Restoring to a different database is not supported.
MESSAGE 3PAR1279: ERROR: The host is neither the backup server or the original host. Use '-H' option to specify the Oracle Home on the host. REASON Trying to restore a backup image to a host that is different from the original database server and the backup server, but no Oracle Home parameter is specified in the command line results in this error. SOLUTION rmora_restore needs to know the host name and Oracle home on this alternate host to be able to continue.
MESSAGE ID 1301 SYMBOLIC NAME RMO_ERROR_CLONEDB_UP MESSAGE 3PAR1301: ERROR: The clone database instance is currently running. REASON Trying to clone a database with the specified name failed, as a database with same instance name is already up and running. SOLUTION If the running database was cloned using a virtual copy from a different database, change the rmora_createdb parameter to use a new Oracle SID.
During rmora_createdb process, the error occurs when: • A non-default clone location (option -d) was specified to clone the database, and • At least one of the clone locations is an ASM disk group, which means the control file will reside on one of the ASM disk groups on the backup server, and • The ASM instance on the backup server does not contain the disk group for the control file.
Make sure that the alternate backup server is connected to the HP 3PAR storage system and is set up correctly, so that a showhostcommand on the storage system shows that the backup/alternate backup server is online. MESSAGE ID 1311 MESSAGE 3PAR1311: ERROR: TPD Host does not match specified host . REASON The TPD Host name that the user entered does not correspond to any valid host that Recovery Manager for Oracle can discover.
MESSAGE ID 1315 MESSAGE 3PAR1315: ERROR: Could not import volume group . REASON The LVM vgimport command, which is used to import the snapshot volume group, has failed. SOLUTION See preceding error message to determine the cause of failure. MESSAGE ID 1316 MESSAGE 3PAR1316: ERROR: Could not activate volume group . REASON The LVM vgchange command, which is used to activate the snapshot volume group, has failed. SOLUTION See the preceding error message to determine the cause of failure.
See the preceding error message to determine the cause of failure. MESSAGE ID 1320 MESSAGE 3PAR1320: ERROR: Could not remove LVM volume group . REASON The LVM vgremove command, which is used to remove a snapshot volume group, has failed. SOLUTION See the preceding error message to determine the cause of failure.
Index A I archive log backup configuring NBU policy, 40 automatic backup, 19 immediate backup, 18 installation on Linux systems, 24 installing, 23 installing on primary server, 27 installing Recovery Manager on Solaris systems, 26 B backup server to HP 3PAR storage system SSH connection, 36 backup to NBU verification for SSH, 34 backup to primary host verification, 34 L location of command line utilities, 53 C M clone utility, 14 cloned database removal utility, 15 cloning a database, 95 command, 27
removing virtual copy repositories, 79 requirements standby databases, 9 restrictions with SSH, 32 RMAN recovery catalog creation, 42 rmora_create, 62 rmora_createdb, 66 rmora_display, 68 rmora_mount, 72 rmora_remove, 74 rmora_removedb, 75 rmora_restore, 76 rmora_rmrep, 79 rmora_rollback, 80 rmora_set, 85 rmora_unmount, 87 rolling back virtual copies, 80 S setting retention time for a virtual copy, 85 setting up national language support, 39 setting up SSH from backup to HP 3PAR storage system, 35 from bac