Dear Member

I am exploring some backup methods. One of them is backup and restore using Oracle 8.1
Does anyone have experience on it?

FYI, we did backup by running session ttaad4226m000 (Create sequential dump of table).

Thanks and regards,
Zainuddin

For (Oracle) data you can go for online (with or without RMAN) or offline backups. You can also do (or use as complement) Oracle exports. Any of these are faster than Baan exports.
Search google or oracle websites with those topics for more information.

For baan stuff, you take normal backup of $BSE filesystems. If you have customizations/development, you should also plan component exports.

Search the threads for those topics for more information, backups have been discussed a lot.

Here is a script that you may find useful:

REM ################################################################
REM Created 10/7/2005: Tuple9i
REM Redesigned Hot Backup to handle Tablespaces individually
REM ################################################################

set bj=c:\schedJobs\
set tmp=c:\schedJobs\Logs\HotBkup_BaaN.txt
set tmp1=c:\schedJobs\Logs\HotBackup_BaaN_PRD.rpt

REM -------------------- declaring variables ----------------------

set mail1={email address #1}
set mail2={email address #2}
set mail3={email address #3}
set mhost={mail server host}:{port}
set from={username@server name}

REM - copy the %BSE% baan app environment !!!!!!!!!!!!! First

echo "Starting BaaN backup" > %tmp%
date /t >> %tmp%
time /t >> %tmp%

start XCOPY /D /Q /H /R /O /Y /K /E E:\baan H:\hot\baan\

echo "Finished BaaN backup" >> %tmp%
date /t >> %tmp%
Time /t >> %tmp%

IF EXIST C:\schedJobs\Logs\HotBackup_BaaN_PRD.rpt move C:\schedJobs\Archive\HotBackup_BaaN_PRD.rpt

REM ----- starting hotbackup mode ---------

echo "Starting database hotbackup" >> %tmp%

REM ----------------- Do actual copy -------------------------

echo "Starting file copy" >> %tmp%

sqlplus -s system/password @%bj%HotBackup_BaaN.sql

echo "Finished database hotbackup" >> %tmp%
date /t >> %tmp%
Time /t >> %tmp%

REM ------------- ending hotbackup mode ----------------------

set user={baan user}
licmon -c

REM - Mail to every Key people showing the time Baan was offline ------
REM - Separate mail to me - below - that shows total time backup itself took -----
d:\blat\blat %tmp% -t %mail1%,%mail2%,%mail3% -s "Hot Backup of BaaN Production rpt" -server %mhost% -f %from%
d:\blat\blat %tmp1% -t %mail3% -s "Hot Backup of BaaN - Internals rpt" -server %mhost% -f %from%
exit


Notes:
1) BLAT is available on line - freeware
2) the HotBackup_BaaN.sql is a generic script that puts Tablespaces individually into hot backup mode
3) I usually use the third email for my text message to my cell phone (usually something like
123456789@somevendor.com). This lets me get a page when all is finished so I get and inidcator of
any problems that may crop up.
4) modify any settings you may need to change for your environment
5) the "FROM" variable information is arbitrary. Set to something that you can filter the email with
i.e. BaanBackup@{servername}