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.

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

0 Answers  

---

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

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

What is the difference between Datapump & export/import?

2 Answers  

---

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

2 Answers   Mphasis,

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---