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: Q:Partial backup database using rman

Re: Q:Partial backup database using rman

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Mon, 27 Mar 2006 15:06:53 -0600
Message-ID: <de807caa0603271306q5bd4f582nbea798db90c3042@mail.gmail.com>


Amihay,

These "optional" tablespaces - can you make them read-only? If all tablespaces are "optional", you might consider creating your database without them, then take a cold backup. Then your recovery model becomes:

  1. Recover cold backup.
  2. Run create tablespace scripts.
  3. Recreate user data.

If your database contains a combination of tablespaces, you may want to consider separate Oracle instances, so you can create an appropriate recovery model for each type of tablespace.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 27 2006 - 15:06:53 CST

Original text of this message

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