Manuals / HP / Computer Equipment / Software

HP StoreServ Application Suite for Oracle Media manual Audience, Related Documents

Models: StoreServ Application Suite for Oracle Media

1 184

Download 184 pages 48.7 Kb

Page 12

Recovery Manager for Oracle User’s Guide

1.1 Audience

This is an installation and configuration guide for system administrators and database administrators who are responsible for backing up databases and who understand Sun™ Solaris™ and/or Linux, and are familiar with the Oracle10g™ and Oracle11g™ Databases.

1.2 Related Documents

The following documents also provide information related to the InServ Storage Server:

For Information About…	Read the…

CLI commands and their usage	3PAR InForm OS Command Line Interface
	Reference

Identifying storage server components and	3PAR InForm OS Messages and
detailed alert information	Operator’s Guide

Using the Command Line Interface (CLI) to	3PAR InForm OS CLI Administrator’s
configure and manage InServ Storage	Manual
Servers

Using the InForm Graphical User Interface	3PAR InForm Management Console
(GUI) to configure and administer InServ	Online Help
Storage Servers

Using 3PAR Remote Copy	3PAR Remote Copy User’s Guide

1.2

Audience

Image 12

HP StoreServ Application Suite for Oracle Media manual Audience, Related Documents

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 DocumentsOrganization Typographical Conventions ABCDabcdFound 12 73G disks Advisories Advisories Overview of Recovery Manager Operations Virtual Copies About the Recovery Manager Repository Etc/3par/solutions/primaryhost.ora.oraclesidEtc/3par/solutions/Host1.ora.test Interacting with Oracle Interacting with Veritas Volume Manager Interacting with Veritas NetBackup and Oracle Rman Recovery Manager Utilities Database Configuration UtilityEtc/3par/solutions/primaryhost.ora.oraclesid/config Etc/3par/solutions/primaryhost.ora.oraclesid/configexp.shRecovery Manager Utilities Virtual Copy Display Utility DatabaseVirtual Copy Mount Utility Virtual Copy Unmount Utility Virtual Copy Export Utility Database Cloning UtilityVcname Etc/3par/solutions/primaryhost.ora.oraclesid/timestamp Virtual Copy RepositoryCloned Database Removal Utility Virtual Copy Removal UtilityVirtual Copy Policy Database Rollback from a Virtual CopyDatabase Rollback Utility Recovery Manager and Third-Party Backup Tools Database Backup UtilityImmediate 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 MatrixPreinstallation Requirements Installing Recovery Manager on Linux Systems Starting Installation# mount -t iso9660 -r /dev/cdrom /mnt/cdrom # cd /mnt/cdrom0Verifying Installation PM PDTRemoving Recovery Manager from Linux Systems Installing Recovery Manager on Solaris Systems#chmod 550 /opt/3par/vcdbaora # rpm -e VCDBAoraShowrev -p grep # mount -F hsfs -o ro /dev/dsk/c0t6d0s2/cdrom# cd /cdrom/cdrom0 # pkgadd -d . VCDBAoraCompletely installed Instdate Jan 19 2007 1521 Hotline Salesinfo@3pardata.com166294 Blocks used approx Removing Recovery Manager from Solaris Systems # pkgrm VCDBAoraRemoving Recovery Manager from Solaris Systems Configuring Recovery Manager Setting Up Connections on Recovery Manager Setting up RSH/CLI Connections for Recovery Manager CLIBackuphost user RSH/CLI Connection Relationship for Remote Copy SupportBackuphost# rsh primaryhost ls Backuphost rootuserBackuphost# rsh nbumaster ls Where username is the username you created in step Createuser command Primaryhost# showsysBackuphost# showsys Setting Up SSH Connections for Recovery Manager SSH Connection RelationshipModifying the SSH Daemon Configuration SSH RestrictionsGenerating an SSH Key Pair for the Backup Host PermitRootLogin yes Etc/ssh/sshdconfigGenerating an SSH Key Pair for the Primary Host Primaryhost # scp backuphost~/.ssh/* ~/.ssh Root@pilots passwordBackuphost# ssh root@primaryhost Authorizedkeys fileCli% createuser -c password username all edit Authenticity of host NBUmaster cant be establishedBackuphost# ssh username@ssname usernames password password Backuphost# ssh username@ssname Authenticity of host ssname cant be establishedPrimaryhost# ssh username@ssname usernames password password Setting up National Language Host Support # NLSPATH=$NLSPATH/usr/lib/locale/%L/%N # export NlspathSetting up Manual Pages on Both Primary and Backup Hosts Setting up a Search Path on Both Primary and Backup HostsSetting Up NetBackup Policies for NBU User-Managed Backup # PATH=$PATH/opt/3par/vcdbaora/bin # export PathConfiguring the NetBackup Policy for Database Backup Incremental optionsConfiguring the NetBackup Policy for Archive Log Backup Setting Up NetBackup Configuration ParametersClientname = virtualhostname Setting Up NetBackup Policies for Oracle Rman Backup Primaryhost.ora.oraclesid/vcdbanbudbbackup.sh Creating an Rman Recovery Catalog Vcdbanbuarchbackup.shPrimaryhost.ora.oraclesid Rmanpassword is the password for the rmanuser $ export ORACLESID=catdbCatdb = description = Sidlistlistener = Sidlist =Recovery Manager Configuration Files Backup host# opt/3par/vcdbaora/bin/vcdbamainSelect 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 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 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 InServs user name for primary host 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 number of channels to be allocated h=help,q=quit? Enter NetBackup policy name for archivelog backup h,q? Backup host# xhost + Backup host# echo $DISPLAYBackup host# /opt/3par/vcdbaora/bin/vcdbagui 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/guiBackuphost# /opt/3par/vcdbaora/bin/vcdbamain Enter Oraclehome on the backup host h=help,q=quit? Enter Oraclehome of ASM instance on the backup host h,q?Enter Oraclesid of the database instance 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# xhost + Backuphost# echo $DISPLAYBackuphost# /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 Starting the Menu-Driven Application Managing Virtual CopiesDisplaying Virtual Copies Creating a Virtual Copy Removing a Virtual CopyMounting a Virtual Copy Unmounting a Virtual CopyExporting a Virtual Copy Setting Virtual Copy Policy Removing a Virtual Copy’s RepositoryPerforming Immediate Backups Backup Archive Log DestinationBacking Up Virtual Copies Performing Automatic Backups Backup DatabaseBackup Archive Logs Destination Performing Restores Performing RestoresPerforming Periodic Remote Copy Using the Recovery Manager Command Line Interface Recovery Manager for Oracle User’s Guide Vcdbabackup SyntaxCommand Options Command Vcdbacheckconfig Vcdbaconfig Vcdbaconfig -s oraclesid -p primaryhostPrimaryhost.ora.oraclesid/config Command Command Options Vcdbacreate Options Command Vcdbacreatedb Options Command Vcdbadisplay Vcdbadisplay -s oraclesid -p primaryhost -t timestampVcdbadisplay -s TEST920 -p pilot Vcdbadisplay -s TEST920 -p pilot -tVcdbaexport Alttpdpwfilealttpdusername Vcdbamain Command Vcdbamount Options Command Vcdbaremove Vcdbaremove -s oraclesid -p primaryhost -t timestampVcdbaremovedb Command Vcdbarestore Command Options Vcdbarmrep Vcdbarmrep -s oraclesid -p primaryhost -t timestamp -fCommand Vcdbarollback Dataarch Vcdbarsync Command Vcdbaumount Vcdbaumount -s oraclesid -p primaryhost -t timestamp -fOptions Using the Recovery Manager Graphical User Interface Starting and Stopping the Recovery Manager GUI Stopping the GUIStarting the GUI Creating Configuration Files Modifying Configuration FilesRemoving Configuration Files Using Virtual Copies Setting up Virtual Copy Policy Refreshing Virtual Copy InformationMounting a Virtual Copy Backing up a Virtual Copy Removing a Virtual Copy RepositoryRestoring Datafiles Refreshing Database InformationExporting a Virtual Copy to an Alternate Backup Host Cloning a DatabasePeriodic Database Synchronization Removing a Cloned DatabaseRemoving the Recovery Manager Periodic Sync Lock Starting Periodic SynchronizationVerifying the Periodic Synchronization Process Refreshing Remote Copy Information Using the Recovery Manager Rollback Utility Database Volumes Not Under Veritas VxVM Control Vcdbarollback UsageRollback with Read-Only Virtual Copies Removevlun Oracledata1 101 pilotRollback with Read-Write Virtual Copies Createvlun Oracledata1 101 pilotDatabase Volumes Under Veritas VxVM Control Vxvol -g arch920dg startall Vcdbarollback -s TEST920 -p pilot -t 042903142921 -v -wError Pilot# vxdisk listC0t0d0s2 C2t0d0s2Vcdbarollback -s TEST920 -p pilot -t 042903142921 Database Volumes Under Veritas VxVM Control Using Remote Copy with Recovery Manager Overview Opt/3par/vcdbaora/bin/vcdbarsyncSystem Configuration Recovery Manager’s Remote Copy RequirementsEtc/3par/solutions/right.ora.ISS920/032103170642 System Configuration Verifying Remote Copy Settings Verifying the Primary/Local Remote Copy SettingPrimaryhost# ssh username@ssname Cli% showport -rcipVerifying the Secondary/Remote Copy Setting Backuphost# ssh username@ssnameCli% showrcopy targets targetname CreatercopytargetCli% showrcopy groups groupname Syncrcopy groupname command Startrcopygroup groupnameUsing Remote Copy Eagle IPC transport error EaprocessdownAvailable Or found Using Remote Copy Index IX.2 IX.3 IX.4 Revision History RH.2