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.

What is the difference between Datapump & export/import?

2 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

How many memory layers are in the shared pool?

3 Answers  

---

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

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

What view would you use to look at the size of a data file?

3 Answers  

---