| Urgent RMAN related answers needed [message #281428] |
Fri, 16 November 2007 17:11  |
nitesh_79
Messages: 6
Registered: May 2007
|
Junior Member |
|
|
You set the recovery window to seven days and backup optimization to ON using the CONFIGURE command of RMAN. The most recent backup of the TOOLS tablespace to disk was taken on Jan. 3. The TOOLS tablespace is read-only.
On Feb 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also even through the contents of the tablespace have not changed after backup on Jan 3.
Because there are no changes made to the TOOLS tbs, u decide that the tbs should not be abacked up by RMAN. WHat can you do to skip backing the TOOLS tbs without changing the current backup optimization setting?
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days
*****AND*****
You want the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development enviornment. Which three sources can you select for the advisor to analyze (Choose three)
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized VIEW LOGS
|
|
|
|
|
|
|
|
|
|
| Re: Urgent RMAN related answers needed [message #281499 is a reply to message #281448] |
Sat, 17 November 2007 11:22  |
 |
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
| Reported message |
Reported By: nitesh_79 On: Sat, 17 November 2007 17:55 In: Other » Homework, Training & Certification » Urgent RMAN related answers needed
Reason His comments is an insult to the urgency of the answers needed.
|
Not reading the guidelines is an offense to the forum. In OraFAQ Forum Guide, it is clearly stated:
| Quote: |
Avoid the following keywords: urgent/please/help/now/immediately (and derivatives)
|
Nothing is urgent in forum and especially homeworks.
We help for free, we take it from our rest, so get it patiently.
If you need an urgent help, pick up your phone call Oracle or other consultant and pay for his/her time.
By the way, all questions are "urgent" for their author.
In addition, if you are interested, I most often does not answer to "urgent" question.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
