What is the difference between obsolete and expired status?

Oracle expert Brian Peasland explains the difference between obsolete status and expired status.

Published: 11 Jan 2008

I am working as a DBA, handling production database using Recovery Manager (RMAN). I want to know the difference between obsolete and expired status.

A status of "expired" means that the backup piece or backup set is not found in the backup destination. With tape management systems, the automated tape library routines will expire files on the tape once a certain period of time has passed. RMAN uses this terminology to say that the tape management system has expired the file. It is no longer available. Therefore, the backup piece is expired as well.

A status of "obsolete" means the backup piece is still available, but it is no longer needed. The backup piece...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

is no longer needed since RMAN has been configured to no longer need this piece after so many days have elapsed, or so many backups have been performed. RMAN's retention configuration determines when a backup piece becomes obsolete.

Dig Deeper on Oracle database administration

Oracle RMAN (Oracle Recovery Manager) Oracle RMAN (Oracle Recovery Manager) is a utility built into Oracle databases to automate backup and recovery; it includes features not available in third-party backup tools.

Which vendors support Oracle RMAN backup and recovery? It's important to carefully analyze if a given backup software platform supports Oracle RMAN backup and recovery, as the level of support varies from vendor to vendor.

Choosing the best Oracle backup strategy for your environment Find out which Oracle backup strategy is right for you in this FAQ: user-managed backups, RMAN or import/export backups.

Quantum gives DXi7500 deduplication system a tuneup Seeking to deduplicate data more efficiently across sites and storage tiers, Quantum upgrades the software and bumps up capacity for its DXi7500 disk backup device.

How to FTP files in Oracle from an ASM disk to a non-ASM disk Oracle expert Brian Peasland explains how to FTP from an ASM disk to a non-ASM disk after an RMAN backup.

To manage your backup load, identify your data In an ever more pressurised IT world, where data grows exponentially year on year, do we really know what data we are securing every day, week or month? Even more pertinent, do we know what data we are retaining?

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Please create a username to comment.

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database administration

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.