RE: RMAN: Partial Backup: Metadata Only in Some Tablespaces and Full Data in Another

  • From: "Langston, Chris" <Chris.Langston@xxxxxx>
  • To: Mark Brinsmead <pythianbrinsmead@xxxxxxxxx>, "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>
  • Date: Tue, 23 Feb 2010 07:39:05 -0600

The recovery window is not critical. The application is really just a 
home-grown data mining tool that's used to analyze the data that's loaded into 
the database. And in the event of a disaster, that application and data would 
take a much lower priority than other databases that are more critical to our 
operations.

The reason for not using separate databases is, again, related to cost: we 
would be charged for maintaining to separate databases and that's hardly 
warranted given the size of app2.

I will raise the issue with management just to be sure they give that thought 
due diligence before proceeding. Thanks for the thought.

Chris Langston

From: Mark Brinsmead [mailto:pythianbrinsmead@xxxxxxxxx]
Sent: Monday, February 22, 2010 11:00 PM
To: Mark.Bobak@xxxxxxxxxxxx
Cc: jkstill@xxxxxxxxx; Langston, Chris; oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN: Partial Backup: Metadata Only in Some Tablespaces and Full 
Data in Another

Nope.  But creating a table in the wrong tablespace sure would.

If the applications use mutually exclusive sets of data, why not have two 
databases?  Backup one with RMAN, and the other with datapump (metadata only).

By the way, how long will it take to reload that 300GB from files?  Depending 
on your recovery window, RMAN backups may still be warranted.

On Mon, Feb 22, 2010 at 10:05 PM, Bobak, Mark 
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:
Seems to me, if you set up a backup with the 'exclude tablespace' option, and 
the list of tablespaces to exclude is hardcoded, then adding new tablespaces in 
the future shouldn't compromise anything....?

-Mark

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Jared Still
Sent: Monday, February 22, 2010 8:21 PM
To: Chris.Langston@xxxxxx<mailto:Chris.Langston@xxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: RMAN: Partial Backup: Metadata Only in Some Tablespaces and Full 
Data in Another

On Mon, Feb 22, 2010 at 11:40 AM, Langston, Chris 
<Chris.Langston@xxxxxx<mailto:Chris.Langston@xxxxxx>> wrote:
I need some help with configuring RMAN for Oracle 10gR2. I've been asked to 
submit a request to have our outsourced DBA's configure our backup to exclude 
the data in certain tablespaces while doing full data backups in another 
tablespace.

Can it be guaranteed that there will NEVER be a new tablespace added?

If not, then this is sure to cause problems in the future.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com



--
Cheers,
-- Mark Brinsmead
  Senior DBA,
  The Pythian Group
  http://www.pythian.com/blogs

________________________________
NOTICE: This email and any attachments are for the exclusive and confidential 
use of the intended recipient(s). If you are not an intended recipient, please 
do not read, distribute, or take action in reliance upon this message. If you 
have received this in error, please notify me immediately by return email and 
promptly delete this message and its attachments from your computer system.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2010