Re: Backup/Recovery Questions

Ok, I took a test db and did the following:

1 Alter database backup controlfile to trace 2 shut down normal
3 edit my init.ora to create new controlfiles, say A and B 4 startup nomount
5 read my alert file, it records where my init.ora thinks the new controlfiles should be, A and B (however they are not there because I have not created them yet)
6 edit my init.ora file and call my control file C and D, not A and B 7 in server manager, create controlfile..... from trace file - makes the control file where the init.ora say they should be 7 look at alert file and see the 'create controlfile ....' command, however the alert file does not indicate the controlfile is no longer A and B but now is C and D.

So the only place to go and see where the controlfiles were created is in the init.ora. Ok,ok I'm stretching things, and I know what your saying, however my long winded point is that the init.ora is really the best place to go to see where the control files were created and the alert file just reflects what the init.ora said during startup nomount. (I don't remember this question on the OCP, so it may be a mute point).

Mike

Alex Hudghton <alex_at_alenda.freeserve.co.uk> wrote in message news:7ootfn$e2r$1_at_taliesin.netcom.net.uk...
> Disagree. B is incorrect - The question states 'how many control files
were
> recreated?'
>
> ^^^^^^
>
> not 'how many control files should be recreated?'
> ^^^^^^^^^^
>
> Alex
>
>
> Mikel wrote in message ...
> >Hi Jill,
> >
> >B is correct. When you issue the order to create control file, whether
in
> a
> >new db creation or for recovery purposes, the init.ora governs where and
> how
> >many control files to create.
> >
> >You do not have to update the init.ora, the init.ora told Orcale where to
> >create the control files. The init.ora is never updated buy Oracle, just
> by
> >you.
> >
> >hth
> >
> >Mike
> >
> >
> >
> >Jill <jcman_at_worldnet.att.net> wrote in message
> >news:7onuho$ffv$1_at_bgtnsc02.worldnet.att.net...
> >> I downloaded the Oracle OCP assessment test for B/R, and I am having
> >trouble
> >> with a question, and I wanted to get some expert input.
> >>
> >> 1 You recreated the control file as part of a recovery operation.
Which
> >> file can you now view to see how many control files were recreated?
> >> A sys.log
> >> B init.ora
> >> C alert.log
> >> D config.ora
> >>
> >> I chose C, but they say B. I know I need to update the init.ora to
> >reflect
> >> any control file changes, but having Oracle do that for me
automatically
> >is
> >> is new to me. Unfortunately I can't model this scenario, so I decided
to
> >> ask this group.
> >>
> >>
> >>
> >>
> >
> >
>
>
Received on Tue Aug 10 1999 - 21:12:17 CDT