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

how to restore files with rman?

Question Posted / viks108

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

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

1 Answers   CTS,




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  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

When a user process fails, what background process cleans up after it?

1 Answers  

Name three advisory statistics you can collect.

1 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

how can you implement fine-grained auditing?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories