![Cisco BTS 10200 Softswitch Troubleshooting Manual Download Page 762](http://html.mh-extra.com/html/cisco/bts-10200-softswitch/bts-10200-softswitch_troubleshooting-manual_67550762.webp)
16-14
Cisco BTS 10200 Softswitch Troubleshooting Guide, Release 5.0.x
OL-8723-19
Chapter 16 Disaster Recovery Procedures
Element Management System Database Recovery from Hot Backup
Step 7
Clean up old database data files by entering the following commands:
cd /data1/oradata/optical1
Note
If you are on the secondary EMS, cd to /data1/oradata/optical2.
rm data/* db1/* db2/* index/*
df –k /data1/oradata
Note
You must have a minimum of 3.6 GB free disk space on
/data1/oradata/optical1
to accommodate all
database data files from backup.
Step 8
Restore the backup binary control file to the database target directories:
Use the most current backup binary control file. In this case use the optical1_ctl_binary:200201101800
file from 18:00pm archivelog backup. If archivelog backup was not restored use the binary control file
from 2:00am backup. Copy the backup binary control file to both db1/control01.dbf and
db2/control02.dbf files.
cp /opt/oraback/optical1_ctl_binary:200201101800 db1/control01.ctl
cp /opt/oraback/optical1_ctl_binary:200201101800 db2/control02.ctl
Step 9
Recover the database using the
recover_db_until_time.ksh
script.
The
recover_db_until_time.ksh
script uses the restored binary control file to mount the database,
restores all data files from the restored database data-sets, applies all applicable archivelog files through
the restored archivelog file sets, then finally opens the database with the reset logs option and adds the
temp file backup to TEMP tablespace. When this script is completed successfully, database is recovered
to the point of time of the backups.
Before executing the recovery_db_until_time.ksh, shut down all Oracle instance processes.
cd /opt/oracle/admin/backup
./recover_db_until_time.ksh $ORACLE_SID
System response similar to the following is displayed:
*************************************************************************************
This process will perform database recovery using RMAN backup datasets.
Target: hostname=priems16 database=optical1
You must complete the following procedures before this process:
1. platform stop all
2. stop_cron.sh
3. restore all required backup datasets to /opt/oraback directory
4. copy optical1_ctl_binary file to /data1/../<db1 and db2>
*************************************************************************************