Answer Posted / kittu_chintu2005

Method 1:
SQL>STARTUP NOMOUNT;
SQL>CREATE CONTROLFILE REUSE DATABASE "DB_NAME" ARCHIVELOG RESETLOGS
LOGFILE
GROUP 1 ( 'location of redo1a.log','location of redo1b.log') size XXmb,
GROUP 2 ( 'location of redo2a.log','location of redo2b.log') size xxmb
DATAFILE
'location of system.dbf',
'location of users.dbf',
'location of temp.dbf',
'location of ts1.dbf';
SQL>RECOVER DATABASE;
SQL>ALTER DATABASE OPEN RESETLOGS;

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1082

---

What the different components in replication and what is their use? : sql server DBA

1055

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1987

---

What are the commands used in dcl? : sql server DBA

1077

---

Why would you use sql agent? : sql server DBA

1092

---

what is the use of ocr?

1033

---

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

2492

---

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

2572

---

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

1051

---

what is the diffrence between core dba and apps dba?

2576

---

Which autogrowth database setting is good? : sql server DBA

1163

---

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

1892

---

what are the performance views in an oracle rac environment?

1057

---

how can you process messages in order asynchronously?

981

---

how can you create a user-defined lock?

1022

---