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;

how can you create a user-defined lock?

0 Answers   Oracle,

---

what is asm?

0 Answers   Oracle,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

what is meant by gateway

1 Answers   IBM,

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---