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

SearchDataManagement

Backup hardware devices: 2017 Products of the Year finalists

DBAs must master the art of database recovery management

Oracle RMAN (Oracle Recovery Manager)

hot backup (dynamic backup)

Please create a username to comment.

Snowflake expands cloud data warehouse capabilities

Big data security management embraces governance, privacy

GDPR, CCPA, cloud drive security management tool makeovers

U.K. agency uses Oracle analytics to ID annual savings

Analytics critical to decisions about how to return to work

Data science interview preparation: How to answer top questions

SAP, InstaFreight partner to reduce freight costs, complexity

SAP S/4HANA Cloud 2005 focuses on supply chain

SAP HANA database turns 10

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

Focus on the artifact for an organizational DevOps strategy

Quarkus goes GA, gains Red Hat Runtimes support

The Ben Franklin Effect and software developer career advice

How to prevent and recover from server failure

Pick a data center layout: Raised floors vs. overhead cabling

Traditional vs. converged vs. hyper-converged infrastructure setups

The end of life for SharePoint 2016 is fast approaching

4 cloud ECM best practices for businesses to heed

Adobe Experience Manager buoys U.S. census during pandemic

Zuckerberg lists benefits, drawbacks of remote work

HR technologies solidify HR employee experience near and far

AI in HR recruitment targets high-demand technology talent

Dig Deeper on Oracle database administration

Backup hardware devices: 2017 Products of the Year finalists

DBAs must master the art of database recovery management

Oracle RMAN (Oracle Recovery Manager)

hot backup (dynamic backup)

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.