Command | HP StoreServ Application Suite for Oracle Media instruction

Recovery Manager for Oracle User’s Guide

■-o offline- Performs periodic synchronization for datafile virtual volumes while the database is CLOSED.

■-o coldbkup - This option is the same as the -o offline and is deprecated. This option will be removed in a future release.

■

■

-o checkonly - Verifies the Remote Copy configuration.

-v- Runs the command in verbose mode to display useful messages.

6.38

Command

Image 146

HP StoreServ Application Suite for Oracle Media manual Command

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 Audience Related Documents 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 Etc/3par/solutions/primaryhost.ora.oraclesid/config Recovery Manager UtilitiesDatabase Configuration Utility Etc/3par/solutions/primaryhost.ora.oraclesid/configexp.sh Recovery Manager Utilities Virtual Copy Display Utility Database Virtual Copy Mount Utility Virtual Copy Unmount Utility Virtual Copy Export Utility Database Cloning Utility Vcname Cloned Database Removal Utility Etc/3par/solutions/primaryhost.ora.oraclesid/timestampVirtual Copy Repository Virtual Copy Removal Utility Database Rollback Utility Virtual Copy PolicyDatabase Rollback from a Virtual Copy Recovery Manager and Third-Party Backup Tools Database Backup Utility 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 Preinstallation Requirements Referencing the Support Matrix Preinstallation Requirements # mount -t iso9660 -r /dev/cdrom /mnt/cdrom Installing Recovery Manager on Linux SystemsStarting Installation # cd /mnt/cdrom0 Verifying Installation PM PDT #chmod 550 /opt/3par/vcdbaora Removing Recovery Manager from Linux SystemsInstalling Recovery Manager on Solaris Systems # rpm -e VCDBAora # cd /cdrom/cdrom0 Showrev -p grep# mount -F hsfs -o ro /dev/dsk/c0t6d0s2/cdrom # pkgadd -d . VCDBAora 166294 Blocks used approx Completely installedInstdate Jan 19 2007 1521 Hotline Salesinfo@3pardata.com Removing Recovery Manager from Solaris Systems # pkgrm VCDBAora Removing Recovery Manager from Solaris Systems Configuring Recovery Manager Setting Up Connections on Recovery Manager Setting up RSH/CLI Connections for Recovery Manager CLI Backuphost user RSH/CLI Connection Relationship for Remote Copy Support Backuphost# rsh nbumaster ls Backuphost# rsh primaryhost lsBackuphost rootuser Where username is the username you created in step Createuser command Primaryhost# showsys Backuphost# showsys Setting Up SSH Connections for Recovery Manager SSH Connection Relationship Modifying the SSH Daemon Configuration SSH Restrictions Generating an SSH Key Pair for the Primary Host Generating an SSH Key Pair for the Backup HostPermitRootLogin yes Etc/ssh/sshdconfig Primaryhost # scp backuphost~/.ssh/* ~/.ssh Root@pilots password Backuphost# ssh root@primaryhost Authorizedkeys file Cli% createuser -c password username all edit Authenticity of host NBUmaster cant be established Backuphost# ssh username@ssname usernames password password Backuphost# ssh username@ssname Authenticity of host ssname cant be established Primaryhost# ssh username@ssname usernames password password Setting up National Language Host Support # NLSPATH=$NLSPATH/usr/lib/locale/%L/%N # export Nlspath Setting Up NetBackup Policies for NBU User-Managed Backup Setting up Manual Pages on Both Primary and Backup HostsSetting up a Search Path on Both Primary and Backup Hosts # PATH=$PATH/opt/3par/vcdbaora/bin # export Path Configuring the NetBackup Policy for Database Backup Incremental options 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 Rmanpassword is the password for the rmanuser $ export ORACLESID=catdb Catdb = description = Sidlistlistener = Sidlist = Recovery Manager Configuration Files Backup host# opt/3par/vcdbaora/bin/vcdbamain Enter Oraclesid of the database instance h=help,q=quit? Select remote shell command r=rsh,s=ssh,h=help,q=quit?Enter Oraclehome on the backup host h=help,s=skip,q=quit? Enter Oraclehome on the primary host h=help,q=quit? Do you want to setup configuration for remote copy? y,n,q? n Enter InServ name h=help,q=quit? Enter 3PAR password file on backup host h=help,q=quit? Enter 3PAR password file on primary host h=help,q=quit?Enter InServs user name for the 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/config Etc/3par/solutions/primaryhost.ora.oraclesid/gui 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 Oracle parameter file of the database instance h,q? Enter Primary/Local InServ name h=help,q=quit? Enter Secondary/Remote InServ name h=help,q=quit? Enter Primary/Local InServs user name h=help,q=quit? Backuphost# /opt/3par/vcdbaora/bin/vcdbagui Backuphost# xhost +Backuphost# echo $DISPLAY 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 Starting the Menu-Driven Application Managing Virtual Copies Displaying Virtual Copies Creating a Virtual Copy Removing a Virtual Copy Exporting a Virtual Copy Mounting a Virtual CopyUnmounting a Virtual Copy Setting Virtual Copy Policy Removing a Virtual Copy’s Repository 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 Vcdbabackup Syntax Command Options Command Vcdbacheckconfig Primaryhost.ora.oraclesid/config VcdbaconfigVcdbaconfig -s oraclesid -p primaryhost Command Command Options Vcdbacreate Options Command Vcdbacreatedb Options Command Vcdbadisplay Vcdbadisplay -s oraclesid -p primaryhost -t timestamp Vcdbadisplay -s TEST920 -p pilot Vcdbadisplay -s TEST920 -p pilot -t Vcdbaexport Alttpdpwfilealttpdusername Vcdbamain Command Vcdbamount Options Command Vcdbaremove Vcdbaremove -s oraclesid -p primaryhost -t timestamp Vcdbaremovedb Command Vcdbarestore Command Options Vcdbarmrep Vcdbarmrep -s oraclesid -p primaryhost -t timestamp -f Command Vcdbarollback Dataarch Vcdbarsync Command Vcdbaumount Vcdbaumount -s oraclesid -p primaryhost -t timestamp -f 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 Setting up Virtual Copy Policy Refreshing Virtual Copy Information Mounting a Virtual Copy Backing up a Virtual Copy Removing a Virtual Copy Repository Restoring Datafiles Refreshing Database Information Exporting a Virtual Copy to an Alternate Backup Host Cloning a Database Periodic Database Synchronization Removing a Cloned Database Verifying the Periodic Synchronization Process Removing the Recovery Manager Periodic Sync LockStarting Periodic Synchronization Refreshing Remote Copy Information Using the Recovery Manager Rollback Utility Rollback with Read-Only Virtual Copies Database Volumes Not Under Veritas VxVM ControlVcdbarollback Usage Removevlun Oracledata1 101 pilot Rollback with Read-Write Virtual Copies Createvlun Oracledata1 101 pilot Database Volumes Under Veritas VxVM Control Vxvol -g arch920dg startall Vcdbarollback -s TEST920 -p pilot -t 042903142921 -v -w C0t0d0s2 ErrorPilot# vxdisk list C2t0d0s2 Vcdbarollback -s TEST920 -p pilot -t 042903142921 Database Volumes Under Veritas VxVM Control Using Remote Copy with Recovery Manager Overview Opt/3par/vcdbaora/bin/vcdbarsync Etc/3par/solutions/right.ora.ISS920/032103170642 System ConfigurationRecovery Manager’s Remote Copy Requirements System Configuration Primaryhost# ssh username@ssname Verifying Remote Copy SettingsVerifying the Primary/Local Remote Copy Setting Cli% showport -rcip Cli% showrcopy targets targetname Verifying the Secondary/Remote Copy SettingBackuphost# ssh username@ssname Creatercopytarget Cli% showrcopy groups groupname Syncrcopy groupname command Startrcopygroup groupname Available Or found Using Remote CopyEagle IPC transport error Eaprocessdown Using Remote Copy Index IX.2 IX.3 IX.4 Revision History RH.2