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;

Which autogrowth database setting is good? : sql server DBA

1155

---

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

1089

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1287

---

What is a correlated sub-query? : sql server DBA

1085

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1001

---

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

2202

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1079

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2359

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2501

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1067

---

What is the importance of a recovery model? : sql server DBA

1026

---

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

1073

---

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

1078

---

What the different topologies in which replication can be configured? : sql server DBA

1265

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1002

---