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;

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3183

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

807

---

What the different types of replication and why are they used? : sql server DBA

865

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1861

---

how can a session indicate its interest in receiving alerts?

785

---

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

837

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2224

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1917

---

How would you extract DDL of a table without using a GUI tool?

2242

---

what are the performance views in an oracle rac environment?

813

---

What is dbcc? : sql server DBA

995

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

749

---

how can you communicate with operating system files from oracle?

794

---

what functionality does oracle provide to secure sensitive information?

775

---

how can you record information about current session?

743

---