Better Edge Backup v5.2
User Guide
Copyright © 2008, Better Edge Technology, Inc. All Rights Reserved.
Page 64 of 121 (September 16, 2008)
c. Select [Off-site Backup Server] to start ba cking up your files to an Offsite Backup Server.
Please follow the instructions below to restore your Oracle 8i/9i da tabases from an Offsite Backup Server.
i. Download the backup files from the Offsite Back up Server
Please refer to the [Quick Start - Backup F ile] section for information on how to download backup
files from Offsite Backup Server.
ii. Put all data files back to their original locations
iii. Control files, data files and archived logs are stored on Offsite Backup Server along with their full
path information. You just need to put all these files ba ck to their original locations when
performing a database restore.
iv. Put the PFILE back to its default location
Oracle 8i: $ORACLE_HOME/dbs/init<SID>.ora
Oracle 9i: $ORACLE_HOME/admin/<SID>/pfile/init.ora
v. Restore Database
(if Oracle 8i) Use Server Manager to restore you d atabase by doing the following:
a. Run Oracle Server Manager (svrmgrl)
b. Connect to the target database
c. Startup mount
d. Reapply all transactions from the archived log f iles
e. Open database
Oracle 8i Example:
$ svrmgrl
SVRMGRL> connect internal
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 95874 448 bytes
Fixed Size 64912 bytes
Variable Size 52744192 bytes
Database Buffers 40960000 bytes
Redo Buffers 2105344 bytes
Database mounted.
SVRMGRL> recover database using backup controlfile
ORA-00279: change 419671 generated at 06/14/03 02:51:49 needed for thread 1
ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000225.LOG
ORA-00280: change 419671 for thread 1 is in sequence #225
ORA-00278: log file '/data/ora815/vin/archive/ARCH0000000224.LOG' no longer needed for this
recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
Log applied.
. . . . . . . . . . .
ORA-00279: change 547222 generated at 06/18/03 19:58:26 needed for thread 1
ORA-00289: suggestion : /data/ora815/vin/archive/ARCH0000000384.LOG