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;

who owns the operating system files created by the utl_file package?

1020

---

What is the difference between clustered and non-clustered index? : sql server DBA

1033

---

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

1242

---

What are the operating modes in which database mirroring runs? : sql server DBA

1117

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1990

---

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

1034

---

what is ora 24313?what is the procedure to exclude that error?

2523

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2141

---

What would you do with an "in-doubt" distributed transaction?

1839

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2494

---

what is a crs resource?

1122

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2283

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2117

---

What happens on checkpoint? : sql server DBA

1041

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2576

---