Sure: run { and last line of }
required parts
allocate channel ch1 type disk; <- you
must tell rman what media to put backups, and allocate it
set limit <- tell how big each piece should
be, 1.9G here
backup <- do a backup, incremental level 0
<= type of backup incremental, level 0, meaning do all data
blocks
tag <- internal name that you can query the rman
catalog with.
format <- where to put the files and what to
call them
database <- end of backup keyword
look at docs for backup/recovery, this is one of the most
elementary scripts, there is alot motre to it.
joe
run {allocate channel ch1 type disk;set limit channel
ch1 kbytes = 1900000;backup incremental level 0tag =
'dssmnt02_inc_0'format
'/ora_export/export/tmp/dssmnt02_inc_0_%U'database;}
>>> denmark_weatherburne_at_hotmail.com 08/14/01 09:35PM
>>>Hi Joe,I'm currently looking at RMAN as a backup and
recovery tool to automate backups to disk. I would appreciate it very much
if you could describe what each line of your script does.I'd have to do
Hot Backups though.Would this script have to change?Thanks in
advance,Denmark Weatherburne"Knowledge is power, but it is only
useful if it is shared">From: "JOE TESTA"
<JTESTA_at_longaberger.com>>Reply-To: ORACLE-L_at_fatcity.com>To:
Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>>Subject: Re: RMAN cold backup?>Date:
Tue, 14 Aug 2001 14:51:42 -0800>>cold backup in the respect that
the db has to be mounted but not open.>>here is an example(since
we're in noarchivelogmode, its our only choice). >this is an
incremental level 0, which is all.>>hth, joe>>run
{>allocate channel ch1 type disk;>set limit channel ch1 kbytes =
1900000;>backup incremental level 0>tag =
'dssmnt02_inc_0'>format
'/ora_export/export/tmp/dssmnt02_inc_0_%U'>database;>}>>>>
>>> pbaumgartel_at_mortgagesight.com 08/14/01 05:53PM
>>>>>I'm frantically R'ing TFM, but I can't find the
answer to a simple >question: Can I use RMAN to perform a cold
backup? If so, how? TIA!>>Paul
Baumgartel>MortgageSight Holdings,
LLC>pbaumgartel_at_mortgagesight.com_________________________________________________________________Get
your FREE download of MSN Explorer at <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author: Denmark
Weatherburne INET: denmark_weatherburne_at_hotmail.comFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Aug 14 2001 - 20:19:22 CDT
