Hp 3PAR Application Software Suite for Oracle Manuale Utente Pagina 1

HP 3PAR Recovery Manager 4.4.0 Softwarefor OracleUser GuideAbstractThis document provides the information needed to install, configure, and use the HP

For NBU backup and restoration, Recovery Manager for Oracle interacts directly with NBU totrigger the backup or restore process. Recovery Manager for

• The retention time set during configuration time serves as the default value all Virtual Copiescreated thereafter.• The retention time can be specif

rmora_umountSYNTAXrmora_umount -s <oracle_sid> -p <db_server> -t <timestamp> [-f] [-v]DESCRIPTIONThe rmora_umount command unmounts a

5 Using the Recovery Manager for Oracle Graphical UserInterfaceThe following section describes how to use the GUI to perform specific operations relat

4. Press ENTER.NOTE: It is a known issue that the mouse events are not captured correctly on the cygwinx-server for Java6.Stopping the GUITo stop the

3. Select the desired options from the Backup Method group box.• Online (Hot) backup - The involved database instance must be open for this operation.

NOTE: You can configure the Virtual Copy policy by using either a time or numeric-based policy.HP recommends using a time-based policy instead of a nu

6. (Optional) Select Default retention time and enter a numeric value from 1 to 1,825 (Days) or1 to 43,800 (Hours) in the adjacent field to set the nu

Mounting a Virtual CopyAfter a Virtual Copy is created, it can be mounted on the backup server where the RecoveryManager for Oracle GUI is running.To

Viewing Rollback StatusIt may take several minutes to rollback a Virtual Copy depending on its size.To view a Virtual Copy’s rollback status:1. Right-

Restoring Archive Log, Datafiles, and TablespacesNOTE: If Symantec NetBackup (NBU) is used to back up datafiles, NBU can be used to restoredatafiles t

The Virtual Copy Creation UtilityThe Virtual Copy creation utility (rmora_create command) of HP 3PAR Recovery ManagerSoftware for Oracle creates an on

database, or to clone the database for testing, decision making, and report generating purposes.The cloning capability takes the workload out of the d

4. (Optional) Select Retention time and enter a numeric value from 1 to 1,825 (Days) or 1 to43,800 (Hours) in the adjacent field.5. Click Finish.After

3. Select the Backup Type.NOTE: Incremental backup of archive log using RMAN is not supported.a. Full backup - Performs a full backup of a Virtual Cop

Recovery Manager for Oracle Online Help appears in a web browser.Using a Web Browser to Access Online Help and Event MessagesRecovery Manager for Orac

6 Using the Recovery Manager Rollback UtilityRecovery Manager for Oracle provides a way to rollback a database to a point-in-time image bypromoting a

5. On the HP 3PAR StoreServ Storage system, remove the VLUNs for the database virtual volumes.Example:cli>removevlun Oracle_data1 101 pilot6. Keep

Rollback Using a Database Read-Write Virtual CopyThe steps to rollback from a read-write Virtual Copy are the similar to rollback from a read-onlyVirt

10. On the backup server, if needed, mount the file systems if the read-write virtual copy containsfile systems.Example:# mount -F vxfs /dev/vx/dsk/da

7 Using Remote Copy with Recovery ManagerOverviewHP 3PAR Remote Copy Software helps you safeguard against disasters by copying (synchronizing)virtual

On the backup server:• Run /opt/3PAR/RMOra/bin/rmoragui to start the Recovery Manager for Oracle GraphicalUser Interface (GUI).or• Run /opt/3PAR/RMOra

An archive log Virtual Copy is created while the database is OPEN and performs the followingactions:• Discovers devices (HP 3PAR virtual volumes) used

Figure 5 Asynchronous Periodic Remote Copy ConfigurationA Remote Copy configuration can also be configured as a Synchronous Long Distance configuratio

Figure 6 Synchronous Long Distance Remote Copy ConfigurationCreating Virtual CopiesTo create Virtual Copies, use the rmora_sync command or the Recover

8 Support and Other ResourcesContacting HPFor worldwide technical support information, see the HP support website:http://www.hp.com/supportBefore cont

See:For information about:HP 3PAR-to-3PAR Storage Peer Motion GuideMigrating data from one HP 3PAR storage system to anotherHP 3PAR Secure Service Cus

See:For information about:Planning for HP 3PAR storage system setupHardware specifications, installation considerations, power requirements, networkin

Typographic conventionsTable 1 Document conventionsElementConventionBold text• Keys that you press• Text you typed into a GUI element, such as a text

9 Documentation feedbackHP is committed to providing documentation that meets your needs. To help us improve thedocumentation, send any errors, sugges

A Case Study: Remote Copy with Recovery Manager forOracleIntroductionHP 3PAR Recover Manager Software for Oracle provides a utility, rmora_rsync, whic

oracleasm-support-2.1.4-1.el5oracleasmlib-2.0.4-1.el5The database ASM11GR2 uses SPFILE, which is located on one of the ASM disk groups.$cat initASM11G

2. Create Remote Copy groups on the local storage system S256:# creatercopygroup linux_asm11gr2_data S347:sync S336:periodic# creatercopygroup linux_a

The Virtual Copy Mount UtilityThe Virtual Copy mount utility of HP 3PAR Recovery Manager Software for Oracle mounts anexisting database Virtual Copy t

Checking database status ...Discovering database devices ...Retrieving database Remote Copy group(s) ...Archiving online redo logs ...Putting the data

1. Failover to the synchronous storage system S347.If the Remote Copy groups have not been stopped, stop the groups on S256 by issuing thefollowing:#

Name Target Status Role Mode Optionslinux_asm11gr2_arch.r256 S256 Stopped Secondary SyncLocalVV

a. From the remote synchronous system S347, issue the following commands to failover thedatabase ASM11GR21 related Remote Copy groups to S347:# setrco

c. After failover, any LUNs associated with volumes on storage system S347 will becomewritable by the connected host panther. If VLUNs have not yet be

2. Recover the Remote Copy groups from the synchronous storage system S347.• The recover operation initiates reverse replication and synchronizes the

On S347:Name Target Status Role Mode Optionslinux_asm11gr2_arch.r256 S256 Started Primary-Rev SyncLocalVV

From this output, note that the Status and Role of the three Remote Copy groups withtarget S356 are Started and Primary-Rev, respectively.On S256:Name

3. Restore the Remote Copy groups from the synchronous storage system S347.• The restore operation restores the replication for the Remote Copy groups

On S347:Name Target Status Role Mode Optionslinux_asm11gr2_arch.r256 S256 Started Secondary SyncLocalVV

instance. If no ASM instance is up on the backup server, an ASM instance is started upon the backup server, and all ASM disk groups in the Virtual Cop

In the output , note that the Status and Role of the three Remote Copy groups on S347are Started and Secondary, respectively.On S256:Name

4. Recover the RAC database ASM11GR2.Assume the Oracle binary is available and CRS is up. Mount all necessary file systems if thefile systems are used

The best recovery option is recovering from the asynchronous periodic backup system S336. Torecover, perform the following sequence of actions:• Perfo

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 thefol

Name Target Status Role Mode Optionslinux_asm11gr2_arch.r256 S256 Stopped Primary-Rev Periodic over_per_al

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

3. Back up the binary control file from the cloned database and prepare to rollback the VirtualCopy.a. Issue the RMAN command to backup the control fi

4. Rollback the read-write Virtual Copy to the base volumes from the remote system S336. Promotethe read-write Virtual Copy to its base volume by issu

5. Recover the Remote Copy groups from the asynchronous periodic backup system S336 to thelocal system S256.The recover operation initiates reverse re

On S336Name Target Status Role Mode Optionslinux_asm11gr2_arch.r256 S256 Started Primary-Rev Periodic Last-Sync 20

• Once exported, the Virtual Copy on the alternate backup server can be mounted, unmounted,backed up, and restored.• Once the exported Virtual Copy is

From this output, note that the role of the Remote Copy groups from S336 arePrimary-Rev.S256:Name Target Status Role Mod

6. Restore the Remote Copy groups from the asynchronous periodic system S336.The restore operation restores the replication for the remote copy groups

From this output, note that the Status and Role of the Remote Copy groups on S336are Started and Secondary, respectively.S256:Name Targ

7. Bring up the primary database from the database server.a. Bring up the +ASM1 instance from the node dl160g6-13, mount all diskgroups, andcreate a n

[vcdba@dl160g6-13 ~]$ sqlplus '/as sysdba'SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 9 21:59:32 2011Copyright (c) 1982, 2009, Oracle

B TroubleshootingThis appendix provides Recovery Manager for Oracle error messages, their explanations, andappropriate actions.MESSAGE ID1003SYMBOLIC

3PAR1007: ERROR: Cannot determine archive log mode for database <name>.REASONFailed to retrieve the archive log mode for the specified database.

MESSAGE ID1012SYMBOLIC NAMERMO_ERROR_MULTIPLE_PARTITIONMESSAGE3PAR1012: ERROR: Disk <disk ID> has multiple partitions.REASONIn Linux, the specif

REASONFailed to retrieve the hostname defined in the HP 3PAR StoreServ Storage system for the backupsystem.SOLUTIONAn attempt to retrieve the host def

SYMBOLIC NAMERMO_ERROR_BKUP_TAG_NOT_SPECIFIEDMESSAGE3PAR1021: ERROR: Backup tag not specified.REASONUsing RMAN to backup the Virtual Copy to media wit

The cloned database is shutdown with the shutdown immediate option. The database relatedfiles (Oracle parameter file, control files and redo logs), wh

MESSAGE ID1031SYMBOLIC NAMERMO_ERROR_UNSUPPORTED_FILETYPEMESSAGE3PAR1031: ERROR: <file name> is neither a regular file, directory, block nor a c

The HP 3PAR CLI command promotesv failed.SOLUTIONMake sure the HP 3PAR StoreServ Storage system is functioning correctly. Contact customer supportfor

3PAR1050: ERROR: The alternate host <name> is the same as the backup system.REASONWhen running the rmora_export command, the alternate host cann

MESSAGE ID1061SYMBOLIC NAMERMO_ERROR_FS_NOTFOUNDMESSAGE3PAR1061: ERROR: Could not find file system for file <file name>.REASONThe specified file

REASONRecovery Manager requires datafiles and archive log destinations reside on different HP 3PARvolumes.SOLUTIONPut datafiles and archive log destin

RMO_ERROR_MAXVC_RETENTEXPMESSAGE3PAR1071: ERROR: '%s' exceeds maximum Virtual Copy retention or expiration value.REASONDuring configuration,

MESSAGE ID1080SYMBOLIC NAMERMO_ERROR_RETRIEVE_RETENTEXPMESSAGE3PAR1080: ERROR: Failed to retrieve the retention/expiration time for Virtual Copy <n

Trying to clone a database failed because the redo log information cannot be found in the asciicontrol file.SOLUTIONCheck the original database and ma

ORACLEASM_SCANEXCLUDE="sd"This is to direct asmlib to only scan device mapper devices (dm devices), and not to scan sd formatof devices. Thi

Run rmora_config or the GUI application to modify the configuration file to set VCDBA_MAXVCto a positive number, which cannot exceed 500. Also make su

If a Virtual Copy has been backed up, the remove repository utility command fails unless the -foption is used.Virtual Copy PolicyHP 3PAR Recovery Mana

SYMBOLIC NAMERMO_ERROR_IOCTLMESSAGE3PAR1107: ERROR: Could not perform SCSI inquiry to device <device ID>.REASONThe system call ioctl failed for

If there is no other backup process for this database running, remove the lock file <name> and tryagain.REASONSome Recovery Manager for Oracle c

rmora_checkconfig is called at the end of creating or modifying a configuration file. It canalso be executed separately. If it finds any check has an

RMO_ERROR_BACKUP_IMAGE_NOTFOUNDMESSAGE3PAR1127: ERROR: There is no Virtual Copy backup image (full).REASONrmora_restore could not find a Virtual Copy

Rearrange the Remote Copy groups used by the database accordingly.MESSAGE ID1131SYMBOLIC NAMERMO_ERROR_RCVV_NOTSYNCEDMESSAGE3PAR1131: ERROR: Remote Co

REASONFailed to find next available VLUN number to create a VLUN. The HP 3PAR CLI commandcreatevlun will fail if the error is not corrected.SOLUTIONCh

RMO_ERROR_INVALID_TSTMPMESSAGE3PAR1138: ERROR: Invalid timestamp format <format>.REASONFailed to receive a timestamp for next current Virtual Co

RMO_ERROR_CREATE_VC_SYMLINKMESSAGE3PAR1142: ERROR: Could not create symbolic links for Virtual Copy <Virtual Copy name>.REASONWhen running rmora

MESSAGE ID1145SYMBOLIC NAMERMO_ERROR_VC_NOTMOUNTED_AT_ROOTMESSAGE3PAR1145: ERROR: The Virtual Copy <Virtual Copy name> is not currently mounted

SOLUTIONMake sure the previous rmora_mount was successful. Check the alert log and Recovery Managerfor Oracle log for more details.MESSAGE ID1149SYMBO

Recovery Manager for Oracle saves an ASCII control file and a binary control file for each createdVirtual Copy in its repository. After a rollback, yo

REASONWhen Recovery Manager for Oracle tries to execute the command createvlun, it has to makesure there is no other identical operation going on to t

SOLUTIONMake sure the HP 3PAR StoreServ Storage system is working properly. Retry the operation. If thesame error persists, contact customer support f

MESSAGE ID1164SYMBOLIC NAMERMO_ERROR_SET_RETENTEXPMESSAGE3PAR1164: ERROR: Could not set retention/expiration for Virtual Copy <Virtual Copy name>

3PAR1168: ERROR: One or more Virtual Copy's repository exist.REASONTrying to execute rmora_rmrep to remove the backup repository for a database c

RMO_ERROR_SET_PROTECTION_MODEMESSAGE3PAR1173: ERROR: Could not set the database protection mode to maximum performance.REASONAfter using the binary co

SOLUTIONCheck the alert log and Recovery Manager for Oracle log file for more details. Manually querythe cloned the database to see if there are any p

SYMBOLIC NAMERMO_ERROR_PHYSDEV_NOTFOUNDMESSAGE3PAR1182: ERROR: Could not find device '%s'.REASONFailed to retrieve the OS device used by the

SOLUTIONCheck the log file for more details. Contact customer support for further investigation.MESSAGE ID1192SYMBOLIC NAMERMO_ERROR_DB_NOTIN_STANDBYM

SOLUTIONMake sure that the –d <loc> argument entered under rmora_createdb is entered and enclosedwithin double quotes (“), and make sure that th

SYMBOLIC NAMERMO_ERROR_ARCHLOG_GAPMESSAGE3PAR1208 ERROR: Archive log gap exists between the primary and standby database.REASONRecovery Manager for Or

The following restrictions apply when backing up a database using the Recovery Manager forOracle database backup utility.• For NBU (user-managed) back

MESSAGE ID1216SYMBOLIC NAMERMO_ERROR_SETVVMESSAGE3PAR1216: ERROR: Could not set retention time <time> for Virtual Copy <Virtual Copy name>

SOLUTIONTry to upgrade HP 3PAR OS, or do not use this feature.MESSAGE ID1220SYMBOLIC NAMERMO_ERROR_INVALID_RETENTEXPMESSAGE3PAR1220: ERROR: Invalid Vi

3PAR1224: ERROR: Oracle ASMLib has not been installed.REASONIn Linux, the required file /etc/sysconfig/oracleasm or/etc/sysconfig/Oracleasm-_dev_oracl

SOLUTIONMake sure the TPDSYSNAME and TPDUSERNAME have correct values in the configuration file.Make sure the volumes were not removed, which can cause

MESSAGE ID1231SYMBOLIC NAMERMO_ERROR_RETRIEVE_VVMESSAGE3PAR1231: ERROR: Could not retrieve virtual volume information from the HP 3PAR StoreServStorag

SOLUTIONCheck the log file for more information. Make sure the OS is a valid supported version and thatthe OS is functioning correctly. Contact custom

SYMBOLIC NAMERMO_ERROR_SHUTDOWN_ASMMESSAGE3PAR1238: ERROR: Could not shutdown ASM instance on host <host name>.REASONCould not shutdown the ASM

MESSAGE ID1242SYMBOLIC NAMERMO_ERROR_RETRIEVE_ASMDISKMESSAGE3PAR1242: ERROR: Could not retrieve ASM disks for database '%s'.REASONFailed to

If during database cloning time, check the saved init.ora file to see if there are any unusualcharacters or wrong syntax. Make sure the primary databa

Make sure the archive log destinations are in valid state and have enough space. Make sure theprimary database is running normally.MESSAGE ID1250SYMBO

© Copyright 2013 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP required for possession, use or copyin

Client-side BackupDuring client-side backup, Recovery Manager for Oracle performs the following:• Creates an online, offline, datafile, or archonly Vi

REASONFailed to remount the specified file system.SOLUTIONMake sure the OS is in valid state on the database server. Manually remount the file system.

MESSAGE3PAR1258: ERROR: Could not startup all VxVM volumes in disk group <name>.REASONUsing the command vxvol -g dgname to start up all VxVM vol

SYMBOLIC NAMERMO_ERROR_DROP_ASMDGMESSAGE3PAR1262: ERROR: Could not drop one or more ASM snapshot disk groups.REASONThe SQL command to drop one or more

MESSAGE ID1266SYMBOLIC NAMERMO_ERROR_BACKUP_NOT_CONFIGUREMESSAGE3PAR1266: ERROR: Recovery Manager has not been configured for backup/restore.REASONThe

The operation to use Oracle RMAN and a NetBackup policy with Oracle type to backup a databasefailed.SOLUTIONCheck NetBackup log files and the Recovery

MESSAGE ID1273SYMBOLIC NAMERMO_ERROR_RETRIEVE_DBNAMEMESSAGE3PAR1273: ERROR: Could not retrieve the current database name.REASONDuring rmora_restore, R

SYMBOLIC NAMERMO_ERROR_ARCHLOG_RESTOREMESSAGE3PAR1276: ERROR: Archive logs will be restored automatically during media recovery usingOracle RMAN.REASO

MESSAGE3PAR1279: ERROR: The host <host name> is neither the backup server or the original host.Use '-H' option to specify the Oracle H

Make sure TPDSYSNAME and TPDUSERNAME to access the specified HP 3PAR StoreServ Storagesystem are correct. Make sure the Remote Copy and Remote copy gr

3PAR1304: ERROR: Control file ASM disk group <name> not found.REASONDuring rmora_createdb process, the error occurs when:• A non-default clone l

/usr/openv/netbackup/include_list.<policy_name> file, which contains a list offiles on the Virtual Copy for backup.• Once the backup process is

SOLUTIONUser specified a non-existing host definition for the backup server on the HP 3PAR Storage system.Use the showhost command on the HP 3PAR Stor

Make sure the current user has read-write permission to the repository directory /etc/3par/solutions/<db_server>.ora.<oracle_sid>/<vc_n

The LVM pvremove command, which is used to remove LVM physical volumes from a snapshotvolume group, has failed.SOLUTIONSee the preceding error message

MESSAGE3PAR1341: ERROR: Failed to retrieve the client name for NetBackup policy '%s'.REASONThe client name of a NetBackup policy cannot be r

IndexAarchive log backupconfiguring NBU policy, 47Bbackup server to HP 3PAR StoreServ Storage system SSHconnection, 43backup to database server verifi

requirementsstandby databases, 9restrictions with SSH, 39RMAN recovery catalog creation, 54rmora_create, 76rmora_createdb, 80rmora_display, 82rmora_mo

The Database Restoration UtilityThe database restoration utility of HP 3PAR Recovery Manager Software for Oracle restoresdatabases, tablespaces, dataf

Recovery Manager for Oracle with Oracle Standby DatabaseAll HP 3PAR Recovery Manager Software for Oracle’s utilities can be run against an Oraclephysi

Recovery Manager for Oracle with Remote CopyRecovery Manager for Oracle integrates with HP 3PAR Remote Copy Software to copy databasevirtual volumes f

NOTE: For more details about using the tunevv command, see the HP 3PAR OperatingSystem Software User Guide.3. On HP 3PAR StoreServ Storage system, ent

2 Installing and Uninstalling Recovery ManagerThis chapter describes how to install, verify, and remove HP 3PAR Recovery Manager Softwarefor Oracle on

◦ If you install the NetBackup for Oracle client, you must link the Oracle libobk.so libraryon the database and backup servers to point to the Symante

• Refer to the HP 3PAR Implementation Guides for instructions on setting up connections fromhosts to the HP 3PAR StoreServ Storage systems and reservi

InstallationThe following section describes the steps necessary for installing or upgrading Recovery Managerfor Oracle on a Linux system.To install or

Contents1 Overview of Recovery Manager Operations...7Virtual Copies...

5. After the installation is complete on all the required servers, you can allow Oracle users andDatabase Administrators group access to the Recovery

If you are not using the backup server as the NetBackup master server, be sure to install RecoveryManager for Oracle on the NetBackup master server.In

2. Insert the HP 3PAR Recovery Manager CD into a CD-ROM drive.If the CD is not mounted automatically, mount it manually.# mount -F hsfs -o ro /dev/dsk

4. Enter ./rmora_install.sh.The prompts and output from running rmora_install.sh are similar to those when runningrmora_install.sh on Linux. If necess

Installing Recovery Manager for Oracle on IBM AIX SystemsUse the instructions in this section to install Recovery Manager for Oracle on the database a

SUCCESSES--------- Filesets listed in this section passed pre-installation verification and will be installed. Selected Filesets -----------------

2. Enter the lslpp -l RMOra.rte command and verify:• The Product Fileset name RMOra.rte, State and Description are displayed.• The level displayed is

4. Enter ./rmora_uninstall.sh.Confirm you want to uninstall Recovery Manager for Oracle when prompted.Welcome to HP 3PAR Recovery Manager for OracleCh

3 Configuring Recovery Manager for OracleRecovery Manager for Oracle requires that an SSH connection be configured for the backup server,the database

Figure 2 SSH Connection Relationship for Remote Copy SupportSSH RestrictionsRecovery Manager for Oracle has the following SSH restrictions:• The ssh a

Installing Recovery Manager for Oracle on IBM AIX Systems...34Installation...

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 nob. I

Setting Up Connections from the Backup Server to the Database ServerTo set up an SSH connection from the backup server to the database server:• Copy t

yes Warning: Permanently added '<NBU_master>' (DSS) to the list of known hosts.where <user> is either the root or the Oracle ow

4. Copy the public key of the backup server to the HP 3PAR StoreServ Storage system. You canfind the public key in the location specified when generat

Setting Connections from the Database Server to the HP 3PAR StoreServ StorageSkip this step if the database server has the same SSH key pair as the SS

4. Copy the public key of the database server to the HP 3PAR StoreServ Storage system.<db_server># ssh <username>@<ss_name><usern

Setting up National Language Host SupportThe Recovery Manager for Oracle message catalog and the symbolic link are installed in thefollowing locations

NOTE: This section is intended for the users who are familiar with the Oracle Database andSymantec NetBackup (NBU). For more information on creating a

be set to at least 600 seconds (10 minutes) to allow enough time for Recovery Manager to performall necessary operations prior to the actual backup.Fo

# /opt/omni/sbin/omnisv startConfiguring Oracle Operating System User Account (Oracle Owner Account)The Oracle operating system user is the owner of t

rmora_display...82rmora_export...

An HP Data Protector Oracle backup specification must be created as follows:• A backup specification must be an Oracle backup specification, not a fil

• Backup Specification Option:Pre-exec:◦– Pre-exec: Specifiy DP_pre.<backup_specification_name>.– On client: The host name of the Recovery Manag

ORbackup format 'backup_specification <app_name_%s:%t:%p>.dbf archivelog all not backed up 1 times skip inaccessible;• If control file ob

In addition, you must create an Oracle RMAN Recovery Catalog and configure Oracle TNS Serviceand Listener to allow connections to the Recovery Catalog

This procedure is to backup archive logs only. For Recovery Manager for Oracle to perform backupand restoration correctly, you must use the following

where:• <tbs_name> is the tablespace name of the Recovery Catalog.• <rman_user> is the user name to be granted access permission to the Re

When using RMAN backup with HP Data Protector, if the Oracle release of the recovery catalogdatabase is 11g R2 or later:• Ensure that the owner of the

• 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

• HP 3PAR StoreServ Storage user name for the backup server[h=help,q=quit]?Recovery Manager for Oracle requires that a HP 3PAR OS Software user must b

• Do you want to remove oldest Virtual Copy when the maximum numberof Virtual Copy is reached [y=yes,n=no,q=quit]?You will be prompted with this quest

7 Using Remote Copy with Recovery Manager...118Overview...

• NetBackup full schedule name for policy 'your policyname'[h=help,s=skip,q=quit]?You will be prompted with this question only if you previo

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 display

• Create one or two Remote Copy groups, assign all virtual volumes used by datafiles andarchive log destinations to one group if only one group is cre

Press ENTER to accept the default value, or enter the ORACLE_HOME of the ASM instanceon the database server.• Oracle Home of ASM instance on the backu

day, or 'h' or 'H' for hours after the amount of time. The default value, '0d', means theVirtual Copy has no expiration

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 display

4 Using the Recovery Manager Command Line InterfaceThis chapter describes the Recovery Manager for Oracle command line utilities.NOTE: The command lin

method, a database can be backed up to a local disk (Symantec NetBackup or HP Data Protectoris not required) or to a tape using Symantec NetBackup or

backup (archlog). Refer to Recovery Manager User's Guide for detail on how to create HPData Protector Backup Specification.Depending on which bac

The host name of the database server, on which the Oracle database instance is running. Thevalue of the database server name must match the output of

1 Overview of Recovery Manager OperationsRecovery Manager for Oracle offers a specific data protection solution that has been enhancedto provide rapid

This option is only applicable for Oracle RMAN with HP Data Protector backup. This option canbe used with the -o online|offline|datafile option to per

rmora_checkconfigSYNTAXrmora_checkconfig -s <oracle_sid> -p <db_server>[-o all|skipdatabase|databaseonly] [-v]DESCRIPTIONThe rmora_checkco

changes the permissions and owners of the necessary files and directories in order to enable anOracle binary owner to operate Recovery Manager for Ora

rmora_configSYNTAXrmora_config [-s <oracle> -p <db_server> [-l]]DESCRIPTIONThe rmora_config command creates or modifies the Recovery Manag

the current time, that the volume will be retained. To specify a retention time, specify a valuebetween 1 to 43,800 hours (1825 days).Retention time c

• DBFILE_SCHED_FULL - The Symantec NetBackup schedule name for database backup. Thisparameter is applicable only to the Symantec NetBackup backup meth

rmora_createSYNTAXrmora_create -s <oracle_sid> -p <db_server>[ -o online|offline|datafile|archlog][ -r <retention_time>{d|D|h|H} -f]

When creating an online or datafile Virtual Copy:• If the specified database instance is a regular database, the database will be temporarily putinto

OPTIONSThe following options are supported:-s <oracle_sid>The Oracle SID of the database instance. For Real Application Cluster (RAC) database,

NOTE: HP 3PAR Operating System Software CLI command showsys -param and showdomain-d can be used to check the value of VVRetentionTimeMax for value sys

where:• <db_server> is the host name of the database server.• <oracle_sid> is the Oracle SID of the database instance.The following exampl

rmora_createdbSYNTAXrmora_createdb -s <oracle_sid> -p <db_server> -t <timestamp>[-n <clone_sid>] [-h <clone_ora_home>][-

OPTIONSThe following options are supported:-s <oracle_sid>The Oracle SID of the database instance. For Real Application Cluster (RAC) database,

rmora_displaySYNTAXrmora_display -s <oracle_sid> -p <db_server> [-t <timestamp>] [-r]DESCRIPTIONThe rmora_display command displays d

Displays the Virtual Copy’s retention and expiration time. This option is only available for HP 3PAROperating System Software 2.3.1 or , otherwise, th

rmora_exportSYNTAXrmora_export -s <oracle_sid> -p <db_server> -t <timestamp>-r <alt_backup_server> -e <alt_tpdusername>[

HP 3PAR StoreServ Storage system user can be created using the HP 3PAR Operating SystemSoftware CLI createuser command. The created user must be assig

rmora_mountSYNTAXrmora_mount -s <oracle_sid> -p <db_server> -t <timestamp>[-m <mountpoint>] [-r] [-v]DESCRIPTIONThe rmora_moun

• Imports snapshot LVM volume groups and activates all corresponding LVM snapshot volumesif the database files reside on LVM volumes.• For Virtual Cop

rmora_removeSYNTAXrmora_remove -s <oracle_sid> -p <db_server> -t <timestamp> [-v]DESCRIPTIONThe rmora_remove command removes a datab

rmora_removedbSYNTAXrmora_removedb -s <oracle_sid> -p <db_server> -t <timestamp>[-n <clone_sid>] [-h <clone_ora_home>] [

To ensure that the database is running in automatic archive log mode, use SQL*Plus utility to ensurethe Database log mode is Archive Mode and that Aut

rmora_restoreSYNTAXrmora_restore -s <oracle_sid> -p <db_server> [-t <timestamp>][-T <tablespaces>] [-D <dbf1,dbf2,...>]

image cannot be seen from the Recovery Catalog from the primary (production) database.To restore, the following steps must be performed manually:◦ The

-t <timestamp>The timestamp of a Virtual Copy whose backup image is used for restoration. Use thermora_display command to retrieve a list of the

rmora_rmrepSYNOPSISrmora_rmrep -s <oracle_sid> -p <db_server> [-t <timestamp>] [-f] [-v]DESCRIPTIONThe rmora_rmrep command removes a

rmora_rollbackSYNOPSISrmora_rollback -s <oracle_sid> -p <db_server> -t <timestamp>[-o data|arch] [-v] [-w] [-f]DESCRIPTIONThe rmora_

The corresponding host name of the database server where the specified Oracle database instanceis running. The value of the database server name must

rmora_rsyncSYNTAXrmora_rsync -s <oracle_sid> -p <db_server> [-l <local_backup_server>][ -o online|offline|validate] [ -r <retenti

To use the rmora_rsync command, the following requirements must be satisfied:• Each database instance must be started up using either a parameter file

-o onlineCreate an online database Virtual Copy in Remote Copy or Synchronous Long Distanceconfiguration. The specified database instance must be onli

rmora_setSYNTAXrmora_set -s <oracle_sid> -p <db_server> -t <timestamp>[-r <time> d|D|h|H] [-f] [-e <time> d|D|h|H>] [