This content has been marked as final. Show 3 replies
When you completed a Oracle 10g DBA Course then
Question 1: Will be part of your next course RMAN Backup and Recovery
Question 2: Never trust on defaults, the best answer is: check the view DBA_DIRECTORIES
Question 3: If you completed your course, you should be able to answer this, if not start reading your books again and again.
Question 4: see Question 1.
It is not a problem to be a beginner but you can act like a professional.
This means try to study hard, proof for yourself how things work and do a lot of research before asking questions.
1. after taking the backups of redolog files, suppose I give the command "Delete input". What will happen?
you can not take a backup of online redolog files.
but if you mean archived redologs, bakcup archivelog delete input : means take a backup of existing archivelogs as backupset and delete them
2. In windows, using Datapumb, we are exporting the data and we are not giving any directory, by default in windows machine where the data will be exported?
use the following SQL query to find the default location of data pump:
select owner, directory_name, directory_path from dba_directories where directory_name like 'DATA_PU%';
3. What happens in Oracle Architecture, after a insert command is fired. ie;, Flow in architecture, like how data is stored in database. (asked to draw the architecture and explain)
actually this is very long question, and can not be explain in just words.
4. How to take one day old backup & command used?
I don't understand you question.
Kindly help me out. I knw these questions are basic still for my knowledge.