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;”

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

2733

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

---

how can you connect from 10g user to 11g user??

2117

---

What happens on checkpoint? : sql server DBA

1097

---

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

4351

---

how can you initialize log miner?

1149

---

Why would you use sql agent? : sql server DBA

1090

---

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

1055

---

how can you schedule a job in database?

1127

---

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

2253

---

What are the recovery models for a database? : sql server DBA

1132

---

how can you communicate with operating system files from oracle?

1051

---

what are the benefits of flashback feature?

1024

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2568

---

What purpose does the model database server? : sql server DBA

1196

---