Deonet-backup-solutions 5.2.7.0 Manual de usuario descargar pdf (Pagina 64)

Better Edge Backup v5.2

User Guide

Page 64 of 121 (September 16, 2008)

c. Select [Off-site Backup Server] to start backing up your files to an Offsite Backup Server.

9.4 How to restore an Oracle Database

Please follow the instructions below to restore your Oracle 8i/9i databases from an Offsite Backup Server.

i. Download the backup files from the Offsite Backup Server

Please refer to the [Quick Start - Backup File] 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 back 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 database 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 files

e. Open database

Oracle 8i Example:

$ svrmgrl

SVRMGRL> connect internal

SVRMGR> startup mount;

ORACLE instance started.

Total System Global Area 95874448 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

1 2 ... 59 60 61 62 63 64 65 66 67 68 69 ... 120 121

Comentarios a estos manuales

Sin comentarios

Deonet-backup-solutions 5.2.7.0 Manual de usuario Pagina 64

Comentarios a estos manuales