Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN in NOCATALOG mode?

RE: RMAN in NOCATALOG mode?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 18 Sep 2003 07:09:47 -0800
Message-ID: <F001.005D0615.20030918070947@fatcity.com>

It's so much easier to include an "sql "alter database backup controlfile to <filename>";
in the rman script.
Backup the Database first.
Then backup the archive logs.
Then backup the controlfile.

Hemant

At 06:54 AM 18-09-03 -0800, you wrote:
>Denham
> Whether you need to back up the control file depends on whether you can
>recover the database without it. On Oracle8i, I gave up trying to extract
>the controlfile from the RMAN backup, and simply back the controlfile up
>after the backup completes. Others on this list have reported they were able
>to extract the controlfile from the RMAN backup. I believe that on Oracle9i
>this is much improved. The important thing is that you validate your backup
>regularly because an untested backup can't be trusted.
>
>Dennis Williams
>DBA, 80%OCP, 100% DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Thursday, September 18, 2003 9:40 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hello
>
>Wondering about this. If backing up the database with RMAN in NOCATALOG
>mode.
>When would be the best time to do backup of the controlfile? Before backup /
>after backup /before and after backup.
>Does this aid your recovery from a crash? What advantage would it have?
>
>Many Thanks
>Regards
>Denham Eva
>Oracle DBA
>Linux like TeePee... No Windows, No Gates and Apache inside!
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Denham Eva
> INET: EvaD_at_TFMC.co.za
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Sep 18 2003 - 10:09:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US