RE: RMAN cold backup?

yes using netbackup and rman ...

cold_backup.rcv
#
# Shutdown the database for cold backup
#

shutdown immediate;
startup mount;
#
# Backs up the whole database cold - consistent -.
# Weekly occurence in our strategy.
#

run {
allocate channel t1 type 'SBT_TAPE';
setlimit channel t1 kbytes 2097150 maxopenfiles 32 readrate 200; backup
filesperset 12
format 'C_df_i0_t%t_s%s_p%p'
database;
alter database open;
release channel t1;
}
#

cold_backup.sh
#!/bin/ksh
# Sample script which is run from the target database
. ~oracle/.profile

ORACLE_SID=mydb
RMAN_SRC=/u01/app/oracle/admin/mydb/rman RMANLOG=/u01/app/oracle/admin/mydb/rman/rman_cold_`date '+%y%m%d'`.log

rman rcvcat userid/password_at_rcat target / cmdfile ${RMAN_SRC}/cold_backup.rcv msglog ${RMANLOG}

hope this helps ...

Nechama Glasrot
Oracle DBA
Seisint, Inc.
6601 Park of Commerce Blvd.
Boca Raton, Florida 33487
nglasrot_at_seisint.com
Direct 561.999.3977
Main 561.999.4400
Fax 561.999.4695

-----Original Message-----
Sent: Tuesday, August 14, 2001 5:54 PM
To: Multiple recipients of list ORACLE-L

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  

This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.
Thank you

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glasrot, Nechama
  INET: NGlasrot_at_seisint.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).