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

Home -> Community -> Usenet -> c.d.o.server -> Re: parameter _log_block_during_backup

Re: parameter _log_block_during_backup

From: LARRY E RUENACHT <RUFEN_at_prodigy.net>
Date: 1998/03/05
Message-ID: <01bd47ed$80e73820$012273cf@default>#1/1

This parameter guarantees that in "hot" backup processing (when the alter tablespace begin command is issued) the entire block's image/data will be logged in the redos when a change occurs in that block.

You can retrieve its current value (definition/description and "default" value) by issuing the following select statement in ORACLE 7.3/7.4:

	 	select b.ksppimn, a.ksppstvl, a.ksppstdf, b.ksppidesc
                           from x$ksppi b, x$ksppcv a
                          where a.indx = b.indx;

In ORACLE 7.2 issue the following to obtain its current and default value

		select ksppinm, ksppivl, ksppidf
                           from x$ksppi;

To retrieve a listing of other interesting "X$" tables select * from v$fixed_table.

Hervé <hdoornbos_at_magic.fr> wrote in article <6d27bi$bp5$1_at_paris.magic.fr>...
> What is the meaning of the parameter _log_block_during_backup and how is
 it
> possible to retrieve its value ?
> Thanks
>
>
>
  Received on Thu Mar 05 1998 - 00:00:00 CST

Original text of this message

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