Home » Infrastructure » Unix » Oracle 8 backup in Unixware 7
Oracle 8 backup in Unixware 7 [message #97851] Thu, 13 March 2003 08:48 Go to next message
Dondo Alpha
Messages: 2
Registered: November 2002
Junior Member
I have an Oracle database running on Unixware 7.1 and has the following structure:

I have three control files in the following directories

/asy/ASY_DB/ctl
/home/ASY_DB/ctl
/home2/asy/rdbms

redo logfiles are in /home2/asy/rdbms

datafiles are in /home2/asy/rdbms/ASY_DB and the datafiles are:-

idx01ASY_DB.dbs
rbs01ASY_DB.dbf
ref01ASY_DB.dbs
sad01ASY_DB.dbs
sad01_idx.dbs
sys01ASY_DB.dbf
temp01ASY_DB.dbf
tra01ASY_DB.dbs

archive log files are in /home/ASY_DB/arch

I do a backup twice a day, one at lunch time which is a full export of the database and the other one in the evening where i backup all the control files, datafiles, redo logs and the archived redo logs whilst the database is down. In two months time the system is supposed to run twenty four hours everyday and now how can i do my backup with minimal stoppage time bearing in mind that at the moment my evening backup is taking close to 2 hours.

I have tried to go thru the rman utility but it is a bit confusing. Can someone give me the best solution.
Re: Oracle 8 backup in Unixware 7 [message #97855 is a reply to message #97851] Mon, 17 March 2003 01:26 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

I would give RMAN another try. See the Oracle Backup and Recovery FAQ (http://www.orafaq.net/faqdbabr.htm) on this site for some pointers.

If you really do not want to work with RMAN, you can

1) Put the tablespaces in backup mode (ALTER TABLESPACE xxx BEGIN BACKUP;);

2) Copy the files to tape; and

3) End the backup (ALTER TABLESPACE xxx END BACKUP;).

Best regards.

Frank
Previous Topic: Oracle 7 with Solaris 8
Next Topic: Compressed files
Goto Forum:
  


Current Time: Thu Mar 28 16:11:15 CDT 2024