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;

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

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

1 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

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

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---