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.

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  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

what is ora 600?

1 Answers  

---

how can you record information about current session?

0 Answers   Oracle,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---