1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

how will u see whether the dabase is in archive log mode or not?

Question Posted / kittu

Answers were Sorted based on User's Feedback



how will u see whether the dabase is in archive log mode or not?..

Answer / kittu

in two ways we can check
1) archive log list
2) select log_mode from v$database;

Is This Answer Correct ?    10 Yes 0 No

how will u see whether the dabase is in archive log mode or not?..

Answer / krishna

archive log list
select log_mode from v$database;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB Administration Interview Questions

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  

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

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

0 Answers  

Why would you call update statistics? : sql server DBA

0 Answers  

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

3 Answers  




What is RAID and what are different types of RAID configurations?

1 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

what is ora 600?

1 Answers  

what is meant by gateway

1 Answers   IBM,

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  

For more DB Administration Interview Questions Click Here
Categories