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
how to restore files with rman?
How would you extract DDL of a table without using a GUI tool?
Explain materialized views and how they are used.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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.
What are statistics, under what circumstances they go out of date, how do you update them?
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
Query processing is slow(eg select query)how will u solve that
What is transparent data encryption? : sql server DBA
what is the diffrence between core dba and apps dba?
What is a correlated sub-query? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you enable flashback feature?
how can you initialize log miner?