Interested to Buy Any Domain ? << Click Here >> for more details...
Explain how you would restore a database using RMAN to Point
in Time?
- 1 Answers
- 6707 Views
- I also Faced
- E-Mail Answers
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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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
when does an alert gets signaled?
what is a user-defined lock?
How to start SQL Server in minimal configuration mode?
Query processing is slow(eg select query)how will u solve that
what are the differences of where and if in SAS?
What is dbcc? : sql server DBA
how can you initialize log miner?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the role of dip user in our database?
What are the commands used in dcl? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Explain materialized views and how they are used.
