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;

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

2580

---

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

2481

---

What are the steps you will take to improve performance of a poor performing query?

2791

---

What is transparent data encryption? : sql server DBA

1114

---

Explain materialized views and how they are used.

2381

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1702

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1149

---

how can you communicate with operating system files from oracle?

981

---

how can you implement fine-grained auditing?

1066

---

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

2059

---

What are the different ways you can create databases in sql server? : sql server DBA

1076

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2033

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2398

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1050

---

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

1112

---