Riesgos asociados Proceso Control Disciplinario

Chapter 13: ca_recoverdb - Database

Recovery Command

Each time you run a backup job, CA ARCserve Backup records information in its databases about the machines, directories, and files that have been backed up, and the media that was used. This allows you to locate files whenever you need to restore them. The database recovery command (ca_recoverdb) is a

self-protection feature that allows you to recover a CA ARCserve Backup database if it is lost and was backed up by the CA ARCserve Backup domain that is using the database.

Note: The ca_recoverdb utility invokes the ca_restore commands to implement

the database recovery function. The ca_recoverdb utility will automatically determine if the CA ARCserve Backup database is a SQL Server database or SQL Server 2005 Express Edition instance and provide the appropriate parameters for the ca_restore command.

Note: When a CA ARCserve Backup server is configured as cluster-aware, all

critical ARCserve base-related services (not agent-related services) will be monitored by the applicable cluster service (MSCS or NEC CLUSTERPRO). If an ARCserve base-related service fails or needs to be shut down, the cluster service will automatically try to restart it or trigger a failover if the restart attempt fails. To run the this task, you must stop ARCserve services. However, in a

cluster-aware environment, you must first manually stop the cluster service from continuing to monitor the service and attempting an automatic restart or failover. For procedures to stop HA service monitoring by the Cluster Service, see the Administration Guide.

Note: The ca_recoverdb utility is only used to recover an ARCserve Database

(ASDB) on the same machine or ARCserve domain on which that ASDB backup was taken. If you want to backup an ASDB on one machine and then recover it on another machine (the two machines are not in the same ARCserve domain), this command can not be used. In this situation, you have two solutions:

Solution 1:

1. Take a DR backup from machine A and then recover it on machine B. This solution needs DR option installed.

188 Command Line Reference Guide

Solution 2:

1. Install CA ARCserve Backup on both machine A and machine B. 2. Perform an ASDB backup on machine A.

3. Move the tape to machine B, and submit a merge job to merge the information of the tape into the CA ARCserve Backup on machine B. 4. On machine B, open Restore Manager (Restore by Tree option) and

locate the "CA ARCserve Backup Database".

5. Right click the "CA ARCserve Backup Database" and on the popup menu, choose "Agent Options".

6. From the Agents Restore Options dialog, select the following options:

■ Force restore over existing files or database

■ Use current ARCserve Database as original location

■ Preserve current ARCserve Domain Memberships 7. Submit the restore job.

Syntax

The ca_recoverdb command line syntax is formatted as follows:

ca_recoverdb [ -cahost <hostname> ] [-i [n]]

-username <username> [-passw ord <passw ord>]

[-dbusername <database username> [-dbpassw ord <database passw ord> ] ] [-sessionpassw ord [session passw ord] -session passw ord [session passw ord]...]

Chapter 13: ca_recoverdb - Database Recovery Command 189

Options

The ca_recoverdb provides various options for recovering a lost CA ARCserve Backup database.

The ca_recoverdb command includes the following options:

cahost <hostname>

Redirects default host from the backup log to the host specified by cahost. For example:

HostA - The default host that existed in backup log, which will be used in ca_restore.

HostB - The host that you specify.

In these examples, if you do not specify the cahost switch, then the ca_restore command invoked by the ca_recoverdb utility will look as follows:

ca_restore -cahost HostA

If you do specify the cahost switch with the parameter HostB, then the ca_restore command invoked by the ca_recoverdb utility will look as follows:

ca_restore -cahost HostB

-i [n]

Specifies to use the interactive mode. If you include this switch, it allows you to specify a point in time from which to perform the CA ARCserve Backup database recovery by selecting which backup to use as a baseline. When the interactive mode is invoked, the ca_recoverdb displays the list of CA ARCserve Backup sequences for which it has log files. Each of the log files start with a Full database backup, and contains all of the other backups which are dependent on that Full backup to be restored (the Full backup is root of the “dependency chain” for those sessions).

The parameter n is used to specify the number of latest backup log sets (dependency chains) that you want to select from. The range of values for n

is 1 to 99, and the default value is 10.

When you select a Full backup sequence, you will then be prompted to select which session to use as the restore point. After you select a session, the ca_recoverdb utility will determine the dependency chain for that sequence, and use ca_restore to submit a restore job for each session.

If you do not include the -i switch, the ca_recoverdb utility automatically uses the most recent backup as the specified selection, and builds the dependency chain for that session. This is helpful if you just want to recover to the latest point in time backup. However, if the most recent backup is lost or damaged, you can use the interactive mode to restore from an older session, and then merge tapes to re-integrate the latest information.

190 Command Line Reference Guide

-username <username> [-password <password>]

Specifies the authenticating information for the database agent that will perform the actual recovery job. If you do not include the password option, it will default to no password required.

-dbusername <database username> [-dbpassword <database password>]

Specifies the authenticating information for the database. If you do not include the database username and corresponding database password, it will default to "dbusername" and "dbpassword" for authenticating purposes.

[-sessionpassword [session password] -sessionpassword [session password] ...]

Specifies the authenticating information for the sessions being set authenticating password.

[-waitForJobStatus <polling interval>]

Specifies the time interval (in seconds) that ca_recoverdb will wait until the job is completed and then exit with a return code that indicates the success or fail outcome of the job.

The <polling interval> value defines how often (in seconds) that the ca_recoverdb utility checks the job status with the Queue services. The default polling interval is 60 seconds.

Examples

The following are examples of syntax for the ca-recoverdb command:

■ Use the following syntax to recover an ASDB if the ASDB is hosted on a primary server:

ca_recoverdb.exe –username Administrator –password win_pwd

■ Use the following syntax to recover an ASDB if an ASDB session is encrypted or password protected:

ca_ recoverdb.exe –username Administrator –password win_pwd –sessionpassword ses_pwd

■ Use the following syntax to recover an ASDB if an external ASDB server and SQL Authentication is used:

ca_recoverydb.exe –cahost machinename –username Administrator –password win_pwd –dbusername db_username –dbpassword db_password