Home » Other » Training & Certification » Urgent RMAN related answers needed
Urgent RMAN related answers needed [message #281428] Fri, 16 November 2007 17:11 Go to next message
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 #281435 is a reply to message #281428] Fri, 16 November 2007 18:31 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
a)You can do it by making retention policy to 60 days.

RMAN related answers needed [message #281436 is a reply to message #281435] Fri, 16 November 2007 18:34 Go to previous messageGo to next message
nitesh_79
Messages: 6
Registered: May 2007
Junior Member
So the answer to Q1 is D and what about in second question?

Thanks!

[Updated on: Sat, 17 November 2007 11:23]

Report message to a moderator

Re: Urgent RMAN related answers needed [message #281448 is a reply to message #281436] Fri, 16 November 2007 23:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
And hurry up...this is URGENT !!
Re: Urgent RMAN related answers needed [message #281499 is a reply to message #281448] Sat, 17 November 2007 11:22 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: mock exams ocp(developer) 10g
Next Topic: DB CACHE
Goto Forum:
  


Current Time: Thu Dec 08 12:31:59 CST 2016

Total time taken to generate the page: 0.12783 seconds