Manuals / HP / Computer Equipment / Software

HP StoreServ Application Suite for Oracle Media manual Introduction

Models: StoreServ Application Suite for Oracle Media

1 184

Download 184 pages 48.7 Kb

Page 11

Recovery Manager for Oracle User’s Guide

1 Introduction

In this chapter

1.1	Audience	1.2
1.2	Related Documents	1.2
1.3	Organization	1.3
1.4	Typographical Conventions	1.4
1.5	Advisories	1.5

This user’s guide provides the information needed to install, configure, and use the 3PAR Recovery Manager 3.0.2 for Oracle on Solaris and Red Hat Linux®. Recovery Manager 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 enables off-host backup of an Oracle database to tape, minimizing any impact to the production Oracle server.

Introduction

1.1

Image 11

HP StoreServ Application Suite for Oracle Media manual Introduction

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 AudienceOrganization 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/configexp.sh Recovery Manager UtilitiesDatabase Configuration Utility Etc/3par/solutions/primaryhost.ora.oraclesid/configRecovery Manager Utilities Database Virtual Copy Display UtilityVirtual Copy Mount Utility Virtual Copy Unmount Utility Database Cloning Utility Virtual Copy Export UtilityVcname Virtual Copy Removal Utility Etc/3par/solutions/primaryhost.ora.oraclesid/timestampVirtual Copy Repository Cloned Database Removal UtilityDatabase Rollback Utility Virtual Copy PolicyDatabase Rollback from a Virtual Copy Database Backup Utility Recovery Manager and Third-Party Backup ToolsImmediate 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 RequirementsPreinstallation Requirements # cd /mnt/cdrom0 Installing Recovery Manager on Linux SystemsStarting Installation # mount -t iso9660 -r /dev/cdrom /mnt/cdromPM PDT Verifying Installation# rpm -e VCDBAora Removing Recovery Manager from Linux SystemsInstalling Recovery Manager on Solaris Systems #chmod 550 /opt/3par/vcdbaora# pkgadd -d . VCDBAora Showrev -p grep# mount -F hsfs -o ro /dev/dsk/c0t6d0s2/cdrom # cd /cdrom/cdrom0166294 Blocks used approx Completely installedInstdate Jan 19 2007 1521 Hotline Salesinfo@3pardata.com # pkgrm VCDBAora Removing Recovery Manager from Solaris SystemsRemoving Recovery Manager from Solaris Systems Configuring Recovery Manager Setting Up Connections on Recovery Manager CLI Setting up RSH/CLI Connections for Recovery ManagerRSH/CLI Connection Relationship for Remote Copy Support Backuphost userBackuphost# rsh nbumaster ls Backuphost# rsh primaryhost lsBackuphost rootuser Where username is the username you created in step Primaryhost# showsys Createuser commandBackuphost# showsys SSH Connection Relationship Setting Up SSH Connections for Recovery ManagerSSH Restrictions Modifying the SSH Daemon ConfigurationGenerating 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/* ~/.sshAuthorizedkeys file Backuphost# ssh root@primaryhostAuthenticity of host NBUmaster cant be established Cli% createuser -c password username all editBackuphost# ssh username@ssname usernames password password Authenticity of host ssname cant be established Backuphost# ssh username@ssnamePrimaryhost# ssh username@ssname usernames password password # NLSPATH=$NLSPATH/usr/lib/locale/%L/%N # export Nlspath Setting up National Language Host Support# PATH=$PATH/opt/3par/vcdbaora/bin # export Path Setting up Manual Pages on Both Primary and Backup HostsSetting up a Search Path on Both Primary and Backup Hosts Setting Up NetBackup Policies for NBU User-Managed BackupIncremental options Configuring the NetBackup Policy for Database BackupClientname = 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 rmanuserSidlistlistener = Sidlist = Catdb = description =Backup host# opt/3par/vcdbaora/bin/vcdbamain Recovery Manager Configuration FilesEnter Oraclehome on the primary host 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 Oraclesid of the database instance h=help,q=quit?Enter InServ name h=help,q=quit? Do you want to setup configuration for remote copy? y,n,q? nEnter InServs user name for primary 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 3PAR password file on backup 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/configBackuphost# /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?Enter Secondary/Remote InServs user name h=help,q=quit? Backuphost# xhost +Backuphost# echo $DISPLAY Backuphost# /opt/3par/vcdbaora/bin/vcdbaguiHost 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 ApplicationDisplaying Virtual Copies Removing a Virtual Copy Creating a Virtual CopyExporting a Virtual Copy Mounting a Virtual CopyUnmounting a Virtual Copy Removing a Virtual Copy’s Repository Setting Virtual Copy PolicyBacking Up Virtual Copies Performing Immediate BackupsBackup Archive Log Destination Backup Archive Logs Destination Performing Automatic BackupsBackup Database Performing Restores Performing RestoresPerforming Periodic Remote Copy Using the Recovery Manager Command Line Interface Recovery Manager for Oracle User’s Guide Syntax VcdbabackupCommand 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 VcdbadisplayVcdbadisplay -s TEST920 -p pilot -t Vcdbadisplay -s TEST920 -p pilotVcdbaexport Alttpdpwfilealttpdusername Vcdbamain Command Vcdbamount Options Command Vcdbaremove -s oraclesid -p primaryhost -t timestamp VcdbaremoveVcdbaremovedb Command Vcdbarestore Command Options Vcdbarmrep -s oraclesid -p primaryhost -t timestamp -f VcdbarmrepCommand Vcdbarollback Dataarch Vcdbarsync Command Vcdbaumount -s oraclesid -p primaryhost -t timestamp -f VcdbaumountOptions 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 PolicyMounting a Virtual Copy Removing a Virtual Copy Repository Backing up a Virtual CopyRefreshing Database Information Restoring DatafilesCloning a Database Exporting a Virtual Copy to an Alternate Backup HostRemoving a Cloned Database Periodic Database SynchronizationVerifying the Periodic Synchronization Process Removing the Recovery Manager Periodic Sync LockStarting Periodic Synchronization Refreshing Remote Copy Information Using the Recovery Manager Rollback Utility Removevlun Oracledata1 101 pilot Database Volumes Not Under Veritas VxVM ControlVcdbarollback Usage Rollback with Read-Only Virtual CopiesCreatevlun Oracledata1 101 pilot Rollback with Read-Write Virtual CopiesDatabase Volumes Under Veritas VxVM Control Vcdbarollback -s TEST920 -p pilot -t 042903142921 -v -w Vxvol -g arch920dg startallC2t0d0s2 ErrorPilot# vxdisk list C0t0d0s2Vcdbarollback -s TEST920 -p pilot -t 042903142921 Database Volumes Under Veritas VxVM Control Using Remote Copy with Recovery Manager Opt/3par/vcdbaora/bin/vcdbarsync OverviewEtc/3par/solutions/right.ora.ISS920/032103170642 System ConfigurationRecovery Manager’s Remote Copy Requirements System Configuration Cli% showport -rcip Verifying Remote Copy SettingsVerifying the Primary/Local Remote Copy Setting Primaryhost# ssh username@ssnameCreatercopytarget Verifying the Secondary/Remote Copy SettingBackuphost# ssh username@ssname Cli% showrcopy targets targetnameCli% showrcopy groups groupname Startrcopygroup groupname Syncrcopy groupname commandAvailable Or found Using Remote CopyEagle IPC transport error Eaprocessdown Using Remote Copy Index IX.2 IX.3 IX.4 Revision History RH.2