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

Answer / nagesh yadav

1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

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

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

Explain CREATE DATABASE syntax?

2 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---