The sample shell scripts provided are summarized below. These scripts are stored in the /etc/opt/FJSVswsts/samp directory.
No. | Type | Script name | Associated transaction | Associated resource type |
|---|---|---|---|---|
1 | Collection of DB information | swst_or_iv | Oracle transaction | - |
2 | Backup | swst_or_fs_bk | Oracle transaction, general file transaction | File system |
3 | Backup | swst_or_rd_bk | Oracle transaction | Raw device |
swst_or_iv outputs information about an Oracle database. The output file names and their contents are:
spdata.lst : List of table space names and storage destinations
spdata.bgn : Command in the following format:
Alter tablespace Table-space-name begin backup; |
spdata.end : Command in the following format:
Alter tablespace Table-space-name end backup; |
spcont.lst : Oracle database control file information
splog.lst : Oracle database log file information
spredolog.lst : REDO Log file information of an Oracle database
Use the database information above as a reference for creating shell scripts for backup processing.
swst_or_iv |
# swst_or_iv swst_or_iv completed. |
spdata.lst
TABLESPACE-NAME DEVICE-NAME
-------------------- ----------------------------------------------------------------------
ACMTS1 /dev/vg170/rlvol170
SYSAUX /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/sysaux01.dbf
SYSTEM /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/system01.dbf
UNDOTBS1 /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/undotbs01.dbf
USERS /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/users01.dbf
spdata.bgn
alter tablespace ACMTS1 begin backup;
alter tablespace SYSAUX begin backup;
alter tablespace SYSTEM begin backup;
alter tablespace UNDOTBS1 begin backup;
alter tablespace USERS begin backup;
spdata.end
alter tablespace ACMTS1 end backup;
alter tablespace SYSAUX end backup;
alter tablespace SYSTEM end backup;
alter tablespace UNDOTBS1 end backup;
alter tablespace USERS end backup;
spcont.lst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /var/adm/crash/u01/app/oracle/
OraHome_1/oradata/acmtest1/con
trol01.ctl, /var/adm/crash/u01
/app/oracle/OraHome_1/oradata/
acmtest1/control02.ctl, /var/a
dm/crash/u01/app/oracle/OraHom
e_1/oradata/acmtest1/control03
.ctl
splog.lst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /var/adm/crash/u01/app/oracle/
OraHome_1/flash_recovery_area
db_recovery_file_dest_size big integer 2G
spredolog.lst
GROUP# MEMBER
---------- ------------------------------------------------------------------------------
3 /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/redo03.log
2 /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/redo02.log
1 /var/adm/crash/u01/app/oracle/OraHome_1/oradata/acmtest1/redo01.log |
#!/bin/sh
reterr() --- An error message is output before an error is returned.
sqldata()
{
sqlplus /nolog <<!
connect / as sysdba
SELECT --- Acquire Oracle table space information.
}
sqllog()
{
sqlplus /nolog <<!
connect / as sysdba
show --- Acquire Oracle log information.
}
sqlcont()
{
sqlplus /nolog <<!
connect / as sysdba
show --- Acquire Oracle control information.
}
sqlredolog()
{
sqlplus /nolog <<!
connect / as sysdba
show --- Acquire Oracle REDO log information.
}
# main()
# 0) Environmental variable setting
PATH=$PATH:/usr/bin:/usr/sbin:/opt/FJSVswsts/bin
# 1) Acquisition of Oracle table space information
sqldata() invocation --- Acquire Oracle table space information
# 2) Acquisition of Oracle log information
sqllog() invocation --- Acquire Oracle log information
# 3) Acquisition of Oracle control information
sqlcont() invocation --- Acquire Oracle control information
# 4) Acquisition of Oracle REDO log information
sqlredolog() invocation --- Acquire Oracle REDO log information
exit 0 |
swst_or_fs_bk, run using AdvancedCopy Manager, backs up processing data stored in an Oracle database on a file system.
Processing data is copied to the backup volumes of AdvancedCopy Manager. These scripts correspond to steps 2 to 5 in "B.3.2.1 DB information collection".
swst_or_fs_bk {-a | -i} <mount-point-name> |
Specify when an Oracle database is online. The start of backup processing is declared to the Oracle server.
Specify when an Oracle database is stopped or the file is a general file. The start of backup processing is not declared to the Oracle server.
Specify the name of the mount point targeted for backup.
While processing is active, back up /gyoumu_db in which an Oracle database is located.
# swst_or_fs_bk -a /gyoumu_db swst_or_fs_bk completed. ( /gyoumu_db -> /dev/vg170 at 23:00 on 2005.10.01 ) |
#!/bin/sh
usage() --- Command syntax is output before an error is returned.
reterr() --- An error message is output before an error is returned.
chkmp() --- Check for a mount point
get_mp_blk() --- Conversion from a mount point to a device
getfs() --- Conversion from a mount point to a file system type
sqlbegin()
{
sqlplus /nolog <<!
connect / as sysdba
alter system switch logfile;
alter system flush shared_pool;
alter tablespace CCC begin backup; --- Notify Oracle of the start of backup.
}
sqlend()
{
sqlplus /nolog <<!
connect / as sysdba
alter tablespace CCC end backup; --- Notify Oracle of the stopping of backup.
}
getbd() --- Fetch the name of the backup (copy) destination device of AdvancedCopy Manager.
getdate() --- Fetch the backup (copy) date of AdvancedCopy Manager.
gettime() --- Fetch the backup (copy) time of AdvancedCopy Manager.
# main()
Parameter analysis and mount point check
# 0) Environmental variable setting
PATH=$PATH:/usr/bin:/usr/sbin:/opt/FJSVswsts/bin
# 1) Notification issued to Oracle of the start of backup
if [ "-a" operand specification ]
then
sqlbegin() invocation --- Notify Oracle of the start of backup.
Error handling
fi
# 2) Disk backup (copy) by AdvancedCopy Manager command
swstbackup $VG --- Copy the disk.
Error handling
# 3) Notification issued to Oracle of the stopping of backup
if [ "-a" operand specification ]
then
sqlend() invocation --- Notify Oracle of the stopping of backup.
Error handling
fi
# 4) Acquisition of the backup (copy) destination of AdvancedCopy Manager
BDBLK="`getbd $VG`" --- Fetch a backup volume as a character device.
BDDATE="`getdate $VG`"--- Fetch the backup date.
BDTIME="`gettime $VG`"--- Fetch the backup time.
exit 0 |
swst_or_rd_bk is run using AdvancedCopy Manager to back up live data using an Oracle database on a raw device.
Live data is copied to work disks prepared by users.
These scripts apply to steps 2 to 5 in "B.3.2.1 DB information collection".
swst_or_rd_bk {-a | -i} <device name> |
Specify when an Oracle database is online. The start of backup processing is declared to the Oracle server.
Specify when an Oracle database is stopped or the file is a general file. The start of backup processing is not declared to the Oracle server.
Specify the name of the raw device targeted for backup.
While the database is online, back up /dev/vg170 in which an Oracle database is located.
# swst_or_rd_bk -a /dev/vg170 swst_or_rd_bk completed. (/dev/vg170 -> /dev/vg171 at 23:01 on 2005.10.01 ) |
#!/bin/sh
usage() --- Command syntax is output before an error is returned.
reterr() --- An error message is output before an error is returned.
get_chr_blk() --- Conversion from a character device to a block device
get_blk_chr() --- Conversion from a block device to a character device
sqlbegin()
{
sqlplus /nolog <<!
connect / as sysdba
alter system switch logfile;
alter system flush shared_pool;
alter tablespace CCC begin backup; --- Notify Oracle of the start of backup.
}
sqlend()
{
sqlplus /nolog <<!
connect / as sysdba
alter tablespace CCC end backup; --- Notify Oracle of the stopping of backup.
}
getbd() --- Fetch the name of the backup (copy) destination device of AdvancedCopy Manager.
getdate() --- Fetch the backup (copy) date of AdvancedCopy Manager.
gettime() --- Fetch the backup (copy) time of AdvancedCopy Manager.
# main()
Parameter analysis and raw device check
# 0) Environmental variable setting
PATH=$PATH:/usr/bin:/usr/sbin:/opt/FJSVswsts/bin
# 1) Notification issued to Oracle of the start of backup
if [ "-a" operand specification ]
then
sqlbegin() invocation --- Notify Oracle of the start of backup.
Error handling
fi
# 2) Disk backup (copy) by AdvancedCopy Manager command
swstbackup $SRC --- Copy the disk.
Error handling
# 3) Notification issued to Oracle of the stopping of backup
if [ "-a" operand specification ]
then
sqlend() invocation --- Notify Oracle of the stopping of backup.
Error handling
fi
# 4) Acquisition of the backup (copy) destination of AdvancedCopy Manager
DSTBLK="`getbd $SRC`" --- Fetch a backup volume.
DST="`get_blk_chr $DSTBLK`"
BKDATE="`getdate $SRC`"
BKTIME="`gettime $SRC`"
exit 0 |
