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.

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Datapump backup steps?

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

what are the differences of where and if in SAS?

0 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

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

2 Answers   Mphasis,

---