HP StoreServ Application Suite for Oracle Media specification

Recovery Manager for Oracle User’s Guide

Press ENTER to accept default value or enter the ORACLE_HOME location on the backup

host.

◆Enter ORACLE_HOME of ASM instance on the primary server [h=help,q=quit]?

Recovery Manager provides a default value for the ORACLE_HOME of the ASM instance on the primary host if it can be retrieved from the oratab file.

Press ENTER to accept the default value or enter ORACLE_HOME of the ASM instance on the primary host.

◆Enter ORACLE_HOME of ASM instance on the backup server [h=help,q=quit]?

Recovery Manager assumes that the ORACLE_HOME of the ASM instance on the backup host is the same as the ORACLE_HOME on the primary host.

Press ENTER to accept the default value or enter ORACLE_HOME of the ASM instance on the backup host.

◆Enter Oracle parameter file of the database instance [h=help,q=quit]?

The Oracle parameter file can be either a pfile or an spfile. Recovery Manager recommends that an spfile is used, especially if the database is an RAC database.

Recovery Manager provides a default value for the Oracle parameter file if it can be retrieved from the specified database itself.

Press ENTER to accept default value, or enter a correct value for the Oracle parameter file.

◆Enter Oracle password file of the database instance [h=help,s=skip,q=quit]?

Recovery Manager provides a default value for the Oracle password file of the specified database instance. If the database does not have a password file, enter s or S to skip.

Press ENTER to accept the default value or enter the Oracle password file of the specified database instance.

◆Do you want to setup configuration for remote copy? [y,n,q]? (n)

Select n if this configuration is not for 3PAR Remote Copy.

◆Enter InServ name [h=help,q=quit]?

Recovery Manager Configuration Files

4.29

Image 77

HP StoreServ Application Suite for Oracle Media manual Do you want to setup configuration for remote copy? y,n,q? n

Contents

3PAR Inc Technology Drive Fremont, CA 94538 U.S.A Reader Comments and Suggestions Table of Contents Installing and Deinstalling Recovery Manager Setting Up SSH Connections for Recovery Manager Using Recovery Manager from the Menu-Driven Application Vii Viii IX Index RH Revision History Table of Contents Introduction Related Documents Audience Organization Found 12 73G disks Typographical ConventionsABCDabcd Advisories Advisories Overview of Recovery Manager Operations Virtual Copies Etc/3par/solutions/Host1.ora.test About the Recovery Manager RepositoryEtc/3par/solutions/primaryhost.ora.oraclesid Interacting with Oracle Interacting with Veritas Volume Manager Interacting with Veritas NetBackup and Oracle Rman Database Configuration Utility Recovery Manager UtilitiesEtc/3par/solutions/primaryhost.ora.oraclesid/config Etc/3par/solutions/primaryhost.ora.oraclesid/configexp.sh Recovery Manager Utilities Database Virtual Copy Display Utility Virtual Copy Mount Utility Virtual Copy Unmount Utility Database Cloning Utility Virtual Copy Export Utility Vcname Virtual Copy Repository Etc/3par/solutions/primaryhost.ora.oraclesid/timestampCloned Database Removal Utility Virtual Copy Removal Utility Database Rollback Utility Virtual Copy PolicyDatabase Rollback from a Virtual Copy Database Backup Utility Recovery Manager and Third-Party Backup Tools Immediate Backup Automatic Backup Recovery Manager and Third-Party Backup Tools Database Restoration Utility Recovery Manager with Remote Copy Recovery Manager with Remote Copy Installing and Deinstalling Recovery Manager Referencing the Support Matrix Preinstallation Requirements Preinstallation Requirements Starting Installation Installing Recovery Manager on Linux Systems# mount -t iso9660 -r /dev/cdrom /mnt/cdrom # cd /mnt/cdrom0 PM PDT Verifying Installation Installing Recovery Manager on Solaris Systems Removing Recovery Manager from Linux Systems#chmod 550 /opt/3par/vcdbaora # rpm -e VCDBAora # mount -F hsfs -o ro /dev/dsk/c0t6d0s2/cdrom Showrev -p grep# cd /cdrom/cdrom0 # pkgadd -d . VCDBAora 166294 Blocks used approx Completely installedInstdate Jan 19 2007 1521 Hotline Salesinfo@3pardata.com # pkgrm VCDBAora Removing Recovery Manager from Solaris Systems Removing Recovery Manager from Solaris Systems Configuring Recovery Manager Setting Up Connections on Recovery Manager CLI Setting up RSH/CLI Connections for Recovery Manager RSH/CLI Connection Relationship for Remote Copy Support Backuphost user Backuphost# rsh nbumaster ls Backuphost# rsh primaryhost lsBackuphost rootuser Where username is the username you created in step Primaryhost# showsys Createuser command Backuphost# showsys SSH Connection Relationship Setting Up SSH Connections for Recovery Manager SSH Restrictions Modifying the SSH Daemon Configuration Generating an SSH Key Pair for the Primary Host Generating an SSH Key Pair for the Backup HostPermitRootLogin yes Etc/ssh/sshdconfig Root@pilots password Primaryhost # scp backuphost~/.ssh/* ~/.ssh Authorizedkeys file Backuphost# ssh root@primaryhost Authenticity of host NBUmaster cant be established Cli% createuser -c password username all edit Backuphost# ssh username@ssname usernames password password Authenticity of host ssname cant be established Backuphost# ssh username@ssname Primaryhost# ssh username@ssname usernames password password # NLSPATH=$NLSPATH/usr/lib/locale/%L/%N # export Nlspath Setting up National Language Host Support Setting up a Search Path on Both Primary and Backup Hosts Setting up Manual Pages on Both Primary and Backup HostsSetting Up NetBackup Policies for NBU User-Managed Backup # PATH=$PATH/opt/3par/vcdbaora/bin # export Path Incremental options Configuring the NetBackup Policy for Database Backup Clientname = virtualhostname Configuring the NetBackup Policy for Archive Log BackupSetting Up NetBackup Configuration Parameters Setting Up NetBackup Policies for Oracle Rman Backup Primaryhost.ora.oraclesid/vcdbanbudbbackup.sh Primaryhost.ora.oraclesid Creating an Rman Recovery CatalogVcdbanbuarchbackup.sh $ export ORACLESID=catdb Rmanpassword is the password for the rmanuser Sidlistlistener = Sidlist = Catdb = description = Backup host# opt/3par/vcdbaora/bin/vcdbamain Recovery Manager Configuration Files Enter Oraclehome on the backup host h=help,s=skip,q=quit? Select remote shell command r=rsh,s=ssh,h=help,q=quit?Enter Oraclesid of the database instance h=help,q=quit? Enter Oraclehome on the primary host h=help,q=quit? Enter InServ name h=help,q=quit? Do you want to setup configuration for remote copy? y,n,q? n Enter InServs user name for the backup host h=help,q=quit? Enter 3PAR password file on primary host h=help,q=quit?Enter 3PAR password file on backup host h=help,q=quit? Enter InServs user name for primary host h=help,q=quit? Enter number of channels to be allocated h=help,q=quit? Enter NetBackup master server name h=help,q=quit?Enter Oracle Rman channel type d=DISK,s=SBTTAPE,h,q? Enter NetBackup policy name for archivelog backup h,q? Backup host# /opt/3par/vcdbaora/bin/vcdbagui Backup host# xhost +Backup host# echo $DISPLAY Recovery Manager Configuration Files Host and Database Properties screens appear Recovery Manager Configuration Files Recovery Manager Policy screen appears Vendor Backup Product Properties screen appears Etc/3par/solutions/primaryhost.ora.oraclesid/gui Etc/3par/solutions/primaryhost.ora.oraclesid/config Backuphost# /opt/3par/vcdbaora/bin/vcdbamain Enter Oraclesid of the database instance h,q? Enter Oraclehome on the backup host h=help,q=quit?Enter Oraclehome of ASM instance on the backup host h,q? Enter Primary/Local InServ name h=help,q=quit? Enter Oracle parameter file of the database instance h,q? Enter Primary/Local InServs user name h=help,q=quit? Enter Secondary/Remote InServ name h=help,q=quit? Backuphost# echo $DISPLAY Backuphost# xhost +Backuphost# /opt/3par/vcdbaora/bin/vcdbagui Enter Secondary/Remote InServs user name h=help,q=quit? Host and Database Properties screen appears Recovery Manager Configuration Files Recovery Manager Configuration Files Recovery Manager Configuration Files Recovery Manager Configuration Files Recovery Manager Configuration Files Using Recovery Manager from the Menu-Driven Application Managing Virtual Copies Starting the Menu-Driven Application Displaying Virtual Copies Removing a Virtual Copy Creating a Virtual Copy Exporting a Virtual Copy Mounting a Virtual CopyUnmounting a Virtual Copy Removing a Virtual Copy’s Repository Setting Virtual Copy Policy Backing Up Virtual Copies Performing Immediate BackupsBackup Archive Log Destination Backup Archive Logs Destination Performing Automatic BackupsBackup Database Performing Restores Performing Restores Performing Periodic Remote Copy Using the Recovery Manager Command Line Interface Recovery Manager for Oracle User’s Guide Syntax Vcdbabackup Command Options Command Vcdbacheckconfig Primaryhost.ora.oraclesid/config VcdbaconfigVcdbaconfig -s oraclesid -p primaryhost Command Command Options Vcdbacreate Options Command Vcdbacreatedb Options Command Vcdbadisplay -s oraclesid -p primaryhost -t timestamp Vcdbadisplay Vcdbadisplay -s TEST920 -p pilot -t Vcdbadisplay -s TEST920 -p pilot Vcdbaexport Alttpdpwfilealttpdusername Vcdbamain Command Vcdbamount Options Command Vcdbaremove -s oraclesid -p primaryhost -t timestamp Vcdbaremove Vcdbaremovedb Command Vcdbarestore Command Options Vcdbarmrep -s oraclesid -p primaryhost -t timestamp -f Vcdbarmrep Command Vcdbarollback Dataarch Vcdbarsync Command Vcdbaumount -s oraclesid -p primaryhost -t timestamp -f Vcdbaumount Options Using the Recovery Manager Graphical User Interface Starting the GUI Starting and Stopping the Recovery Manager GUIStopping the GUI Removing Configuration Files Creating Configuration FilesModifying Configuration Files Using Virtual Copies Refreshing Virtual Copy Information Setting up Virtual Copy Policy Mounting a Virtual Copy Removing a Virtual Copy Repository Backing up a Virtual Copy Refreshing Database Information Restoring Datafiles Cloning a Database Exporting a Virtual Copy to an Alternate Backup Host Removing a Cloned Database Periodic Database Synchronization Verifying the Periodic Synchronization Process Removing the Recovery Manager Periodic Sync LockStarting Periodic Synchronization Refreshing Remote Copy Information Using the Recovery Manager Rollback Utility Vcdbarollback Usage Database Volumes Not Under Veritas VxVM ControlRollback with Read-Only Virtual Copies Removevlun Oracledata1 101 pilot Createvlun Oracledata1 101 pilot Rollback with Read-Write Virtual Copies Database Volumes Under Veritas VxVM Control Vcdbarollback -s TEST920 -p pilot -t 042903142921 -v -w Vxvol -g arch920dg startall Pilot# vxdisk list ErrorC0t0d0s2 C2t0d0s2 Vcdbarollback -s TEST920 -p pilot -t 042903142921 Database Volumes Under Veritas VxVM Control Using Remote Copy with Recovery Manager Opt/3par/vcdbaora/bin/vcdbarsync Overview Etc/3par/solutions/right.ora.ISS920/032103170642 System ConfigurationRecovery Manager’s Remote Copy Requirements System Configuration Verifying the Primary/Local Remote Copy Setting Verifying Remote Copy SettingsPrimaryhost# ssh username@ssname Cli% showport -rcip Backuphost# ssh username@ssname Verifying the Secondary/Remote Copy SettingCli% showrcopy targets targetname Creatercopytarget Cli% showrcopy groups groupname Startrcopygroup groupname Syncrcopy groupname command Available Or found Using Remote CopyEagle IPC transport error Eaprocessdown Using Remote Copy Index IX.2 IX.3 IX.4 Revision History RH.2