In order to protect Oracle data on a local/non-global zone, you need to install
the Oracle iDataAgent on the non-global
zone.
Can we Protect Data on Non-Global Zones if the File System
iDataAgent is Installed only on the Global
Zone?
Yes. We can protect file system data on non-global zones if the File System
iDataAgent is installed only on the global
zone. However, in order to enable consistent backups of application specific data
on the non-global zones, you will need to install the corresponding application
specific iDataAgent on the non-global
zone.
Can we Perform Command Line Backups of Oracle RAC Instances with different Oracle
SID and Database Names?
Yes. Different SID and database names for Oracle RAC instances are supported
for Oracle command line backups.
Can we Perform Command Line Backups if Oracle RAC Database Name and Instance
Name (as defined in the ComCell Console) are Different?
No. Whenever you run backups from the RMAN command line, ensure that the
Oracle database name and the Instance Name as defined in the CommCell Console
are the same, otherwise you will need to pass the name of the instance in the
RMAN script as follows:
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=<software_install_path>/Base/libobk.so,ENV=(CvClientName=<rac_client_name>,CVOraRacDBName=<rac_database_name>,CvInstanceName=<instance_name>)"
where <rac_client_name> and
<instance_name> are the names of the RAC
Client and Instance (e.g., Instance001) on which the
iDataAgent is installed.
On Windows Clients for RAC, can we run Multiple RMAN Jobs Simultaneously for
the Same Instance from the CommCell Console?
No. You should always limit the RMAN jobs for the same instance to run one at
a time in the CommCell Console and Scheduler.
Can we run Third-Party Command Line Backup Operations when a Selective Online
Backup Job is Running?
No. Third-party command line backup operations cannot be run when a selective
online full backup job is running.
When does a Non-Full Backup Automatically get converted to a Full Backup?
When you select backup type as Full in CommCell Console and enter the backup
type as Incremental on customize script, the job will run as Full.
When you select backup type as Incremental in CommCell Console and enter
the backup type as Full on customize script, the job will run as Full. However,
the Job Manager will treat this job as Incremental (on job controller and job
history and job report). This job will be pruned as it reaches the data retention
date.
When a storage policy is changed and if backup type is switched to full
from job manager, the increment level will be changed to 0.
If you do not enter the backup type on customize script, then the system
picks up the backup type selected in CommCell Console.
When does Incorrect Data Transfer Count Displayed in Job Details?
When you resume a backup job, if the subclient content includes the SP file,
the backup job gets restarted from the beginning and all the data that was
backed up previously gets backed up again. This causes an incorrect display of
data transferred count in job details.
How is the Data Retrieved during Browse and Restore Operations?
When you browse or restore data, the browse function by default returns the requested
data based on the latest backups available. This is usually the information that
users are interested in. The browse function does this by using the current date
and time as the effective date.
What are the Tables that can be Restored in Oracle 11g2?
You can restore tables under non-system tablespaces in Oracle 11g2.
How are Table Indexes handled during Restore?
When you include the indexes during a table restore, note that only the index
definition is restored and not the indexed data.
Can we Manually Import Tables from the Auxiliary Instance?
Once the tables are restored to the auxiliary instance, you can either use the
CommCell Console to export the data from the auxiliary instance and import it to
a destination that you choose, or you can leave the data in the staging path and
import the data manually by using Oracle import utilities.
How are Stored Procedures Restored?
Stored procedures are restored from the Schema level. Schema is the collection
of data objects created by the user to contain or reference their data. Hence, if
one of the table within the schema is selected for restore, all the stored procedures
for that schema will also get restored.
Can we restore Tables when there is a Schema Change in the Database?
No. Table restores are not supported when there are schema changes in the database.
What happens if one of the Streams Fail when running Third-Party Command Line
Operations with Multiple Streams?
Oracle third-party command line operations running on multiple streams will share
the same Job ID in the Job Manager. If all the streams return failure, then the
job is marked as failed. However, if one of the streams fail, it is submitted to
the other stream for completion.
How are Third Party Command Line jobs handled when Oracle Services use a different
Service Account instead of Local System?
When Oracle Services use a different service account other than Local System,
third party command line jobs are run with multiple job IDs. In such cases, use
the following steps to enable third party command line jobs to run with a single
job ID:
From the Start menu, point to AdministrativeTools,
and then click Local Security Policy.
Double-click Local Policies, and then double-click User Rights
Assignment.
In the details pane, double-click Adjust memory quotas for a process.
Click Add User or Group.
In the Enter the object names to select box, type the user or group
name to which you want to assign the user right, and then click OK.
In the details pane, double-click Replace a process level token.
Click Add User or Group.
In the Enter the object names to select box, type the user or group
name to which you want to assign the user right, and then click OK.
How do we Delete Archive Logs from a Flash Recovery Area that is Protected?
When the Oracle database is configured to save archive logs in the Flash recovery
area, backup jobs will fail if the Oracle RAC subclients have both the Protect backup
recovery area and the Archive Delete options enabled at the same time.
To avoid such backup failures you need to configure two different subclients,
one for Protect backup recovery area and the other for enabling Archive Deletion
option for deleting Archive logs.
How do we configure backups on Oracle Exadata Database Machines?
In order to backup Oracle Exadata Database Machines, do the following:
Install the Oracle iDataAgent
on all the Exadata nodes.
Create a RAC pseudo client that includes all the Exadata nodes.
Add the MediaAgent to the Infiniband network.
If using tapes
for backup, make sure to include an optimal tape block size (eg.,2048K
for Linux clients) in the storage policy copy. See
Set the Chunk Size and Block Size for a Data Path for
information on setting the block size value.
Add Data Interface Pair (DIPs) for Infiniband IP address between
the Exadata nodes and the MediaAgent.
Yes. You can restore from a RAC One Node in a multiple node configuration.
However, consider the following while restoring from a RAC One Node:
In the case of emergency failover, the instance (same ORACLE_SID) will
be relocated to another physical node. The emergency failover is supported
during backup. Make sure that the active ORACLE instance and client
combination should be the same as configured in CommCell console during
controlfile/spfile restore.
For RAC One node configuration, it is suggested not to use SwitchDBMode
during restores. It is required to keep the database in correct mode (for
e.g. NOMOUNT mode for Control file restore and MOUNT mode for database
restore) manually before submitting the restore.
Select streams only for the active node where instance is running.