Hi,

I have recently installed Oracle 9i with baan IV c4 on Windows NT.

I am new to Oracle.

From the command prompt through which Oracle command i can take the backup of my whole BaaN Database ??? so that all the baan tables comes in the backup ???

If any one using Oracle on win for BaaN , I would be greatefull , if he can share the backup procedure /document with respect to BaaN & Oracle 9i.

Regards

Learner

Hi Learner,

There are a lot of options for backing up..

An easy one would be

<shutdown baan>
exp userid=system/<password> file=baan.dmp owner=baan direct=y log=baan.log
<startup baan>

not the best one, but its a start..

Dave

Hi,

How about doing an online backup without shutting down oracle db ??? In Ms SQL Server through enterpise manager i use to take Online backup of full BaaN Database.

How should i go ahead for online backup in Oracle ??? I hope exp. command can be run when users r working !!!


meanwhile i am also reading Oracle Backup manuals on the site.

Waiting for your reply.

Regards

Learner

Hi Learner,

"alter tablespace <tablespace name> begin backup;"

is the key. There's a lot to it, i can't really explain it here. Maybe someone else has a consice doc on it, with scipts...

and no, don't use exp while users are working..

Dave

Hi,

well as u gave the hint , i searched on the net , and read about this command


alter tablespace begin backup


http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90133/backup.htm#1004914

and it says that i can do this if the database is running in ARCHIVE MODE, but when i did the baan installation with Oracle , by default it took as NOARCHIVE.

Should i make my baan db to ARCHIVE MODe, is this step performed at most of the sites where Oracle is running ?

I also read about the use of ARCHIVE and NOARCHIVE Mode.

Waiting for your reply.

Regards

Learner

Hi Learner,

Yes, you absolutely want to be running in archivelog mode. There are 2 steps, first, add the archivelog info to your init.ora and second, shutdown the DB, do a
"startup mount" and
"alter database archivelog;"

I'm not positive about the "mount" it might be "nomount"

If you're using OEM tools, then i assume there's a few clicks to turn on archivlog mode.. I don't know what those are though...

Of course now you have to make sure you're backing up your archivelogs and removing them on a regular basis!

Dave

Hi Learner,

I'm running 4c4 (Nas0) using Oracle 9i RAC on Windows 2003 Enterprise with my Baan (App Server) Machine running Windows 2000.

I think that you should at least look into using Oracle's method for backing up the database. I use Rman in batch every night to do a full backup of the entire database. Baan is only part of my Entire Database so the need is to Backup Oracle.

The backup just creates files on a drive that can moved to tape later in the evening via my Backup software. I can post my script if it would help you.

In addition, I have a JOB Scheduled in Baan that runs session ttaad4226m000 (Create Sequential Dump of Tables) every Sunday AM. The session will export all data from my production company into sequential tables. These tables are then picked up my my Backup Exec routine to a SDLT Drive.

You might need to play some tricks with Baan to get the Job into the Job Scheduler for your production Company. In my case because I run NAS0, just creating a job from the session, put the job into the Tools Company table instead of the table that is used by my production company. I used Oracle to move the data and It works fine from there.

I've been doing backups this way for about 2 years.

Roy

Hi,

Yaah I am also taking Sequential dump of table through a batch file by utilising bdbpre.exe and specifying seperator as '!'. I hope this is OK.

Regarding RMAN script which you are executing, could you please post the script so that i can verify and re-use the same.

and one more question , are you running your baan oracle db in ARCHIEVE MODE ???

Thanks in advance.

Originally posted by learner
Hi,

Yaah I am also taking Sequential dump of table through a batch file by utilising bdbpre.exe and specifying seperator as '!'. I hope this is OK.

Regarding RMAN script which you are executing, could you please post the script so that i can verify and re-use the same.

and one more question , are you running your baan oracle db in ARCHIEVE MODE ???

Thanks in advance.

Yes I'm running in Archive Mode. Note also that using oracle RAC (Real Application Clusters) I have two machines running windows 2003 Enterprise both running Oracle. They both access the same database on an IBM Fibre Channel Storage Server. Note also that I haven't re-booted either machine for 6 weeks now!

Both instances of Oracle must run in Archive Mode.

Also, the script I created for rman is below:

replace script Baan_backup {
allocate channel c1 type disk;
backup incremental level=0
format 'G:\Rman_bck\dF_%d_%s_%p.bck'
tag = Backup01
filesperset = 4
(Database include current controlfile);
release channel c1;
}

You can also use Rman to backup your Archive Log files. I just use backup exec to do that. There are many things you can do with Rman and best of all, it knows how to backup the database while the database is running.

Roy