Solved

Recover Oracle Using Multiple RMAN backupsets

Posted on 2009-05-06
2
534 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 500 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

705 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