| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> NT: Re: Win2k Backup
Tavo,
The most important thing about backup is - recovery. If you use the ARCServeIT product for creating a (hot/cold) backup set, its likely that you'll want to recover using the ARCServeIT GUI. Have you ever tested restoring from a backup set with their product?
My philosophy on this is - the ARCServe or Veritas Oracle Agents just look into the data dictionary to find the info that they need - same as any good scripted backup set would do. You could use a batch script/sql script to perform exactly the same thing - but to disk (which would be copied to tape without an Oracle Agent). Would you rather recover from disk, or from tape?
What they give you is the ability for a non-DBA to recover the database,
using the GUI.
A database deployed at a client site typically would like to have a GUI
for recovery, and have a vendor that they can call for support if they
have a problem.
If you are going to recover the database, then you have more freedom to choose the method of backup and recovery.
I'll be giving a presentation at NYOUG's DBA SIG on 17-April including scripted backups with compression for NT/W2K. They're actually pretty simple, here's the framework for the cold backup: (a hot backup version is also used)
<man_page>
ntbackup - Command line parameters - ntbackup /? at command prompt -
Windows 2000 Pro
You can perform backup operations at the command prompt or from a batch
file using the ntbackup command
followed by various parameters.
Syntax:
ntbackup backup [systemstate] "bks file name" /J {"job name"} [/P {"pool name"}] [/G {"guid name"}] [/T { "tape name"}] [/N {"media name"}] [/F
{"file name"}] [/D {"set description"}] [/DS {"server name"}] [/IS
{"server name"}] [/A] [/V:{yes|no}] [/R:{yes|no}] [/L:{f|s|n}] [/M
{backup type}] [/RS:{yes|no}] [/HC:{on|off}] [/UM]
</man_page>
I have actually restored and recovered from this method Also, the backup jobs document the location of all of the files in the cold_backup.bat - so the location of all of the files is recorded.
In general, if you have the spare space on disk - (and with 18 GB drives being the norm - of course you have the spare space) I like to keep the previous night's hot backup set on disk, the previous weekend's cold backup set, as well as the full week's worth of archived redo.
Here is a sample output from an AT command:
Status ID Day Time Command Line
-------------------------------------------------------------------------------
1 Each M T W Th F 10:00 PM
D:\Oracle\Admin\PROD\exp\export.bat
2 Each M T W Th 10:15 PM
D:\Oracle\Admin\PROD\batchjobs\run_hot_backup.bat
3 Each F 10:15 PM
D:\Oracle\Admin\PROD\batchjobs\run_cold_backup.bat
4 Each M T W Th F 10:30 PM
D:\Oracle\Admin\TEST\exp\export.bat
5 Each M T W Th 10:45 PM
D:\Oracle\Admin\TEST\batchjobs\run_hot_backup.bat
6 Each F 10:45 PM
D:\Oracle\Admin\TEST\batchjobs\run_cold_backup.bat
7 Each M T W Th F 11:15 PM
d:\Oracle\Admin\DEV\exp\export.bat
8 Each F 11:30 PM
d:\Oracle\Admin\DEV\batchjobs\run_cold_backup.bat
each db is exported nightly - check the logs for logical corruption.
PROD and TEST are in acrhivelog mode - hot backups each weeknight, cold
backup on Fridays.
DEV is in noarchivelog mode - so a recovery from an export is not so
bad.
I keep a set of empty datafiles (compressed) around, so that if I need
to recover from an export, I do not need to create the database first.
improvments that I've been looking at:
calling this set with the db_name (db_name in 'DEV','TEST','PROD') and
having no hard-coded values.
using blat to send the logfile to a mail account.
using the command srvinfo.exe to record free hard drive space before and
after.
The script sets will be posted at http://www.nylug.org sometime after
the presentation.
I haven't used RMan on a real DB yet - maybe after the IOUG conference,
I'll be inclined to do so.
hth,
Paul
Paul Drake
paled_at_home.com
Luis DeUrioste wrote:
>
> Dear List Members:
>
> We are in the planning stage of upgrading from NT 40 to Windows2000
> and from 8.0.5 to 8.1.7 and I'm putting my ducks in a row. My
> question is, has anybody used Win2k Backup to Backup the database ?
> Can it handle ? somehow ? shutting down the DB for cold Backups ? I
> currently use ArcServIT with the Oracle Agent and it handles the whole
>
> "Enchilada". Should I upgrade ArcServIT and keep it? Are there any
> better Backup Solutions? Any input will be appreciated.
>
> Regards
>
> Tavo
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: paled_at_home.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).Received on Sat Apr 07 2001 - 13:02:43 CDT
 |
 |