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;

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

581

---

how can you schedule a job in database?

603

---

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

551

---

internal architecture

1756

---

what functionality does oracle provide to secure sensitive information?

558

---

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

567

---

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

6527

---

What is dbcc? : sql server DBA

777

---

what is the use of recording information about current session?

574

---

when does an alert gets signaled?

584

---

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

1751

---

How would you go about verifying the network name that the local_listener is currently using?

2764

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3811

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3313

---

Explain materialized views and how they are used.

1896

---