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 ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

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

2 Answers   IBM,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

what is ora 600?

1 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---