Answer Posted / kittu_chintu2005

Startup mount
Alter database archive log;
Alter database begin backup;
Alter tablespace ts_name begin backup;
Copy the *.dbf & *.ctl files @ os level when copying completed issue the statement “alter database end backup;”

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2039

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2088

---

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

1154

---

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?

2551

---

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

3269

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2346

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2780

---

what is asm?

1109

---

which background process invoke at the time of upgradation tell me???

2778

---

Which autogrowth database setting is good? : sql server DBA

1231

---

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

1089

---

when does an alert gets signaled?

1106

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1955

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1248

---

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

1160

---