HELP! How to organize backups/exports/archiving?
Date: 1995/11/08
Message-ID: <DHqBLH.98C_at_mecati.mecasoft.ch>#1/1
Hi !
I'm in progress to organize the physical security for our Oracle
database. We have 3 small databases, with a total of about 200Mb
of data in the $ORACLE_HOME/dbs directory.
I also have log_archive_start=true (enabled).
The oracle server is normally always running (24h/24, 7days/week). Users are about 10-20. They all works in the same time (8am-8pm), from monday to friday. Wery nice, and simple.
The network server (ie the system administrator) do a tar copy every night of all the oracle software and oracle data, but not (at the moment) of the arc files.
Now, on the oracle server I dispose a dat driver, and would like to do some (redundant) backups and exports. Here is my idea, please give me your opinion on how to improve it:
- HOT BACKUP (weekly, manually or using cron)
cd $ORACLE_HOME
tar cvf /dev/dat ./dbs/init* ./dbs/sga* ./dbs/*/*.ctl ./dbs/*/*.dbf
(note that in ./dbs I have one directory for every database)
- EXPORT + ARCHIVING (monthly, manually or using cron)
cd $ORACLE_HOME
for every database:
. exp system/<passwd> inctype=COMPLETE full=Y file=<file.exp> log=<file.log>
shutdown all databases
tar cvf /dev/dat <all_files.log> <all_arch_files>
rm <all_arch_files>
startup all databases
As you can see, I never do 'cold' backups.
Then, surprise surprise, I would like to test my backup and export files...
Is someone out there so crazy like me to think to abort the database in some brutal way (which brutal ways do you knows ?) and restore it using the files on the dat ???????
I will appreciate any suggestion and opinion,
thank you!
Stefano
- OUR INSTALLATION AT A GLANCE ------------------------
ORACLE7 Server (RDBMS) 7.1.6.2.0 CORE Version 2.3.7.1.0 Oracle Server Manager 2.1.3.0.0 Oracle Network Manager 2.1.6.0.0 SQL*Net V2 2.1.6.1.0 TCP/IP Protocol Adapter (V2) 2.1.6.1.0 PL/SQL V2 2.1.6.2.0 SQLLIB 1.6.7.0.0 SQL*Plus 3.1.3.7.1 Pro*C 2.0.6.0.0 ------------------------------------------------------------------------------ Stefano Unternaehrer Mecasoft SA Oracle DBA 6600 Muralto PL/SQL, Pro*C, C, XWindow & Motif Switzerland Europe Software Developer fax: +41 91 743 5507 email: dba,unter_at_mecasoft.ch voice: +41 91 743 7444Received on Wed Nov 08 1995 - 00:00:00 CET