Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / narmada kumari


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

Answer / 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

More DB Administration Interview Questions

Explain the use of table functions.

1 Answers  

what is the role of dip user in our database?

0 Answers  

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

How do you resize a data file?

2 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

deleted of control file how will u recover control file?

4 Answers   CTS,

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

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

0 Answers  

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

0 Answers  

For more DB Administration Interview Questions Click Here
Categories