| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN QUestion
Hi
Can autobackup of control file be NOT enabled?
If you do full database backup using RMAN you get the controlfile like it or not, isn't it?
So i'd say a because with b you don't automatically get the controlfiles
Jack
"Freeman, Robert"
<Robert_Freeman_at_c To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
sx.com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RMAN QUestion
root_at_fatcity.com
21-06-2002 18:47
Please respond to
ORACLE-L
Sorry, posted using wrong subject header, DUH!
Use the following Exhibit to answer this question (note: This is not a
hacked OCP question. This question
came about out of the experience of one of our junior DBA's that I had to
come in and figure out...Several
Sr. DBA's that I know have gotten it wrong already... but we got some smart
fokls here! :-)
RMAN backup. Autobackup of control file is not enabled.
Time a - Backup of database Time b - Archivelog Backups Time c - Drop tablespace Time d - Archivelog Backup
To restore successfully, with RMAN (no manual fiddling) to time point b,
you
will first need to restore a control file. Which backup would you want to
restore the control file from... (more than one answer may well be correct,
I'm not telling).
I'll reveal the answer in the next 2 days...(and this *IS* a trick
question,
so
think carefully).
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features
Mastering Oracle8i
Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I guess if your
body's
covered in third degree burns, and your foot's caught in a bear trap, you
tend to start talkin' crazy.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: Robert_Freeman_at_csx.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Jun 24 2002 - 03:08:20 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ================================================================== De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. ===================================================================== The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. =================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: nlzanen1_at_EY.NL Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |