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

Answer Posted / braj123

Requirements for database restore using RMAN point in time:
* database must be running in Archive Log mode.
* Must have the full backup of the database and redologs
of the period from the backup and current time(find by SCN
NUMBERS).

Steps:

> SHUTDOWN IMMEDIATE;
>STARTUP MOUNT;
>RUN
{
SET UNTIL SCN 1000;
# Alternatives:
# SET UNTIL TIME 'Nov 15 2004 09:00:00';
# SET UNTIL SEQUENCE 9923;
RESTORE DATABASE;
RECOVER DATABASE;
}
>alter database open resetlogs;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to restore files with rman?

1998


How would you extract DDL of a table without using a GUI tool?

2260


Explain materialized views and how they are used.

2165


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1754


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2200


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2330


What are statistics, under what circumstances they go out of date, how do you update them?

2033


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1733


Query processing is slow(eg select query)how will u solve that

7260


What is transparent data encryption? : sql server DBA

840


what is the diffrence between core dba and apps dba?

2334


What is a correlated sub-query? : sql server DBA

808


How can you control the amount of free space in your index pages? : sql server DBA

1029


how can you enable flashback feature?

743


how can you initialize log miner?

869