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 to restore files with rman?

1998

---

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

2260

---

Explain materialized views and how they are used.

2165

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1754

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2200

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2330

---

What are statistics, under what circumstances they go out of date, how do you update them?

2033

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1733

---

Query processing is slow(eg select query)how will u solve that

7260

---

What is transparent data encryption? : sql server DBA

840

---

what is the diffrence between core dba and apps dba?

2334

---

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

808

---

How can you control the amount of free space in your index pages? : sql server DBA

1029

---

how can you enable flashback feature?

743

---

how can you initialize log miner?

869

---