backup and restore

From: <marcus_chan_at_my-deja.com>
Date: Thu, 04 Nov 1999 07:19:50 GMT
Message-ID: <7vrc2l$7n9$1@nnrp1.deja.com>

Hello,

I come from DB2. I would like to know online hotbackup (archivelog mode).

In order for Oracle database to restore successfully, I need controlfile, datafiles, and also archived redologs. Am, i right?

I've backuped my database using NT backup manager (Oracle version 8.05 NT). I can only manage to backup tablespaces and controlfile. So, where or what should I do with the redolog files.

Below is the output of my backup

---

[000]

D:\ORANT\DATABASE\INDX1EBX1.ORA=c:\orantbck\database\tbls0005.000
[BACKUP]

000=TBLS-1999-11-4,14:41:30
NEXT=6

001=TBLS-1999-11-4,14:41:48
002=TBLS-1999-11-4,14:43:35
003=TBLS-1999-11-4,14:44:2
004=TBLS-1999-11-4,14:44:40
005=CNTL-1999-11-4,14:45:7

[001]

D:\ORANT\DATABASE\RBS1EBX1.ORA=c:\orantbck\database\tbls0002.001
[002]

D:\ORANT\DATABASE\SYS1EBX1.ORA=c:\orantbck\database\tbls0001.002
[003]

D:\ORANT\DATABASE\TMP1EBX1.ORA=c:\orantbck\database\tbls0004.003
[004]

D:\ORANT\DATABASE\USR1EBX1.ORA=c:\orantbck\database\tbls0003.004
[005]

D:\orant\database\ctl1ebx1.ora=c:\orantbck\database\cntl0001.005

What should I do, to restore my database (until point-in-time) if disaster occurs. I've read a few books on backup/recovery strategy but I'm still confuse over this.

Can anyone give me a clear explaination.

your help is much appreciated

marcus

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 01:19:50 CST