| Oracle 8 backup in Unixware 7 [message #97851] |
Thu, 13 March 2003 08:48  |
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  |
Frank Naude
Messages: 4589
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
