You have taken a manual backup of a datafile using os. How rman will know about it?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by oracle dba and what is its role?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What is a junior dba?
What does >> do?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What is the difference between truncate and delete? How would a full table scan behave after?
What does a dba do all day?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
You see multiple fragments in the system tablespace, what should you check first?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?