Answer

How to restore a database using RMAN to Point in Time

An Oracle user asks how to restore a database using RMAN to Point in Time.

Brian Peasland

By

Brian Peasland

Published: 10 Jul 2008

How would you restore a database using RMAN to Point in Time?

This question can easily be found in this Oracle documentation.

The RMAN command to perform Point In Time Recovery (PITR) is:

RECOVER DATABASE ;

The can take many forms as found here.

You can recovery until a specific SCN, a specific log sequence, a restore point, or a specific time. To recover to a specific point in time, use:

RECOVER DATABASE UNTIL TIME "TO_DATE('12/01/07 13:15','MM/DD/YY HH24:MI')";

Dig Deeper on Oracle database administration

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

SearchDataManagement

Aiven raises new funding as cloud data service demand grows
The open source cloud database-as-a-service platform vendor is seeing continued demand for Kafka as organizations increasingly ...
The challenges of cloud data management
Cloud platforms are expanding rapidly, causing organizations to face new cloud management challenges keeping pace with cloud data...
Couchbase Capella brings new managed DBaaS capabilities
The NoSQL database vendor launched a DBaaS platform providing a fully managed cloud database aimed at users who don't want to ...

SearchBusinessAnalytics

Google Cloud unveils roadmap for its analytics platform
The Google Cloud Platform roadmap, unveiled during the tech giant's recent virtual user conference, includes capabilities ...
MLB Statcast delivering real-time insights with Google Cloud
With Google Cloud to process and transform data collected during games by its tracking technology, Major League Baseball is ...
Data warehouses and holistic business intelligence
Data warehouses help companies gather analytics on individual systems and data for a holistic view of company performance, spot ...

SearchSAP

Google-Lemongrass partnership boosts SAP on GCP
Google stakes its claim as the best public cloud option for SAP workloads thanks to a new partnership with Lemongrass, a ...
The at-a-glance guide to the latest SAP ERP choices
IT leaders may find it difficult to distinguish between the versions of S/4HANA. Here's a cheat sheet on the strengths and ...
What's next for SAP HANA 1.0 users
SAP HANA 1.0 is now out of mainstream maintenance. Here's how that pertains to an SAP HANA 2.0 upgrade and what happens if users ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...
SQL Server in Azure database choices and what they offer users
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

5 best Java 17 features that developers will love
The new Java 17 release contains plenty of new features that will intrigue developers. Here are five features that should push ...
3 simple Java Hello World examples
Are you a developer who's new to Java? Here are three ways to write a Hello World program in Java on Eclipse and get started with...
5 reasons why Java is still the best programming language
Here's why Java is still the most popular programming language for everything from mobile development to enterprise and ...

SearchDataCenter

Bust latency with monitoring practices and tools
Improve latency across your data center's infrastructure by exploring its causes, a handful of best practices and tools you can ...
Best practices for container security in the data center
Container sprawl and container repositories can introduce new vulnerabilities to a data center. Here's what organizations should ...
How to check your CPU in a Linux system
You can issue commands through your Linux CLI to gather CPU information, including detailed information on cores, class, ...

SearchContentManagement

OpenText releases document capture, Salesforce integrations
Like Salesforce, Box and Adobe, OpenText invests in AI and machine learning to enable smartphone document capture so users can ...
Hyland execs offer insight into content services roadmap
After an acquisition binge, Hyland Software pauses to discuss its acquisition strategy and future roadmap, which may include more...
Box adds ransomware content security
In its pursuit of enterprise business, Box Shield adds security features that may circumvent ransomware; Box Sign available for ...

SearchHRSoftware

'Intelligent workplace' tools, video calls create anxiety
The role of technology and automation in the so-called 'intelligent workplace' was the focus of a lively debate at a conference ...
SuccessFactors expands internal talent marketplace concept
SAP SuccessFactors' new Opportunity Marketplace aims to create a holistic view of employees and connect them with short- and ...
Employer vaccine mandates set stage for return to office
COVID-19 mandates may be clearing the way to a return to the office, but employees may still have concerns about office air ...

Close