Re: rman restore from consistent backup
Date: Tue, 10 Feb 2009 23:36:47 +1100
Message-ID: <gmrs45$u4e$1_at_news.motzarella.org>
Charles Hooper wrote,on my timestamp of 10/02/2009 4:08 AM:
> that RMAN book by Robert Freeman. Page 27 indicates that for a
> database in NOACHIVELOG mode, the correct way to backup the database
> is to shut down the database, backup the files, and then restart the
> database. Page 245 states "RMAN will not prevent you from doing a
> tablespace or datafile backup in NOARCHIVELOG mode (as long as the
> database is not open). However, these backups are not really all that
> usable when the database is in NOARCHIVELOG mode (unless you back up
> all the tablespaces and datafiles at the same time)."
>
> Contrast that advice to the advice shown here in "RMAN Recipes for
> Oracle Database 11g" (another book that I own):
> http://books.google.com/books?id=qISYkSBV2hgC&pg=PA10
> "If you're running the database in noarchivelog mode, the recommended
> approach to backing up the database is to shut down the database
> cleanly first and then to back up all the datafiles. If you're using
> RMAN to perform an offline backup, the database must be mounted before
> you can actually perform the RMAN backup. This is because RMAN needs
> to update the target control file."
>
> To help the OP, what is the correct way to back up the database in
> noarchivelog mode? The error reported indicates that an inconsistent
> backup was captured. I wonder if the backup was captured after a
> shutdown abort, or a failed shutdown immediate - see the timeout note
> at the bottom of this page:
> http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/start003.htm
I've been using rman to backup noarchivelog dbs for a coupla yeras now, with the db in mount mode. The restore is very simple: restore first the controlfile taken during the backup and then restore the db. Works everytime, tried many, many times. 10.2.0.3 here. Received on Tue Feb 10 2009 - 06:36:47 CST