rman - uncatalog command [message #529668] |
Wed, 02 November 2011 07:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
hi,
there is a question
--------------------------------
You inadvertently delete some RMAN backups with operating system commands. You perform additional backups from RMAN again but you need to remove the deleted backups from the recovery catalog. What commands can you use to clean up the catalog? (Choose all that apply.)
A. DELETE EXPIRED
B. CROSSCHECK
C. DELETE OBSOLETE
D. UNCATALOG
E DELETE UNAVAILABLE
-----------------------------
suggested answer is BD.
B is resonable but why D intead of A.
i think that there should be AB - not BD.
that do you think?
|
|
|
|
|
|
Re: rman - uncatalog command [message #529685 is a reply to message #529682] |
Wed, 02 November 2011 09:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8935 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
An approach towards problem solving that I always take (in addition to searching the docs) is to make simple tests. For example, have you tried the answers? This is E,
RMAN> delete unavailable;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "unavailable": expecting one of: "archivelog, backu
ired, force, foreign, global, noprompt, obsolete, proxy, script"
RMAN-01007: at line 1 column 8 file: standard input
RMAN>
So E is definitely wrong.
|
|
|
Re: rman - uncatalog command [message #529688 is a reply to message #529685] |
Wed, 02 November 2011 09:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/164922.jpg) |
piotrtal
Messages: 168 Registered: June 2011 Location: Poland/Czestochowa
|
Senior Member |
|
|
John Watson wrote on Wed, 02 November 2011 15:11An approach towards problem solving that I always take (in addition to searching the docs) is to make simple tests. For example, have you tried the answers? This is E,
RMAN> delete unavailable;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "unavailable": expecting one of: "archivelog, backu
ired, force, foreign, global, noprompt, obsolete, proxy, script"
RMAN-01007: at line 1 column 8 file: standard input
RMAN>
So E is definitely wrong.
yes i know that.
but for this particular example can be either DELETE EXPIRED or UNCATALOG. both are used to delete metadata from catalog and controlfile about backups, but DELETE EXPIRED works only if I haven't got backupiece physically on the disk - if backup are expired.
so for me 60% to 40% for UNCATALOG command.
E is of course wrong.
[Updated on: Wed, 02 November 2011 09:18] Report message to a moderator
|
|
|
|
|
|
|
|
Re: rman - uncatalog command [message #529764 is a reply to message #529754] |
Wed, 02 November 2011 15:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8935 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hello again - this is my last contribution here.
This is the sort of question that I hope would not appear on an OCP exam. I was on the validation group for the 10g exams (but not for the 11g exams) and I would have rejected this one because I think it is ambiguous. This is my reasoning:
The question asks which command(s) will "remove the deleted backups from the recovery catalog". There is only ONE command listed which will do this, and that is A. The ambiguity comes in D. There is no command UNCATALOG, but there is an argument UNCATALOG that you can apply to the command CHANGE, which is another way of removing entries from the catalog.
So I would say that the only correct answer is A, but a case could be made for D. B is definitely wrong: CROSSCHECK won't delete anything. What it somes down to is that I agree with Michel: the value of going through such questions comes from studying the material, not memorizing the answers.
Hope this helps.
|
|
|
|
|