GeekInterview.com
Series: Subject: Topic:
Question: 24 of 52

SCN based hot backup recovery

Outline the steps involved in SCN based recovery from the full database from hot backup?
Asked by: shanthiavari | Member Since May-2008 | Asked on: Jun 10th, 2008

View all questions by shanthiavari

Showing Answers 1 - 1 of 1 Answers
Mahender

Answered On : Nov 1st, 2012

The steps are:
1) Shutdown the database
2) Restore data files
3) Mount the database
4) Recover the database
(sql> recover database until time 2005-12-14:12:10:03 Time base)
(sql> recover database until change scn base)
5) Open the database with the resetlogs option
(sql>atler database open resetlogs)

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Backup and Recovery

Basics

Concepts and Architecture

D2K

Data Access

Database Administration

Database security

Database Tuning

Distributed Processing

General

Memory Management

Oracle Forms 4.0

PL/SQL

Programmatic Constructs

RMAN Interview Questions

Scenarios

SQL

SQL Plus

System Architecture

Interview Coaching

Tell me three things about you, which are not found in your resume

Aptitude Test Preparation Tips

How productive are you?

What is the role of a mechanical engineer in the Software Industry?

What are my options when I do not get a job after graduation?

Describe a time when you had to convince a friend ?

Have you gone above and beyond your job description?

What are the career opportunities available for MCA Graduates?

What are the things you wish to achieve in 5 years?

Has anyone asked you for help? What did you do?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe