Command | HP StoreServ Application Suite for Oracle Media guide

Recovery Manager for Oracle User’s Guide

■If the database is an ASM managed database, all ASM disk groups must be mounted prior to running this command.

■For NBU (user-managed) restore, a file named /usr/openv/netbackup/db/altnames/ <database_hostname> must be created on the NBU master server in order to perform restoration to a host (including the primary host) that differs from the backup host. <database_hostname> is the host name of the database server to restore.

Depending on the type of the virtual copy backup image (online, offline, datafile, or archonly), corresponding database files are restored appropriately.

For NBU (user-managed) restore:

■Control files are not restored by default.

■For an online virtual copy, both data files and archive logs are restored unless individual tablespaces or data files are specified. In this case, only the corresponding data files are restored.

■For an offline virtual copy, only data files are restored.

■For a datafile only virtual copy, only data files are restored.

■For an archive log virtual copy, only archive logs are restored.

For Oracle RMAN restore:

■Control files are not restored by default.

■For an online virtual copy, only data files are restored. Archive logs are not restored to minimize restoration time. Oracle RMAN can restore necessary archive logs during recovery (refer to Oracle documentation for details on how to use Oracle RMAN for recovery).

■For an offline virtual copy, only data files are restored.

■For a datafile-only virtual copy, only data files are restored.

■For an archive log virtual copy, archive log restoration is not supported as Oracle RMAN can restore necessary archive logs during recovery (refer to Oracle documentation for details on how to use Oracle RMAN for recovery).

You must run this command as a super user from the backup host. To allow the Oracle Database Administrator (Oracle Owner) to run this command, an identical Oracle Database Administrator user must exist on backup host. In addition, permission on the 3PAR Recovery Manager Installation and Repository directories must be changed appropriately.

Command

6.31

Image 139

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 Related Documents Audience Organization ABCDabcd Typographical ConventionsFound 12 73G disks Advisories Advisories Overview of Recovery Manager Operations Virtual Copies Etc/3par/solutions/primaryhost.ora.oraclesid About the Recovery Manager RepositoryEtc/3par/solutions/Host1.ora.test 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/config 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 Removal Utility Etc/3par/solutions/primaryhost.ora.oraclesid/timestampVirtual Copy Repository Cloned Database Removal Utility Database Rollback from a Virtual Copy Virtual Copy PolicyDatabase Rollback Utility 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 # cd /mnt/cdrom0 Installing Recovery Manager on Linux SystemsStarting Installation # mount -t iso9660 -r /dev/cdrom /mnt/cdrom PM 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/cdrom0 Instdate Jan 19 2007 1521 Hotline Salesinfo@3pardata.com Completely installed166294 Blocks used approx # 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 rootuser Backuphost# rsh primaryhost lsBackuphost# rsh nbumaster ls 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 PermitRootLogin yes Etc/ssh/sshdconfig Generating an SSH Key Pair for the Backup HostGenerating an SSH Key Pair for the Primary Host 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 # 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 Backup Incremental options Configuring the NetBackup Policy for Database Backup Setting Up NetBackup Configuration Parameters Configuring the NetBackup Policy for Archive Log BackupClientname = virtualhostname Setting Up NetBackup Policies for Oracle Rman Backup Primaryhost.ora.oraclesid/vcdbanbudbbackup.sh Vcdbanbuarchbackup.sh Creating an Rman Recovery CatalogPrimaryhost.ora.oraclesid $ 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 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? n Enter 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 Oracle Rman channel type d=DISK,s=SBTTAPE,h,q? Enter NetBackup master server name h=help,q=quit?Enter number of channels to be allocated h=help,q=quit? Enter NetBackup policy name for archivelog backup h,q? Backup host# echo $DISPLAY Backup host# xhost +Backup 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/gui Etc/3par/solutions/primaryhost.ora.oraclesid/config Backuphost# /opt/3par/vcdbaora/bin/vcdbamain Enter Oraclehome of ASM instance on the backup host h,q? Enter Oraclehome on the backup host h=help,q=quit?Enter Oraclesid of the database instance 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/vcdbagui 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 Unmounting a Virtual Copy Mounting a Virtual CopyExporting a Virtual Copy Removing a Virtual Copy’s Repository Setting Virtual Copy Policy Backup Archive Log Destination Performing Immediate BackupsBacking Up Virtual Copies Backup Database Performing Automatic BackupsBackup Archive Logs Destination 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 Vcdbaconfig -s oraclesid -p primaryhost VcdbaconfigPrimaryhost.ora.oraclesid/config 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 Stopping the GUI Starting and Stopping the Recovery Manager GUIStarting the GUI Modifying Configuration Files Creating Configuration FilesRemoving 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 Starting Periodic Synchronization Removing the Recovery Manager Periodic Sync LockVerifying the Periodic Synchronization Process 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 Copies 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 C2t0d0s2 ErrorPilot# vxdisk list C0t0d0s2 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 Recovery Manager’s Remote Copy Requirements System ConfigurationEtc/3par/solutions/right.ora.ISS920/032103170642 System Configuration Cli% showport -rcip Verifying Remote Copy SettingsVerifying the Primary/Local Remote Copy Setting Primaryhost# ssh username@ssname Creatercopytarget Verifying the Secondary/Remote Copy SettingBackuphost# ssh username@ssname Cli% showrcopy targets targetname Cli% showrcopy groups groupname Startrcopygroup groupname Syncrcopy groupname command Eagle IPC transport error Eaprocessdown Using Remote CopyAvailable Or found Using Remote Copy Index IX.2 IX.3 IX.4 Revision History RH.2