Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: couchman doubt

Re: couchman doubt

From: <bulbultyagi_at_now-india.net.in>
Date: Fri, 09 May 2003 12:59:20 -0800
Message-ID: <F001.00595D82.20030509125920@fatcity.com>


Yes I have 9.0.1.1.1 enterprise edition availible on win32 I tested the given query out and the checkpoint_change# column value from v$database matches the result of the query you gave You mean to say that couchman is asking me where to find the checkpoint number ?

Q. You want to find out the current sequence number stored in your control  file for backup purposes. Which two of the following views would you query?

 A*. V$DATABASE  B . V$CONTROLFILE  C . V$PARAMETER  D*. V$CONTROLFILE_RECORD_SECTION  My doubt : what sequence number is he asking for ? I can get the current  log sequence number from v$controlfile_record_section by :  select type , last_recid from v$controlfile_record_section where type =  'LOG HISTORY' ;
 There are other sequence numbers in v$database but why would I need the : CHECKPOINT_CHANGE# OR CONTROLFILE_SEQUENCE# for backup ( thats what the question asks ) . I cannot understand his answer of 'A' and 'D' both.

>
> Do you have a 9i database available?
>
> If not, you should create one.
>
> run this query as sys:
>
> select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe
>
> and then compare the results with what you find
> in each of the v$ views you mention below.
>
> HTH
>
> Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Fri May 09 2003 - 15:59:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US