| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: V7 online backups
Charlie,
You must first put your database in ArchiveLog mode, of course. The basic
init.ora parameters to set and the command "Alter Database ArchiveLog"
(while mounted, but not open, after a clean shutdown) haven't really changed
from 7 to 8 to 8i, except now you can specify archive log duplexing.
A simple SQL script might get you started. For each Tablespace:
Alter Tablespace <TS1> Begin Backup ;
Host cp <source_directory>/ts1_datafile_1.dbf <target>
Host cp <source_directory>/ts1_datafile_2.dbf <target>
...
Alter Tablespace <TS1> End Backup ;
...
Save the datafile copies and your archived redo logs, as well as backup control files, and you've got it covered. Oh, and don't back up your online redo logs - they'll be worthless for a recovery and can cause you grief if you restore them over your current, good, ones.
Jack
-----Original Message-----
Mengler
Sent: Thursday, December 06, 2001 12:29 PM
To: Multiple recipients of list ORACLE-L
I'm not sure if I'm bragging or complaining, but I've never setup or supported online backups for Oracle. I'm being directed to implement online backups for a V7.3.4.5 instance. A search of OTN reveals that Oracle no longer seems to have any V7 documents available anymore. :-(
Since this DB is stuck at V7.3.4.5 for at least 6 more months, I need to get online backups operational without using RMAN. If somebody who has *nix shell script(s) or Perl code that implements online backups, I'd appreciate if you would send a copy my way. I'm just looking for something to get me started.
TIA & HAND!
-- Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(dat e_time,86400)/86400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem_at_mwh.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Dec 06 2001 - 17:42:35 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: japplewhite_at_inetprofit.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |