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 we know the exact updation date of a particular database?

2 Answers   Satyam,

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

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

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---