Does Not Apply: RMAN_UTIL does not apply to IntelliSnap
You perform a selective online full backup when the database is online. A selective copy subclient includes the data, logs and control file. The advantage of a selective online full backup is that the data and logs use the same storage policy, which means that they reside on the same media and are self-contained for long-term archiving. You can use this in a disaster recovery, because you do not need to locate different media from multiple jobs to recover the database.
For more information on selective online full backups, see Selective Online Full Backups.
You must set the SelectiveOnlineFull parameter in the SAP for Oracle Util file in order to use this feature.
If the datatype is online, when you run a brbackup job and another brarchive job for the log backup runs without issues, the data job type is marked as 'Online Full' and the job is eligible for selective copy.
If the datatype is offline, when you run a brbackup job for the data backup and the job completes without any issues, the data job type is marked as 'OfflineFull' and the job is eligible for selective copy.
Before You Begin
Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.
Procedure
Notes
-
If you use SAP Secure Store, replace the slash ("/") with a double slash ("//") in all examples.
-
RMAN_UTIL does not apply to IntelliSnap
UTIL_FILE
-
Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.utl file and set the parameter value to 1.
For information on this parameter, see Supported SAP for Oracle Util File Parameters
Example
numstreams $[1] SelectiveOnlineFull $[1]
If the datatype is online:
-
On the command line, type the following command to run the data backup if the data type is online.
brbackup -t $[online] -d $[util_file] -m $[all] -c $[force] -u $[/] -
On the command line, type the following command to run the log backup.
brarchive –d $[util_file] –s –c $[force] -u $[/] -
On the command line, type the following command to run the data backup if the data type is online_cons.
brbackup -t $[online_cons] -d $[util_file] -m $[all] -c force -u $[/] -
On the command line, type the following command to run the log backup.
brarchive -d $[util_file] -s -c $[force]If the brbackup job followed by a brarchive job complete without any issues, the data job type is marked as 'Online Full" and the job is eligible for selective copy.
If the datatype is offline:
-
On the command line, type the following command to run the backup:
brbackup -t $[offline] -d $[util_file] -m $[all] -c $[force] -u $[/]If the job completes without any issues, the data job type is marked as 'Offline Full" and the job is eligible for selective copy.
RMAN_UTIL
-
Include the SelectiveOnlineFull parameter in the $ORACLE_HOME/dbs/init<SID>.sap file and set the parameter value to 1.
Example
RMAN_PARMS="SBT_LIBRARY= $[/Base/libobk.so],BLKSIZE=$[1048576],ENV=(CvClientName= $[client_name],CvInstanceName= $[instance_name],SelectiveOnlineFull=$[1])
If the datatype is online:
-
On the command line, type the following command to run the data backup if the data type is online.
brbackup -t $[online] -d $[rman_util] -m $[full] -c $[force] -u $[/] -
On the command line, type the following command to run the log backup.
brarchive -d $[rman_util] -s -c $[force] -
On the command line, type the following command to run the data backup if the data type is online_cons.
brbackup -t $[online_cons] -d $[rman_util] -m $[full] -c $[force] -u $[/] -
On the command line, type the following command to run the log backup.
brarchive -d $[rman_util] -s -c $[force]If the brbackup job followed by a brarchive job complete without any issues, the data job type is marked as 'Online Full" and the job is eligible for selective copy.
If the datatype is offline:
-
On the command line, type the following command to run the backup:
brbackup -t $[offline] -d $[rman_util] -m $[all] -c $[force] -u $[/]If the job completes without any issues, the data job type is marked as 'Offline Full" and the job is eligible for selective copy.