Backing up an Oracle Data Guard environment

}
-input {
"run {"
"allocate channel 'dev_0' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DG1,OB2BARLIST=OraSTBY_DG1)';"
"allocate channel 'dev_1' type 'sbt_tape'"
" parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=DG1,OB2BARLIST=OraSTBY_DG1)';"
"backup incremental level <incr_level>"
" format 'OraSTBY_DG1<DG1_%s:%t:%p>.dbf'"
" database;"
"backup"
" format 'OraSTBY_DG1<DG1_%s:%t:%p>.dbf'"
" archivelog all;"
"backup"
" format 'OraSTBY_DG1<DG1_%s:%t:%p>.dbf'"
" current controlfile;"
"}"
}
-public
}
The manual backup specification creation is now complete and the Data Protector GUI can be used
for additional modification, like scheduling the backup specification or adjusting data and media
protection.
It is now also possible to start a Standby database backup using the normal Data Protector
possibilities like GUI, CLI (omnib) or to start the backup directly from RMAN. A session report can be
found in the Appendix A.
CAUTION
It is possible to execute sql commands within RMAN scripts. These commands will
fail for a Standby database backup if they require an open database (like “alter
system switch logfile”).
Therefore check the backup specification for such sql statements and remove them
if necessary.
Î What database components need to be backed up from the Primary and what from the physical
Standby database?
In Oracle 10g all database components can be backed up from the physical Standby database,
- Datafiles
- Archived Redo Log files
- Control File
and in case of a disaster they can be restored into the Primary database. The Standby database
Control File can not be restored into a Primary database, but in case of a disaster the Standby
database becomes the new Primary database (Failover) and the former Primary will become the
Standby database. So, from an Oracle perspective a restore of the Standby database is performed
and the Control File can be restored from the (former) Standby database backup. More information
about restore is described in the next main chapter “Restore”.
12