?
Solved

Recover Oracle Using Multiple RMAN backupsets

Posted on 2009-05-06
2
Medium Priority
?
536 Views
Last Modified: 2013-12-18
Environment is Oracle Enterprise Edition 10.2.0.3, Solaris 10.

Full cold backups of our 3TB data warehouse are done with RMAN when possible. Sometimes, that is only once each month, due to system maintenance by Unix Ops or other business priorities.

I do not have enough space to archivelog. We spit out 350G of logs (each 1.2M) every week. We have approximately 580 tablespaces and about 630 datafiles. (I inherited that!!). Most of our partitioned tables are in monthly partitions, and they are never archived off. Only our daily partitioned tables have a limited retention policy of 90 days.

Currently, our RMAN backup takes about 13 hours, and the backupset is stored on a storage array where no other production files exist. The compressed backupset uses about 600m.

Due to the fact that "the business" sometimes comes out of the woodwork and asks to update or modify huge partitioned tables (we have about 30 of them) that contain data going back as far as 1998, I have never been able to get a commitment to mark some of these tablespaces as read only. Now, I have been given a list of about 140 tablespaces that can be marked read only.

So, I plan to do a new "baseline" RMAN backup this Sunday, after which I want to mark the approved tablespaces as read only. Future RMAN backups should skip the read only tablespaces, so long as I retain the original baseline backup. Are there any circumstances where that would not be true? If our storage array went up in flames and we lost everything, how would I go about recovering using the baseline and the most recent backup that contains everything except the read only tablespaces?

Would I be better off creating a separate backup of only the tablespaces that are going to be marked as read only, then another backup AFTER they have been marked?

Most of the literature I have explored deals with shops that use archivelogging, and I have not discovered a recovery scenario that describes how I could recover the entire database in a case like ours.

Thanks in advance.

Mike

NA

Open in new window

0
Comment
Question by:groucho47
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 24319227
Create separate backups for the read-only tablespaces and KEEP them.
Do regular backups of the rest of the db.
Do incremental backups (set block-tracking for speed).
 
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question