
Security and Administration 87
Copyright © 2003, Nortel Networks MCP Database Module Basics
Nortel Networks Confidential
2 To perform the recovery procedure listed in column 1, execute
the commands in column 2.
Note: db_type can be PRIMARY or SECONDARY and
media_type can be DISK or TAPE.
If Do
Restore control files from a
backup copy
cd /IMS/imssipdb/data/db_schema/util
stop_imsdb abort
cp /var/opt/oracle/imsdb1/control03.ctl
/IMS/oradata/imsdb1/control01.ctl
cp /var/opt/oracle/imsdb1/control03.ctl
/opt/app/oracle/oradata/imsdb1/control02.ctl
cd db_schema/util
start_imsdb
Restore control files from
disk or tape backups
restore_control_files.sh <db_type> <media_type>
/IMS/oradata/imsdb1/control01.ctl
Restore the system
datafile to another
directory partition
restore_sys_undo_datafile.sh <db_type>
<media_type> /IMS/oradata/imsdb1/system01.dbf
/IMS/oradata/imsdb1/system02.dbf
Restore the undo
tablespace data file to the
current directory
restore_sys_undo_datafile.sh <db_type>
<media_type>
/IMS/oradata/imsdb1/undotbs01.dbf
Restore the undo
tablespace data file to a
different directory
restore_sys_undo_datafile.sh <db_type>
<media_type>
/IMS/oradata/imsdb1/undotbs01.dbf
/IMS/oradata/imsdb1/undotbs02.dbf
Restore the IMS_DATA
tablespace datafile to the
same directory
restore_datafile.sh <db_type> <media_type>
/IMS/oradata/imsdb1/ims_data.dbf
Restore the IMS_DATA
tablespace datafile to a
different directory partition
restore_datafile.sh <db_type> <media_type>
/IMS/oradata/imsdb1/ims_data.dbf
/IMS/oradata/imsdb1/ims_data1.dbf
Restore data files and
temp tablespace
restore_temp_datafile.sh <db_type>
Restore an entire database
from backup
restore_database.sh <db_type> <media_type>
restore_temp_datafile.sh <db_type>
Commenti su questo manuale