21
To perform the backup (online), we use the dd Operating System utility (ocopy for Windows):
oracle@ita018[RAC1]:/home/oracle$ dd if=/hpap/rdsk/hpap1 \
of=voting_backup.`date +%Y%m%d_%H:%M:%S` bs=4k
262144+0 records in
262144+0 records out
oracle@ita018[RAC1]:/home/oracle$ ll
-rw-r--r-- 1 oracle oinstall 1073741824 Sep 10 14:44 voting_backup.20070910_14:43:41
In our case, the LUN where the Voting Disk is located is 1GB in size. As the dd utility copies the
whole disk, remember to delete from the file system old backups of the Voting Disk.
Oracle SPFILE
When using Oracle Automatic Storage Management, the Oracle SPFILE is located on the shared
storage and it will be backed up through the RMAN online backup. However, we recommend
creating a text copy of it. It can be easily achieved with the following command:
SQL> create pfile=’$ORACLE_HOME/dbs/init$ORACLE_SID.ora.back’ from \
spfile=’+DG_DB/rac/spfileRAC.ora’
SQL> HOST mv $ORACLE_HOME/dbs/init$ORACLE_SID.ora.bak \
$ORACLE_HOME/dbs/init$ORACLE_SID.ora.`date +%Y%m%d_%H:%M:%S`
SQL> HOST ls –lrt $ORACLE_HOME/dbs/init$ORACLE_SID.ora*
-rw-r--r-- 1 oracle oinstall 2016 Sep 10 13:07 initRAC1.ora.20070910_13:07:32
The second command will add the date and time when the PFILE copy was generated.
ORACLE Directories
The following directories should also be included in the file system backup:
• ORACLE_BASE
• ORACLE_HOME
• ORA_CRS_HOME
• OraInventory
• /var/opt/oracle/*
File system Backup Recommendations
While the Oracle online integration takes care of the backup of datafiles, we have to care with a file
system backup of the Oracle Software and configuration files. These are key backups and needed in
case we experience a system disaster recovery or need to recover from any system changes /
updates.
• Perform a regular backup of the specified files, or at least, every time when files are modified.
To Next Page
Loading...
Need help?
General