Agents - Oracle - How To
Topics | How To | Related Topics
Create an Instance
Convert to Full Backup on Indexing Failures
Browse the Latest Data
View Job History Details
Create a New Index on a Full Backup
Change Account for Accessing
Databases/Applications
Change Account for Executing Pre/Post Commands (Data Recovery)
Deconfigure a Client, MediaAgent, Agent, or Enabler
Delete the Agent
View the Software Version
Before You Begin
-
For the Oracle, Oracle RAC or SAP for Oracle iDataAgent,
if you have custom SQL settings, you must turn off these settings to
ensure that the instance browse works correctly and that the instance status is
correctly fetched. To do this, create and edit the
cvlogin.sql file with the appropriate contents at
ORACLE_HOME/sqlplus/admin. For example, run the
following command:
edit file $ORACLE_HOME/sqlplus/admin/cvlogin.sql
Then include the following contents in the
cvlogin.sql file:
set heading on;
set pause off;
Required Capability: See
Capabilities and Required Actions
To create/modify an Instance
- To create an instance, from the CommCell Browser, locate the correct client computer node, and right-click the agent node for which you want
the new instance created, click All Tasks, and then click New Instance from the
shortcut menu.
To modify an existing instance, from the CommCell Browser, right-click the instance you want to modify, and then click
Properties from the shortcut menu.
- From the General
tab, enter the name (up to 32
characters) for the instance. In addition, provide the required access information for
this instance.
For various iDataAgents,
you can add/modify an application/database user account. See the appropriate section as follows in
User Accounts and Passwords for more information:
- If your agent uses the Details
tab,
enter the required database connect string and other optional parameters.
- For the Oracle, Oracle RAC and SAP for Oracle iDataAgents, see
the
Oracle iDataAgents section in
User Accounts and Passwords for more information.
- From the
Storage Device
tab, select storage policy copies to be used for, as applicable, data
backups, command line data backups and log backups. Within these tabs
you can click Data
Paths to display the details of the data paths associated with the
primary storage policy copy of the selected storage policy.
- If your agent uses the
Software
Compression tab, and you want to enable software compression for the
selected
backups, click the tab and select the option appropriate to your environment.
- If you want to enable data encryption, from the
Encryption
tab
select encryption settings for third-party or RMAN command line backups.
- Click OK to save the instance.
- A message advises you to schedule backups for your new instance. It is
recommended you elect to set a schedule now. You can also associate this
instance with an All Agent Types schedule policy (which is automatically
created by the system, or can be a user defined Data Protection schedule
policy). If you have already associated a schedule policy at a previous
level (Agent, Client, or Client Computer Group) the schedules defined in the
Schedule Policy will be automatically applied to the new instance. See
Schedule Policy for
more information.
- For agents that offer an OK
option, click OK to acknowledge the message. This procedure is now
complete.
- For agents that offer Yes and No options to this
message, click No if you don't want to create a backup schedule at
this time, and this procedure is complete. If you click Yes, a dialog box
prompts you to back up
all subclients of this instance.
- Click Yes.
The Backup Options dialog box appears, which allows you to create the
necessary schedules.
- From the Backup Options
dialog box, select the type of backup that you want to schedule.
- If you want to access Advanced Backup Options,
click Advanced.
- After selecting the backup type and any advanced options, click OK.
The Schedule Details dialog box appears.
- From the Schedule
Details tab of the Schedule Details dialog box, select the scheduling options
that you want to apply, then click OK.
NOTES
- A default subclient is created for the Oracle instance, which includes all the objects in the instance.
When you are done with this procedure, open the Subclient
Properties dialog box for the default subclient and verify that
the Resync Catalog option available in the
Backup Arguments tab is selected. This
would help you to successfully perform a full system restore in the
event of destroyed or damaged client.
- After creating the instance for DB2, you can now create one or more
Backup Sets for this
instance.
Required Capability: See
Capabilities and Permitted Actions
To convert a non-full backup
to a full backup on indexing failures:
- From the CommCell Browser, right-click the agent icon of the
client computer whose agent configuration you want to change, and then click
Properties.
- From the Index tab
of the agent Properties dialog box, select Convert to full backup on
indexing failures.
- Click OK.
The following procedure can be used to browse data from the client, agent, instance, or backup set level,
replication set level, depending on the functionality
of a given agent.
Required Capability: See
Capabilities and Permitted Actions
To browse the
latest data:
- From the CommCell Browser, right-click the level whose data you want to
browse, click All Tasks, and then click the Browse/Browse Backup
Data option from that level.
- From the Browse Options
dialog box,
click OK to execute the browse using the Browse the Latest Data option.
Required Capability: See
Capabilities and Permitted Actions
To
view the details of a job history:
- From the CommCell Browser, right-click the entity (e.g., subclient, client
computer, etc.) whose job history you want to view,
click View, and then
click job history.
- From the Job
History Filter dialog box, select the filter options that you want to apply and click OK.
- From the
Data Management Job
History window, right-click the job whose job details you want to view, and then click View
Job Details.
- The Job Details dialog box appears, displaying detailed job history in
General,
Details,
Phase
Details and
Attempts
tabs for the selected job.
- Click OK.
|
If viewing the details of a job with a pending or failed status, the
Reason for Job Delay field will contain an Error Code, which, if clicked,
will launch the customer support website displaying troubleshooting article(s)
related to the specific issue. |
This procedure sets the default behavior. Note
that whatever option is selected in the Advanced Backup Options
dialog box will be used.
Required Capability: See
Capabilities and Permitted Actions
To create a new index on a
full backup:
- From the CommCell Browser, right-click the agent icon of the
client computer whose agent configuration you want to change, and then click
Properties.
- From the Index tab
of the agent Properties dialog box, select Create new index on full backup.
- Click OK.
Required Capability: See
Capabilities
and Permitted Actions
To change
a user account for accessing DB2 databases:
- From the CommCell Browser, expand the tree if necessary to view the desired
level icon.
- From the agent level, right-click the agent icon, click All Tasks
from the short-cut menu, click New Instance, and go to the next step.
- From the instance level, right-click the instance icon, click Properties
from the short-cut menu, and go to Step 3.
- From the backup set level, right-click the backup set icon, click
Properties from the short-cut menu, and go to Step 4.
- Use the Creating New Instance dialog box to create and configure
the instance. Thereafter, from the General tab, click the Change
button associated with the User Account information. Then go to Step 5.
- From the General tab of the Instance Properties dialog box,
click the Change button associated with the User Account information.
Then go to Step 5.
- From the General tab of the Backup Set Properties dialog box,
ensure that the Connect as a Different User option is selected. Then
click the Change button associated with the User Account information.
- Enter the required information in the
Set DB2
User Account dialog box.
- Click OK to save the settings.
To change
a user account for accessing Oracle or SAP for Oracle applications on Windows not associated with QR Agent:
- From the CommCell Browser, expand the tree if necessary to view the desired
level icon.
- From the agent level, right-click the agent icon, click All Tasks
from the short-cut menu, and click New Instance (Oracle SID).
- From the instance level, right-click the instance icon and click
Properties from the short-cut menu.
- From the General tab, click the Change button associated with the
User Account information.
- Enter the required information in the
Impersonate
NT User dialog box.
- Click OK to save the settings.
To change
a user account for accessing Oracle applications for QR Agent:
- From the CommCell Browser, expand the tree if necessary to view the QR agent
icon. Then right-click the icon and click Properties.
- From the Authentication
tab, click the Oracle sub-tab.
- From the Oracle sub-tab, either click Add Instance or select an Oracle
instance to edit and then click Edit Instance.
- From the Add Oracle Instance to QR Agent dialog box, click Change.
- Enter the required information in the
Impersonate
NT User dialog box.
- Click OK to save the settings.
To change
a user account for accessing Informix, Oracle, or SAP for Oracle applications on
Unix:
- From the CommCell Browser, expand the tree if necessary to view the
desired level icon. From the agent level, right-click the agent icon, click
All Tasks from the short-cut menu, click New Instance, and go
to the next step. From the instance level, right-click the instance icon,
click Properties from the short-cut menu, and go to Step 3.
- Use the New
Instance dialog box to create and configure the instance.
- From the General
tab of the Instance Properties dialog box, do one of the following, as
appropriate.
- For Informix, type the name of the user account in the INFORMIX USER
field.
- For Oracle or SAP for Oracle, type the name of the user account in
the ORACLE USER field.
- Click OK to save the settings.
Required Capability: See
Capabilities
and Permitted Actions
To change
a user account for executing pre/post commands for Data Recovery jobs:
- From the CommCell Browser, expand the tree to view the appropriate level
icon for the affected agent. Then right-click the icon and click All
Tasks from the short-cut menu.
- Click the appropriate Browse or Restore option. Then populate,
select, and click as appropriate to access the Restore Options dialog box.
- From the Restore Options dialog box,
click Advanced.
- From the Advanced Restore Options, click the
Pre/Post tab.
- From the Pre/Post
tab, select one of the account options in the
Pre/Post Impersonation area. If you select Impersonate User, type
the appropriate user name and password.
- Click OK to save the settings.
Required Capabilities:
Capabilities and Permitted Actions
|
Administrative Management capability cannot be used to perform the deconfigure operation from the MediaAgent level.
|
Before you Begin:
-
For MediaAgent Deconfiguration, ensure that all the storage policies or copies
associated with the configured libraries (or drive pools) in the MediaAgent are
deleted or re-associated to another MediaAgent.
To deconfigure a
client, MediaAgent, agent, or enabler:
- In the CommCell Browser, right-click the name of the client, MediaAgent,
agent, or enabler you want to deconfigure, click All Tasks (if
displayed), and select Deconfigure.
- A popup warning message appears.
Click OK to continue.
- Another popup message then appears.
Click Yes to continue with the deconfiguration or No to abort.
- If the deconfigure is unsuccessful, a number of popup messages
appears. In some cases, the message requests that you take some
corrective action. For example, the message might advise you to ensure that there are no jobs running on the
agent. In such a case, click OK and take the appropriate action.
Then repeat the deconfigure process.
If the deconfigure is successful, the tree element is dimmed and available for deletion.
Before You Begin
You can perform agent operations as long as the agent is installed and
appears enabled in the CommCell Browser. However, if you have no need to
run jobs on the agent data of a client computer, you may want
to delete the agent that resides on that computer. Once you have uninstalled or DeConfigured
the agent, the corresponding icon in the CommCell Browser is grayed out. While
this icon exists, you can recover data from the agent to another client. If you
delete this icon, all of the agent's data is irretrievably lost.
NOTES
Deleting the agent is a two-phase process.
- You need to uninstall or DeConfigure the agent software
from the client computer. Doing so frees an agent license, thereby allowing
you to install it on some other computer whose data you do want to secure.
- After you delete the client software, you can either leave the corresponding
data
intact for appropriate action, or you can remove the data immediately. If you choose
to remove the data immediately, you must delete the agent from the CommCell
Browser.
Required Capability: See
Capabilities and Permitted Actions
To delete
an agent:
- From the CommCell Browser, right-click the icon of the agent that you want to delete, and then click Delete.
(The agent software must first have been uninstalled/DeConfigured or the delete option on the shortcut menu
will not appear.)
- A warning message prompts you with the following:
This operation will permanently delete the data backed up from this level
and it cannot be restored. Click Ok to continue with the
deletion operation. (Clicking No will abort the operation.)
- From the Confirmation Text dialog box, enter the confirmation
text string, erase and reuse media. Click
Ok. The agent icon and the data that corresponds to the selected agent
will be deleted. Consequently, you will not be able to browse or recover
this data.
To
view the Software Version:
- From the CommCell Browser, click the CommServe, Client,
Agent, MediaAgent, or Enabler for which you wish to view the version, and then click
Properties.
- Click the Version tab.
The component version and post release service pack, additional updates
and missing updates are displayed.