RE: [oracle-l] A few rman questions

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 29 Jan 2004 14:54:50 -0500
Message-ID: <005c01c3e6a1$c1503c50$8459699f@vttaxnet.tax.state.vt.us>

Dennis,
I tried it too with same os and version. Works great! I was told by OWS that the catalog is going away in the near future.

Ruth

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rich Holland   Sent: Wednesday, January 28, 2004 1:52 PM   To: oracle-l_at_freelists.org
  Subject: RE: [oracle-l] A few rman questions

DENNIS WILLIAMS wrote:

> For controlfiles, in 8i I had difficulty getting RMAN to cough up the
> control file from the backup set (RMAN wouldn't work if the
  instance wasn't
> mounted, but you can't mount the database unless you have a
  control file),
> so I back the control file up after the RMAN backup by having
  RMAN issue the
> SQL command. Others on this list report their success on this issue. I
> understand 9i is much better in this respect, but I haven't had the
> opportunity to test it.

I can't speak to 8i, but I've heard from other 8i DBA's that's the primary reason they use the recovery catalog -- it's much easier to do a complete recovery. With 9i, I didn't see the point of setting up yet another database
to manage. With controlfile autobackup enabled, you can just follow the detailed instructions in Metalink Note 174623.1 for the recovery.

I've done it (9.2.0.4 / AIX5L) and it works great! --
Rich Holland (913) 645-1950 SAP Technical Consultant print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. --
Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jan 29 2004 - 13:54:50 CST