Prev | Current Page 714 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"

The parameters you set will depend on the configuration
you choose.
If the primary and standby databases are on the same server, you will need to set a value for
the DB_UNIQUE_NAME parameter. Because the directory structures for the two databases will
be different, you must either manually rename files or define values for the DB_FILE_NAME_
CONVERT and LOG_FILE_NAME_CONVERT parameters in the standby database. You must
set up unique service names for the primary and standby databases via the SERVICE_NAMES
initialization parameter.
Attribute Description
MAX_FAILURE and
NOMAX_FAILURE
MAX_FAILURE specifies the maximum number of reopen attempts before the
primary database permanently gives up on the standby database.
NET_TIMEOUT and
NONET_TIMEOUT
NET_TIMEOUT specifies the number of seconds the log writer process on
the primary system waits for status from the network server process before
terminating the network connection. The default value is 180 seconds.
QUOTA_SIZE and
NOQUOTA_SIZE
QUOTA_SIZE indicates the maximum number of 512-byte blocks of physical
storage on a disk device that can be used by a local destination.
QUOTA_USED and
NOQUOTA_USED
QUOTA_USED identifies the number of 512-byte blocks of data that were
archived on a specified destination.
REGISTER and
NOREGISTER
REGISTER indicates that the location of the archived redo log file is to be
recorded at the corresponding destination.
REOPEN and
NOREOPEN
REOPEN specifies the minimum number of seconds (the default is 300 seconds)
before the archiver processes (ARCn) or the log writer process (LGWR) should
try again to access a previously failed destination.


Pages:
702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726
Gabloty na puchary hydrocortison maść mapic kalkulator walut zaklady bet365