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;

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

2667

---

when does an alert gets signaled?

1110

---

What is the default fill factor value? : sql server DBA

1182

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2123

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1121

---

how can you initialize log miner?

1186

---

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

2309

---

What is the default port no on which sql server listens? : sql server DBA

1213

---

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

1238

---

how can you communicate with operating system files from oracle?

1091

---

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

8037

---

What are the different sql server versions you have worked on? : sql server DBA

1069

---

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

1164

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4478

---

How to start SQL Server in minimal configuration mode?

8081

---