Softpedia >Windows >Internet >Servers >Database Utils >Dbvisit Standby >  Changelog

Dbvisit Standby Changelog

What's new in Dbvisit Standby 8.0.20

Mar 9, 2018
  • CHANGES:
  • DS-1169: Improved ordering of task history (date column not wrapping)
  • DS-1185: Fix alignment of configurations in Central Console (Configurations screen)
  • DS-1214: Internal update to skip a check if a file is open if no fuser found on the server when UNIX is used
  • DS-1220: Implement change to allow dbvctl Daemon process to re-establish shared database connection on failure
  • DS-1226: Dbvnet improvements including logging, internal bug fixes as well as performance improvements
  • DS-1228: Do not attempt to create a standby control file twice during Create Standby Database (CSD) when using ASM
  • DS-1229: Add additional information to database status check
  • DS-1230: Shut standby instance down during Graceful Switchover (GS) rollback, prior to removing old redo logs
  • DS-1235: Add additional handling of "An existing connection was forcibly closed" during remote checksum execution when result was returned
  • DS-1236: Improve dbvnet keep-alive frequency used for long running cosessions (connections)
  • DS-1237: Fix default dbvctl calling exit() when no logs to transfer found
  • DS-1243: Fix working directory in dbvsmgr which caused dbvserver service not to start, if only component installed (Windows Only)
  • DS-1255: Fix issue in dbvnet where copy of files greater than 2GB on Windows based systems created 0 size file on secondary
  • DS-1264: Improve checks of source database state when running default dbvctl taking into account CASCADE variable setting
  • DS-1265: Resolve possible agent being stated as down, while in fact it is running (Solaris)
  • DS-1270: Minor update on License key display details (DS-1271)
  • DS-1273: Improve detection of Clusterware vs Oracle Restart and the options used for SRVCTL when adding (registering) the standby database during Create Standby Database (CSD)
  • DS-1274: Internal improvement to better handle many agents (hosts) in Central Console - browser session my not load all components or disconnect (refresh)

New in Dbvisit Standby 8.0.18 (Feb 15, 2018)

  • DS-703: Internal updates to Dbvnet, Dbvagent and Dbvserver to cater for Solaris and AIX
  • DS-761: Added support for Solaris (SPARC, x86) and AIX.
  • IMPORTANT: As of 8.0.18 Dbvisit Standby can be installed and used on Solaris based systems (Solaris 10+) with the exception that the Central Console must be installed/running on a Linux or Windows based system. Dbvserver (Central Console) will not be able to install on Solaris and AIX based systems. Using Dbvnet on Solaris and AIX is experimental and if used, COMPARE_CHECKSUM=Y must be enabled in the DDC files. Using SSH on Solaris and AIX in 8.0.18 is recommended (SSH User Equivalence is required - passwordless authentication)
  • DS-791: Implement new update repository functions for dbvagent and dbvserver
  • DS-915: Improved error handling with new internal improved JSON library
  • DS-959: Extend the pre/post processing script to include Create Standby Database (CSD) post processing
  • DS-963: Adjust fields to consistent order across the Add and Edit host pages
  • DS-964: Internal change - deleting parameters from the Create Standby Database (CSD) page table should now correctly remove them from the Inits parameter group
  • DS-966: Create Configuration page is now correctly disabled if no Hosts are defined
  • DS-979: (DS-980) Drop-down lists in Safari browsers now displaying correct formatting
  • DS-984: Allow for the CASCADE variable to be editable via Central Console (GUI)
  • DS-983: Add check to prevent deletion of active Hosts in Central Console (GUI)
  • DS-989: Improved error handling when starting an already running daemon process (Central Console)
  • DS-1010: Adjust syntax of SRVCTL command for RAC One Node
  • DS-1015: Add new function to synchronize the primary and standby databases by transferring and applying logs as a final step of Create Standby Database (CSD) and Syncrhonize Standby Database (SYNC) opertions
  • DS-1028: Send one heartbeat email per dbvisit run rather than one per thread
  • DS-1029: (DS-1052) Import DDC into Cental Console now always display correct information
  • DS-1044: (DS-1047) Improve user add/remove in Cental Console with improved restrictions on removing logged in users
  • DS-1046: Incorrect password validation criteria fixed in Central Console
  • DS-1051: Disable resume button on using transportable media when starting second phase
  • DS-1054: Add an optional parameter to refresh datafile function. The new parameters is to specify temp locations on the local and remote systems for backup and transfer locations of the datafile backup
  • DS-1060: Update dbvisit software installation scripts to cater for upgrade from 8.0.16 to 8.0.18
  • DS-1091: Create DDC, CSD and Sync pages "Submit" buttons are now disabled after the initial click to prevent double-click
  • DS-1096: Use "which" command instead of "whereis" on Solaris to locate an executable
  • DS-1102: Adjust "ps" command flags to cater for Solaris
  • DS-1106: Set NOEDIT attribute in the Inits data structure if not defined by Central Console (GUI)
  • DS-1114: Dbvisit installation script should not allow to install Dbvserver on Solaris and AIX based systems
  • DS-1125: An attempt to apply license should be made only on successful creation of a DDC file
  • DS-1129: Do not terminate the installer when the user chooses to install Dbvserver on Solaris and AIX, just display warning. Note: Dbvserver (Central Console/GUI) is not allowed on Solaris or AIX and must be installed on Linux or Windows
  • DS-1133: Added support package generation to database action errors on the Manage Databases page (Central Console)
  • DS-1170: Update support pacakge - add dbvnet and dbvagent configurations (-g) to support package
  • DS-1174: Resolve issue where Daemon does not reset internal settings if a long running process is killed
  • DS-1175: Resolve issue where support package on Windows did not contain files from remote server
  • DS-1178: Fixed a bug causing the installer not to accept components to install/uninstall
  • DS-1179: Task "not receiving updates" error message timeout increased from 10 to 40 seconds
  • DS-1183: Some notifications are missing in screen output of Graceful Switchover (GS)
  • DS-1197: Internal change to fix incorrect syntax of SRVCTL command ADD INSTANCE missing -node flag
  • DS-1199: Backup existing dbvnet, dbvserver, dbvagent config files with timestamp - when re-installing or upgrading dbvisit
  • DS-1210: Resolve issue where creating new template during Create Standby Database (CSD) can cause standby instant to not be shutdown if only creating template
  • DS-1211: Central Console - update sorting order of tasks based on completion time
  • DS-1212: User session now only times out if there are no active Tasks, also Task History no longer auto-scrolls
  • DS-1216: Resolve issue where defunct processes can be created if database is shutdown when deamon is running
  • DS-1217: Internal updates to function sync_get_info

New in Dbvisit Standby 8.0.16 (Nov 9, 2017)

  • 1.DS-460: Allow Synchronize Standby Database (SYNC) option to be restartable and able to use transportable media
  • 2.DS-859: Remove temp files created on the standby server by Dbvisit processes spawned by daemon
  • 3.DS-874: Provide optional post processing option to compress archives under ARCHDEST
  • 4.DS-883: Correct a typo in Dbvisit standby components uninstaller
  • 5.DS-891: Use release major version number only following a switch to GIT
  • 6.DS-893: Fix log gap report showing wrong instance name for threads other than one
  • 7.DS-894: Avoid archive logs being deleted from ARCHDEST until transferred to Cascade Standby
  • 8.DS-895: Use SRVCTL rather than SQLPLUS to open a Clusterware registered standby read only
  • 9.DS-896: Restart newly activated database on a database rather than instance level
  • 10.DS-901: Make sure log gap report fails unless the standby is mounted or read only
  • 11.DS-905: Generate support package when DBVISIT_DEBUG is set to 0
  • 12.DS-909: Implicitly set database parameter instance_mode to READ-WRITE on the standby during CSD
  • 13.DS-910: Make sure APPLY_DELAY_LAG_MINUTES and DMN_MONITOR_INTERVAL_DR are not both set
  • 14.DS-913: Fix daemon resetting AMM_CHECK_TRANSFERRED to N
  • 15.DS-914: Improve mechanism of switching the standby to recovery mode when APPLY_READ_ONLY set to Y
  • 16.DS-916: Make sure pre- and -post- processing scripts are called even when the database instance is down
  • 17.DS-917: Make sure installer sets correct dbvserver name and does not keep the 0.0.0.0 placeholder
  • 18.DS-918: Correct syntax error when starting a database read only using SRVCTL
  • 19.DS-919: Add --force option to "-o upgrade", for testing purposes
  • 20.DS-921: Make db_file_name_convert and log_file_name_convert case insensitive
  • 21.DS-922: Make sure PDBs get started on the new primary on completion of GS
  • 22.DS-923: Small improvement when restarting a database
  • 23.DS-924: Transfer a list of primary datafiles to the standby during CSD, to be potentially used for post-processing
  • 24.DS-925: Improve conversion of datafile names during CSD when conversion is set between two ASM diskgroups
  • 25.DS-927: Improve parsing db_file_name_convert when one "from" string is a substring of another "from" string
  • 26.DS-928: Improve logging generated by running log gap report when RUN_INSPECT set to Y
  • 27.DS-930: Use file mtime rather than ctime when picking up the latest compressed or uncompressed log to apply
  • 28.DS-931: Add DDC string to generic support package name
  • 29.DS-932: Check if restore points are set in the old primary prior to GS
  • 30.DS-934: Re-transfer a file if checksums do not match during file transfer
  • 31.DS-935: Add missing globals to a list of globals available to the user when editing a DDC via GUI
  • 32.DS-939: Display warning during CSD prechecks if primary is in NOLOGGING
  • 33.DS-948: Issue with db_create_online_log_dest_n being ignored affecting CSD and GS
  • 34.DS-952: Improve handling foreign language strings when parsing output during recovery
  • 35.DS-954: Improve handling tempfiles extended beyond max size, which could cause error during Graceful Switchover
  • 36.DS-956: Improve algorithm of applying convert parameter to a filename in mixed ASM and Windows environment
  • 37.DS-957: Treat temp files that belong to SEED container as OMF during GS

New in Dbvisit Standby 8.0.14 (Nov 6, 2017)

  • DS-636: Allow for entering license key on completion of creating a new DDC
  • DS-727: Allow to use trace file name instead of process id (pid) when creating a Support Package
  • DS-760: Introduce "Blackout Window" functionality when scheduling Dbvisit via daemon process
  • DS-818: New functions to extract data from repository tables in text and json formats
  • DS-819: New option to schedule repository maintenance when running default send/apply of logs
  • DS-820: Improve algorithm of applying logs on the standby when both compressed and uncompressed copies present (DS-873)
  • DS-828: Copy repository to the standby server once changes have been made to it on the primary server
  • DS-829: Improve cleanup of trace files following default Dbvisit run
  • DS-851: Improve Create Standby Database (CSD) options in Central Console when using Oracle RAC configurations and templates
  • DS-853: Make sure database connections are kept open when using daemon
  • DS-856: Handle a scenario when parameter db_unique_name is not set in the primary spfile during CSD
  • DS-858: Remove misleading messages inserted in history log by daemon
  • DS-859: Make sure temp files created by Dbvisit processes spawned by daemon are removed on completion
  • DS-864: Central Console - when spfile is present and enforced during Create Standby Database (CSD), template option is disabled
  • DS-865: Provide a meaningful error message when an attempt to use -l (license) option on the standby server is made
  • DS-866: When applying logs using either SQLPLUS or RMAN, skip logs with names ending in ".part" as being in use
  • DS-867: Automatically reestablish RMAN connection opened by daemon if the database is restarted
  • DS-868: Update internal API call for activate sync and no-sync options
  • DS-869: Improved timestamp display in Central Console under Task History table - tooltip added with timezone of webserver
  • DS-871: When performing CSD and GS, check if daemon has not been stopped on both sides and terminate
  • DS-875: Improved handling of ASM Oracle Managed File (OMF) primary password file during Create Standby Database (CSD)
  • DS-882: Improvements to Graceful Switchover between primary RAC and single instance standby
  • DS-885: Fix upgrade of Dbvisit Standby Configuration file (DDC) - does not set CONFDIR_DR when called from Central Console

New in Dbvisit Standby 8.0.10 (Apr 10, 2017)

  • Changes:
  • DS-719: Add new sample Linux startup scripts to DBVISIT_BASE/standby/doc folder
  • DS-732: Internal change to address internal repository error "Error: file is encrypted or is not a database"
  • DS-733: Adjust order of creating new Redo Logs during Graceful Switchover (GS) to remove risk of Redo being left in a temporary location in case of an error during GS
  • DS-734: Improve upgrade script executed during "dbvctl -d DDC -o upgrade" including improved handling of ORACLE_SID_ASM and ORACLE_SID_ASM_DR and ensuring that ORACLE_SID and ORACLE_SID_DR is not set if Oracle RAC is used and Dbvisit Standby version is 8 and above
  • DS-735: Resolve incorrect reporting of dbvctl Daemon/Backround process status as well as improved handling of PID files
  • DS-736: Add changes to allow Oracle RAC configurations where Dbvisit Standby is not using shared storage. For more detail see the Online Documentation (Advanced - Oracle RAC Configurations - https://goo.gl/ydzVkJ)
  • DS-738: Internal change - skip tracing a directory listing of a missing archive log if the log is ASM
  • DS-741: Improved handling of single tenant database - PDB state when running "dbvctl -d DDC -o restart" on standby server
  • DS-744: Error being reported when using delay lag - Cannot open file: Media recovery complete (No such file or directory) - fixed

New in Dbvisit Standby 7.0.58 (Jun 16, 2016)

  • Internal change to improve Graceful Switchover (GS) and handling of v$log_history having records for one thread when multiple threads are in use or even if v$log_history is empty.
  • Improve setup process when asking for repository user password.
  • Adjust default value for MAX_TIMES_TRIED from 4 to 3.
  • Implement change to resolve _SEND_MAIL_FLAG being incorrectly set to be set during Create Standby Database (CSD) or Synchronize Standby Database (SYNC).
  • Add additional check when detecting "NIOP: read_response: failed" to retry the operation.
  • Internal update on query to use v$asm_diskroup_stat .0.56 (19 May 2016).
  • Fixes & Improvements:
  • Fix issue where Log Gap Report returns wrong recovery SCN for the standby database when standby database is open read-only.
  • Fix issue where incorrect number of archive logs are removed by the Archivelog Managment Module (AMM) when the FRA_THRESHOLD_ARCHSOURCE
  • value is met.

New in Dbvisit Standby 7.0.56 (Jun 16, 2016)

  • Fix issue where Log Gap Report returns wrong recovery SCN for the standby database when standby database is open read-only
  • Fix issue where incorrect number of archive logs are removed by the Archivelog Managment Module (AMM) when the RA_THRESHOLD_ARCHSOURCE value is met

New in Dbvisit Standby 7.0.54 (Jun 16, 2016)

  • Improve messages to standby history log file as well as handling of partial uncompressed archive logs on the standby server when using compression. When a corrupted archive log is uncompressed, Dbvisit Standby will generate and error (unexpected end of file - return code 2022) and leave behind bothcompressed and uncompressed files. On the Next run Dbvisit Standby will always pick the uncompressed archive log - if it exists. As this file is not complete an error will be thrown during recovery. In this update we detect the error 2022 the uncompressed of a corrupt log and will delete uncompressed file. This way if the log is resend to the standby, Dbvisit will pick the new compressed file to apply. Set _IGNORE_2022=Y to activate this change in the DDC file. When setting this value it is also recommended to set COMPARE_CHECKSUM=Y in the DDC file. If both compressed and uncompressed logs are present on the standby server, Dbvisit Standby will still favour the uncompressed archived log.
  • Minor internal change on operating system user check when running the installer on Unix based systems.

New in Dbvisit Standby 7.0.52 (Jun 16, 2016)

  • Change threshold reached message in Archive Log Management Module (AMM).
  • Introduce a new variable CLEAR_ARCHDEST_POST_GS to remove files from.
  • the Dbvisit Standby ARCHDEST on completion of Graceful Switchover (GS). It is disabled by default and can be enabled with a value of Y or YES in the DDC file.
  • Reset db_file_name_convert and log_file_name_convert parameters in new standby database following completion of Graceful Switchover (GS).
  • Do not validate db_create_online_log_dest_n during the Create Standby Database (CSD) process when using a template.
  • Update internal query to select the database parameters (spfile parameters) for the new standby during the Create Standby Database (CSD) process
  • Internal improvement of the Dbvisit Standby repository maintenance function repo_maintain(). Function can be called with ./dbv_functions -a repo_maintain where is days to keep records for, example "./dbv_functions -a prod repo_maintain 7".
  • Keep zero or null non-default values when customizing standby database parameters (spfile) during Create Standby Database (CSD).
  • Skip UNDO_TABLESPACE check during Graceful Switchover (GS) if it is not set in the old standby database spfile.

New in Dbvisit Standby 7.0.40 (Jun 15, 2016)

  • Fixes & Improvements:
  • Allow for the option to perform minimal customization of the archive log format on the standby database. This is the format Dbvisit
  • Standby will be using on the standby server inside the ARCHDEST location. Default format is "__.arc" which is %t_%s_%r.arc. If required the new parameter STANDBY_ARCHIVELOG_NAME can be set in the DDC. Example if you want to set the format so that the
  • database name PROD is in the archive log format name, you can set the following in the DDC file where you append the database name as part of the format: STANDBY_ARCHIVELOG_NAME=PROD_%t_%s_%r.arc. For Oracle 10g and above %t, %s and %r must be set, and if Oracle 9i is used
  • %t and %s must be set.
  • Internal - Fix problem where database state 52 was not reported correct.
  • Add additional check to review if any datafiles are in an offline or recover state before starting the Graceful Switchover (GS) process. Ensure pre GS checks are performed for the UNDO tablespace on NON-RAC database environments only.
  • Improve the shutdown of the primary database during Graceful Switchover (GS) when using Oracle RAC environments and the srvctl command.
  • Fix issue with the Dbvserver schedular where remote schedules could not be set.
  • Improve usage of db_file_name_convert and log_file_name_convert.
  • Improve logging and error handling when starting a standby database during CSD.
  • Improve recording of archives in RMAN catalog when running the recovery process on the standby database using RMAN.

New in Dbvisit Standby 7.0.38 (Apr 17, 2015)

  • Fixes & Improvements:
  • DS-203: Shutdown standby database when removing tempfiles from ASM or Windows based systems
  • DS-262: Remove unused global CSD_PREFLIGHT_CHECK
  • DS-251: Remove a trailing slash from a location for standby datafiles when running Create Standby Database (CSD) via web frontend (GUI)
  • DS-253: Pad tempfile counter with a leading zero in tempfile names when renaming standby tempfiles after recreating a standby control file
  • DS-254: Add new function repo_maintain to maintain the Dbvisit Standby repository tables (dbv_transfer_log and dbv_sequence_log). This allows for the purgingof data from these tables based on days. Command that can be used is ./dbv_functions -a repo_maintain Example - to purge data older than 15 days be removed with: ./dbv_functions -a PROD repo_maintain 15
  • DS-261: Add test_nfs() function and _SLEEP_IN_SEC global to address issues with NFS
  • DS-257: Extend Graceful Switchover (GS) pre-checks on standby to check for existance of DUMP and AUDIT locations as well as DIAGNOSTIC location
  • DS-257: Extend Graceful Switchover (GS) prechecks on primary to check if UNDO_TABLESPACE in standby and primary spfiles match
  • DS-256: Introduce xcopy commands on windows to copy archive logs to a remote share. This option is for archive log transfer only.
  • DS-259: Fix issue related to Oracle version 9 - archive logs generated during Graceful Switchover (GS) do not get cataloged in RMAN catalog
  • DS-86: Check standby database incarnation prior to applying logs
  • DS-109: Check if FORCE LOGGING enabled on the primary each time Dbvisit runs to transfer logs
  • DS-135: Log to trace size and creation timestamp of archive logs when applying them to standby, for support purposes (UNIX only)
  • DS-258: Add new dbv_functions to obtain information about the latest transferred from the repository
  • DS-264: Implement security fix in web based frontend - Dbvserver

New in Dbvisit Standby 7.0.36 (Mar 4, 2015)

  • Fixes & Improvements:
  • Implement fix relating to the Archive Log Management (AMM) module and the purging of archive logs based on time (UTC/EPOCH) - (DS-223)
  • Implement check to not remove temp files on standby database during Graceful Switchover (GS) when name include "%" characters (DS-225)
  • Improve reverse Create Standby Database (CSD) templates (DS-226)
  • CSD left a reference to a primary ASM ALIAS tempfile unchanged in the standby cotrol file when creating a filesystem standby - fixed (DS-233)
  • GS failed on RAC when log_archive_dest set to a shared filesystem location, instead of ASM - fixed (DS-234)
  • Implement change to create Redo logs as Non Oracle Managed Files (OMF) on the standby database if db_recovery_file_dest is set in the standby database parameter file, but db_create_file_dest and db_create_online_log_dest_n parameters are not set - (DS-235)

New in Dbvisit Standby 7.0.34 (Jan 30, 2015)

  • Fixes & Improvements:
  • Improve Dbvnet Performance. Implement change regarding the Dbvnet data packet size
  • Improve drop/removal process of tempfiles on the standby database when recreating the standby controlfile. Remove parameter DROP_STANDBY_TEMPFILES as this is no longer used
  • Add additional information to the history log file with regards to archive and transfer log gap alerts
  • Improve the removal of standby redo logs during the recreation process of the standby database controlfile
  • Fix issue with batch mode repository creation using dbvisit_setup --ddr Error reported "Cannot find Dbvisit Database configuration (DDC) file"
  • Display Create Standby Database (CSD) template errors when running in batch mode (when template is invalid)

New in Dbvisit Standby 7.0.32 (Dec 23, 2014)

  • New Features & Enhancements:
  • Add three addional columns to internal DBV_SEQUENCE_LOG table storing primary and standby SCN numbers with archive log gap time difference. These columns are populated when RUN_INSPECT=Y is set which runs a silent log gap report, or whenever a log gap report is run
  • Important: The Dbvisit Repository must be upgraded. This can be done using "dbvisit_setup"->menu option 5 if using the CLI, or if using the Web Based interface use Setup->Option 2 (Update Dbvisit) and then selecting Option 2 (Manage Dbvisit Repository)
  • Improve queries used to lookup files when ASM storage is used (RQ-183)
  • Fixes:
  • Fix issue were non oracle managed file (OMF) tempfiles cause errors on standby database (ORA-01110, ORA-01187). Standby database tempfiles are removed following Graceful Switchover (GS) - when non-OMF tempfiles are used. The tempfile reference will still be in controlfile and the tempfile will be created when the database is either opened Read/Only or if the database is Activated (DS-193)
  • Implement internal fix with regards to redo log file management on the standby database (Redo log files on the standby database are removed post Graceful Switchover)
  • Internal improvement with regards Graceful Switchover - when reading and validating a DDC file, ignore RAC_TAKEOVER_SID value if RAC_TAKEOVER set to N

New in Dbvisit Standby 7.0.30 (Dec 12, 2014)

  • Fixes:
  • Implement fix to resolve possible failure of Graceful Switchover. This is related to incorrect handing of temp files on the standby database
  • Adjust the default values for SEND_MAIL_FLAG and SEND_MAIL_FLAG_DR to N (No). This will ensure email is disable by default. To enable email notifications these parameter values should be updated to "Y" (Yes). For more detail on email configuration please see the online user guide for detail listing of parameters
  • Add DROP_STANDBY_TEMPFILES=N parameter to the DDC file template. This parameter should be set to Y if the database version is less than 11.2.0.3. This is to cater for a known Oracle bug 10292173 which can cause Graceful Switchover to fail
  • Improve the creation of the SPFILE during the Create Standby Database (CSD) process if Oracle ASM is used. This is to ensure the spfile is located under the "/DB_UNIQUE_NAME" and not under "

New in Dbvisit Standby 7.0.28 (Dec 3, 2014)

  • New Features and Enhancements:
  • Add support for RAW devices to be used as Database datafile storage. This option is available on Linux based systems only and does support Create Standby Database (CSD) and Graceful Switchover (GS).
  • It is important to note that the RAW devices on the standby MUST match the raw devices used on the primary:
  • Example if the system datafile is on /dev/raw/raw1 the standby server will also be using /dev/raw/raw1 for the system datafile. The creation of the RAW devices must be done manually by the System/Database administrator as this will require root permission and it out of scope for Dbvisit Standby to automate this.
  • The same Oracle Database software version, edition and software owner must also be used on both primary and standby database servers.
  • Fixes:
  • Improve temp file handling during Graceful Switchover

New in Dbvisit Standby 7.0.26 (Nov 11, 2014)

  • Fixes:
  • Fix issue where the temporary tablespace tempfile is not added to the primary database following graceful switchover
  • Call post-processing and AMM module only after all threads have been processed

New in Dbvisit Standby 7.0.24 (Nov 10, 2014)

  • New Features & Enhancements:
  • Create Oracle Managed Files (OMF) redo logs in the new primary database on completion of Graceful Switchover, if creation of OMF redo is enabled.
  • This functionality is controlled by the introduction of a new configuration variable GS_FORCE_OMF_REDO with default value "N" (NO) set this parameter to "Y" (Yes) in the DDC file to enable this functionality.
  • Fixes:
  • Improve handling of temp files during Graceful Switchover when tempfile autoextend is on with unlimited specified as maximum size
  • On Standby server, if two archive logs are found in the Dbvisit Standby ARCHDEST - one being compressed the other uncompressed, the uncompressed log will first be used for recovery
  • Add additional checks to confirm if an ASM instance is runnning
  • Allow log gap report (dbvisit -i) to be executed while a dbvisit command is already running - sending or applying logs

New in Dbvisit Standby 7.0.22 (Sep 9, 2014)

  • Fixes:
  • Fix a Create Standby Database (CSD) issue with creating a filesystem based standby database datafile when a primary datafile is and ASM alias
  • Implement improvement in recovery process to cater for additional language support

New in Dbvisit Standby 7.0.20 (Aug 25, 2014)

  • Fixes:
  • Fix Dbvserver reporting tabs where graphs are not populated on all RAC nodes.
  • Fix daily redo generation graph calculation

New in Dbvisit Standby 7.0.18 (Jul 9, 2014)

  • Fixes:
  • Implement addtional change to cater for different languages such as french where special characters in the word "sequence" are converted to incorrect characters
  • Fix issue where error messages in certain conditions with newlines can be wrongly interpreted as commands by dbvnet instead of output messages
  • Minor change implemented to remove additional logging not needed

New in Dbvisit Standby 7.0.16 (Jun 20, 2014)

  • Fixes:
  • Add change to cater for specific French language output during standby recovery
  • Add option to compare at least file size in certain scenarios when COMPARE_CHECKSUM is set to N
  • Implement fix for when "dbvisit -r " is used without thread number being specified
  • Add additional logging to Dbvnet regarding .part files not being renamed in certain conditions
  • Implement a fix in Dbvnet to resolve issue where the following error is reported "File size for file X is not an integer"
  • Default Dbvnet encryption set to 128bit for new installations.
  • Possible options in DDC file can be DBVNET_ENCRYPT=Y|N|128|256 where Y is the same as 128.
  • On Windows installations temp files in $DBVISIT_BASE/standby/tmp are not cleaned up resulting in a large amount of temp files being left behind that can cause delays during operations such as Graceful Switchover (GS) - this has been fixed in this update and Windows based installations should update to this release.

New in Dbvisit Standby 7.0.14 (May 6, 2014)

  • New Features & Enhancements:
  • Implement an improvement in Dbvnet handling of certain network errors including adding additional informaiton to trace file
  • Fixes:
  • Fix issue where SEND_HEARTBEAT function was disabled
  • Fix minor internal issue in Dbvnet on possible exit on startup
  • Update README installation instructions where wrong directory was referenced
  • Fix issue with Dbvisit Standby repository upgrade (step 6.2) where repository upgrade my fail with ORA-01418
  • Improve the way latest sequence information is extracted from v$archived_log

New in Dbvisit Standby 7.0.12 (Apr 25, 2014)

  • Fixes:
  • Fix issue with creation of DDC file using the GUI (Dbvserver) where ARCH_BUSY and ARCH_NOT_THERE with wrong values. These parameters is not required to be set in the DDC file as the default values assigned to them is sufficient for most environments
  • Fix issue with reporting graphs where they are not always displaying in the GUI (Dbvserver) under the Reporting page
  • Implement various security fixes

New in Dbvisit Standby 7.0.10 (Apr 1, 2014)

  • New Features & Enhancements:
  • Various internal improvements (improved performance)
  • Dbvisit Standby now support SSL/TLS Email (SMTP) server connectivity
  • MAILCFG_PROTOCOL parameter is set in the Dbvisit Standby Configuration
  • (DDC) file with possible values null,SSL,TLS. Example, if gmail is used, specify MAILCFG_PROTOCOL=SSL also update the following required variables: MAILCFG_SMTP_SERVER, MAILCFG_PORT, MAILCFG_AUTH_USER and
  • MAILCFG_AUTH_PASSWD. For more details see the online documentation
  • Improved handling of commas - "," when "events" or "nls_numeric_characters" are specified in the spfile. New advanced variable _INIT_ORA_ESCAPE_COMMA lists parameters that require special handling
  • Improved handling of additional attributes in log_archive_destination_N parameters values
  • Improved handling of adding datafiles to standby database when ASM is used by creating OMF datafiles only
  • Improved Create Standby Database (CSD) process and the use of db_file_name_convert when both Primary and Standby is making use of ASM, but standby is using different disk groups
  • Update default value of DAYS_TO_KEEP_TRACE to 4 days
  • Update default value of COMPARE_CHECKSUM to No
  • Fixes:
  • Email error messages did not display values for MAILCFG_SMTP_SERVER and MAILCFG_SMTP_PORT
  • Fix minor issue with Dbvserver Scheduler
  • Fix minor issue with dbvnet-test tool when using Windows based environments. When running the full (-f) test, the user can specify the temp location to use
  • Fix issue that can occur in Graceful Switchover (GS) affecting subsequent transfer of archives.
  • Standby OMF redo logs should be created in FRA only if none of parameters db_create_online_log_dest_N or db_create_file_dest set
  • Fix possible issue with compress/uncompress of archive logs following a Graceful Switchover (GS)
  • Fix a bug triggered when ssh was used instead of Dbvnet and parameter SSH_SKIP_OUTPUT_LINES was set
  • Fix issue when Dbvisit attempted to apply a partly transferred archive with a name ending in "part"

New in Dbvisit Standby 7.0.08 (Mar 10, 2014)

  • New Features & Enhancements:
  • Various internal improvements including update to function reviewing foreign files in the FRA before CSD is performed
  • Fixes:
  • Fix possible issue on Windows enviornments where DBVIST_BASE location was not set when attempting creation of DDC file, causing false messages stating the primary database is down
  • Fix issue where errors are reported for Win32::Process::List

New in Dbvisit Standby 7.0.06 (Mar 10, 2014)

  • New Features & Enhancements:
  • Improve "dbvisit -r" command when resending archive logs from specific sequence to standby server. New format is now: "dbvisit -r [] "
  • Fixes:
  • Fix issue that can cause email notification failure
  • Add additional checks to resolve warning messages being displayed if the UNIX cron schedule is used
  • Improve internal Dbvisit Standby Repository (DDR) cleanup procedure on the DBV_TRANSFER_LOG table when Multiple Threads (RAC) are used

New in Dbvisit Standby 7.0.04 (Mar 10, 2014)

  • New Features & Enhancements:
  • The new Dbvnet (Dbvisit Network Layer) is now default communication layer between primary and standby servers.
  • Core features of Dbvnet:
  • Secure network communcation
  • Compression of network traffic between primary and standby
  • Independence of SSH-based client/server network communication
  • Enhanced web-based user interface (Dbvserver)
  • New Dashboard option included in Dbvserver (Linux only)
  • Additional features in Dbvserver for configuring Dbvserver and Dbvnet
  • Improved "Run Interactive" screen
  • Improved "Create Standby Database" (CSD) output
  • Additional CSD pre-flight checks to review for foreign files in FRA
  • Improved CSD for better handling of nls_numeric_characters=.,
  • New and improved internal functions (cmn_find_file_glob_r)
  • Additional steps implemented to check if recovery_scn returned from standby is integer
  • New module implemented to handle new license keys
  • New improved system readiness check
  • Implementation of new Archivelog Management Module (AMM) check to ensure log have been applied to standby, before being enabled as candidates for deletion - AMM_CHECK_APPLIED function introduced
  • Archivelog Management Module (AMM) on source will now remove compressed logs from filesystem
  • New Improved Pre- and Post Processing Scripts. Pre and Post Processing scripts can now be executed following a Standby Activation or as part of a Graceful Switchover (GS). Samples in $DBVISIT_BASE/standby/doc directory.
  • Implement new improved internal compression module when compression is set in the DDC file (COMPRESS=dbvisit, UNCOMPRESS=dbvisit)
  • Improved Graceful Switchover (GS) when using Oracle RAC environments, specific to where there are closed or inactive threads.

New in Dbvisit Standby 6.0.56 (Feb 5, 2014)

  • Update Graceful Switchover internal checks when primary is ASM and
  • the standby database is not making use of ASM
  • Update internal checks where Oracle Managed Files (OMF) is used,
  • taking into account OMF files in uppercase on Windows platforms
  • Minor fix implemented in Web Based interface when running commands
  • against a database not currently running.
  • Improve backup function, detecting if existing datafiles are in
  • already in backup mode.
  • Improve adding of OMF datafiles to standby database when
  • db_file_name_convert parameter is set

New in Dbvisit Standby 6.0.54 (Jan 8, 2014)

  • Implement change to cater for Windows OracleASMService+ASM service
  • Added new variables ARCHIVED_WAIT_RETRY_SEC and ARCHIVED_WAIT_MAX_SEC to address a delay with an archived log to appear in v$archived_log
  • Fix minor issue with Dbvserver (GUI) closed socket handling
  • Minor improvment when last archived sequence cannot be obtained

New in Dbvisit Standby 6.0.52 (Sep 18, 2013)

  • Allow primary database to be in restricted mode when Graceful Switchover is started
  • Improvements to internal function ora_recovery_scn to check for missing datafiles
  • Disable disk space check for Archivelog Management Module (AMM) when THRESHOLD_ARCHSOURCE=0 or THRESHOLD_ARCHDEST=0
  • Implement fix to resolve "Can't locate object method" error when the dbvisit standby shared connection is used
  • Various improvements when Dbvisit Standby shared connections are used. During normal send operation two sessions will be noticed, one for sysdba connections and one for normal connections

New in Dbvisit Standby 6.0.50 (Jul 23, 2013)

  • Fixed file and directory browser in GUI (Dbvserver) (Setup => New)
  • Extended logging and wait interval when Windows Oracle Database service cannot be obtained
  • Update licence agreement text and Windows Installer Signed Certificate
  • Improve add datafile function when datafiles are added to the SYSTEM tablespace
  • Delay lag will be ingored when running the Synchronize Standby database option. Added aditional warning message to be displayed in command line interface if this option is executed with the delay lag set
  • Added an additional check to review if the standby is behind current time prior to running a recovery session if delay lag is specified
  • Improve compression mechanism when "dbvisit" and "gzip" compression is used for archive log management and transfer between primary and standby databases. These new improvements will also avoid potential issues when compression is used with multiple standby databases as well as ensuring archive log compression does not impact potential RMAN backups running at the same time. As of version 6.0.50 it is recommended to set the following value in the Dbvisit Database Configuration (DDC) file: "KEEP_ORIG_FILE_BEFORE_COMPRESS=Y".
  • For new installations the default value for this parameter will be "Y".
  • This new change will also provide a minor performance improvement.
  • Add aditional step to truncate the dbv_register table on a new standby on completion of a Graceful Switchover (GS) otherwise the Archive log Management Module (AMM) might produce wrong results
  • Improve functionality to maintain Oracle Windows Service and detect a non-existing service

New in Dbvisit Standby 6.0.48 (May 16, 2013)

  • New Features:
  • Added WalkMe switch to Dbvserver (used only for demonstration)
  • Fixes:
  • Fixed temp file paths for SQL statement result output in Dbvserver
  • Improve the use of RESETLOGS_ID to identify archive log files
  • Recreate Primary Key index on dbv_transfer_log table to include LOG_ID
  • Update Dbvisit repository to make use of intermidiate version (release) numbers when doing multi-step upgrade of software. This release will require and update to the Dbvisit Repository when upgrading
  • Added an additional step to check if sqlplus executable has zero size. This check is also performed for sqlplus in the ASM instance software home
  • Internal impprovements on function cmn_exec_sql (added error file)
  • Improve the handling of standby database recovery if a apply lag is set using APPLY_DELAY_LAG_MINUTES. Especially when Oracle does not request any new logs to apply during the recovery process
  • Improve the process for adding new datafiles to the standby. Take into account the ORA-01274 error to obtain a primary name
  • Added an additional check for SQL*Plus and RMAN to Dbvserver setup-new
  • Add new global option "ADD_DATAFILE_FORCE_OMF" to force creating a new Oracle Managed File (OMF) file on the standby, when a new file was added to the primary and the primary file name could not be obtained

New in Dbvisit Standby 6.0.46 (Apr 19, 2013)

  • Fix small issue when using rsh instead of ssh
  • Do not set "until time" clause for recover command if lag not set
  • Update Archive log Management Module (AMM to only selectlogs with
  • current resetlogs_change# for deletion
  • Do not use AS BACKUPSET as part of the RMAN backup command for Oracle
  • versions less than 10g
  • Allow "dbv_oraStartStop status" to run when another Dbvisit
  • executable runs
  • Update internal tracing to allow more detailed Oracle session tracing
  • Update Create Standby Database (CSD transportable media option to
  • allow both filesystem or ASM storage to be used
  • Fixed potential issue in certain scenarios with SCN date formatting.
  • Update format from using RR to using 4 digit year format - YYYY
  • Fixed wrong exit code returned when a file transfer failed

New in Dbvisit Standby 6.0.44 (Feb 26, 2013)

  • New features:
  • Allow backing up primary datafiles AS COPY when creating a standby
  • database. This can be done by setting the following parameter
  • in the DDC file - RMAN_DBF_BACKUP_TYPE="AS COPY"
  • Introduce SSH_SKIP_OUTPUT_LINES to the DDC file, by setting this
  • parameter to a number value, that number of lines will be ignored
  • during ssh connections. Example if your ssh banner is 5 lines, you
  • can specify SSH_SKIP_OUTPUT_LINES=5 and the first 5 lines of ssh
  • output (which will include the banner) will be skipped.
  • Fixes:
  • During CSD, the standby controlfile and pfile was deleted before
  • being transferred to standby when the direct copy option was
  • selected and a CSD process was restarted - fixed
  • Internal repository table DBV_TRANSFER_LOG index extended to include
  • ORACLE_SID_DEST this is to improve handling of multiple
  • standby databases - A Repository upgrade should be performed with
  • this release. Internal repository version is now 6.2
  • Dbvisit calculated checksums multiple times in certain scenarios.
  • This is now fixed to only calculate it once
  • Update internal procedure ora_nologging_info() to format the return
  • value of FIRST_NONOLOGGED_SCN in a non exponential format (E+)
  • Internal update to function cmn_get_last_sequence() and add
  • resetlogs_change# clause to a query
  • Improved STDERR output redirection when executing SQL
  • Added extended logging to trace files for add_datafiles on primary
  • Extended logging when the last archived seq cannont be obtained
  • on primary
  • Fix possible issue with port number for rsh and rcp in specific scenarios
  • For RAC environments, improve the procedure doing the log extract
  • from ASM, create oracle directories with names unique to ORACLE_SID
  • Use DBV_ORACLE_SID in instance clause when archive current log
  • Fixed issue with archives being created during the GS process in
  • default archive destinations when FRA is disabled causing possible
  • GS failure.
  • In RAC environments, the processing of multiple threads for GS improved

New in Dbvisit Standby 6.0.42 (Dec 4, 2012)

  • New features:
  • During Activation of a standby database a new "nosynch" option can be passed to the activation process which will set the _COPY_TO_REMOTE and SYNCH_DBVISIT_INSTALL to "No" in the newly Activated database DDC File. This will ensure that even if a schedule is running, the newly Activated database's DDC file will not be coppied back to the original primary server. This is useful to ensure the original primary DDC file stays in tact if the Activition is done while the original primary is still available.
  • Allow the configuration (setup) of Dbvisit Standby to continue if the software owner account does not exist on the local system. This option is to allow for the use of LDAP or other external user management and authentication.
  • Fixes:
  • During Graceful Switchover, improve process that determine if database is ASM by analyzing control and data files.
  • Improve Archive log management module (AMM) to sort archive list by epoch, thread and sequence, not just epoch.
  • During the process of obtaining the next required SCN for recovery, only check for missing/corrupted datafiles if SCN cannot be obtained.
  • Fix small issue with Dbvisit repository upgrade from version 53 to 54.
  • Improve RMAN integration and use RMAN_DEVICE_SPECIFIER when deleting backup tag during Create Standby and Synchronize Standby when devices of type SBT or SBT_TAPE are used in the environment.
  • Fix small issue when removing standby tempfiles if DROP_STANDBY_TEMPFILES is set to "Y", this only affects Oracle versions 11.2 and above.
  • Fix issue with catalogging backup with RMAN when transportable media is used during the Create Standby Database (CSD).
  • Improve Graceful Switchover (GS) by using RMAN in RAC environments when the primary database is recovered during the GS process.
  • Preserve TZ environment variable to resolve time display in GUI. This change is specific to AIX.
  • Minor improvents to the GUI scheduler logging.

New in Dbvisit Standby 6.0.40 (Oct 10, 2012)

  • Ensure checksum is disabled in both primary and standby if COMPARE_CHECKSUM is set to N.
  • Improved SQL function used for searching files in ASM storage.
  • Improved error handling when directory cannot be created.
  • Improved recovery commands during Graceful Switchover when using 11g and above databases (disabled parallel recovery).
  • Improved code around the use of APPLY_READ_ONLY. If set to Y (yes) the database will return to recovery mode if it was opened read only. Default value is N (no).

New in Dbvisit Standby 6.0.38 (Oct 8, 2012)

  • Fixes:
  • Removed blank spaces from HOSTNAME_CMD return value.
  • Improved process for retrieving recovery SCN without running a recovery
  • session on standby. This new method will ensure that the log gap report
  • does not interfere with the apply process on the standby. To switch to
  • old functionality set FORCE_RECOVERY_SESSION = Y (default N).
  • Datafiles can now be added to the standby database without recreating
  • of the standby ctl file. To switch to old functionality set
  • FORCE_RECREATE_STANDBY_CTL = Y (default N).
  • Search for files in ASM is now limited by folder
  • under each disk group by default. To lift the limitation set
  • LIMIT_ASM_SEARCH = N (default Y).
  • Added new improved function for displaying database alert log
  • in the GUI.

New in Dbvisit Standby 6.0.36 (Oct 8, 2012)

  • New features:
  • The "Synchcronize Standby Database" option is now part of the GUI. This
  • new option can be found under the Setup menu option.
  • Improved "dbv_functions -s " can now run on both primary and standby
  • to obtain current SCN and next sequence.
  • Extended functionality of obtaining timestamp for SCN for improved
  • reporting capability, such as the log gap report "dbvisit -i "
  • Archive Log Management Module (AMMimproved to delete archive logs
  • in batches.
  • RESYNC_SEQ_OFFSET global parameter is redundant from this release
  • and was removed.
  • Additional Standby Synchronization reporting option added in GUI.
  • Fixes:
  • Small issue fixed when Log transfer fails on primary if a compressed log
  • was found instead of uncompressed one.
  • Archive log Management Module (AMMon the primary database should check
  • disk threshold only if DAYS_TO_KEEP_ARCHSOURCE, NUM_ARCHSOURCE_TO_KEEP
  • and BACKUP_COUNT are all set to 0.
  • Archive log Management Module (AMMon primary now deletes archive logs
  • regardless of their resetlogs_id.
  • Check Dbvisit Standby repository version prior to running the
  • "Synchronize Standby Database".
  • GUI: if standby database creation or synchronisation is currently running,
  • then the output of that process will be displayed. The usual controls are
  • only displayed if there is no active CSD/SYNC process present already.
  • The system_readiness function was improved to pick up correct Dbvisit
  • installation directory.

New in Dbvisit Standby 6.0.34 (Oct 8, 2012)

  • New features:
  • New "Synchronize Standby Database" Option (Recover or Update Standby
  • Database using Incremental RMAN Backups). This new feature is only
  • available from the Command Line (CLIusing option 8 under
  • "dbvisit_setup". The GUI version will be available in the next release.
  • Online refresh of one Datafile on the standby database from the primary
  • using one of the dbv_functions new advance features opions.
  • Adding improved RMAN integration and catering for default configuration.
  • Clients can modify the default rman configuration without affecting
  • Dbvisit Standby functionality.
  • Extend the create directory option in Create Standby Database (CSD
  • to include ASM directory structures.
  • Improved support for Amazon Web Services (AWS).
  • Add new "Advanced Functions" section when using dbv_functions.
  • Pass full executable path as a parameter to the HOSTNAME_CMD script.
  • Fixes:
  • Fixed memory leak in Dbvserver scheduler.
  • Fixed Dbvserver use of HOSTNAME_CMD variable when using the
  • "run interactive" option.
  • Fixed issue with Archive Management Module (AMMwhen using Oracle 9i.
  • Fixed minor issue with restore of controlfiles when using Oracle 8.
  • Adjust INSTANCE_CLAUSE_FOR_ARCHIVE_LOG_CURRENT to default value of "Y".
  • Improved Create Standby Database (CSDprerequisite checks to ensure
  • none of the primary database files requires recovery.
  • Fixed minor issue when using password file (database authentication
  • is used).
  • Improved handling of default archive log destinations.
  • Improved internal handling of adding and removing of datafiles.
  • Allow for ZIP_EXTENSION not to include a leading dot (both "gz"
  • and ".gz" valid now).
  • Prevented the root user from starting the dbvserver daemon.
  • Corrected the primary/standby node detection on the Logging page
  • Optimised multi-level directory creation.
  • Enhanced general logging.

New in Dbvisit Standby 6.0.32 (Oct 8, 2012)

  • Fixes:
  • Improve algorithm for generating standby database filenames when
  • db_file_name_convert or log_file_name_convert is used.
  • Fix issue with rman connection when using password authentication.
  • Move copy of password file forward in the Create Standby Database (CSD)
  • process to deal with password authentication.
  • Fix issue that can cause possible ssl errors with Dbvserver upgrade
  • on non Linux and Windows platforms.
  • Implement minor internal improvements.

New in Dbvisit Standby 6.0.30 (Oct 8, 2012)

  • New features:
  • Skip unexpected SSH output up to the string specified by SSH_SKIP_OUTPUT.
  • Created index on DBV_TRANSFER_LOG for performance.
  • Added support for management of archive log files in ASM.
  • Improved management of archive log files when using multiple standby
  • standby databases.
  • Improved feedback for entering Oracle password.
  • Improved new database setup through Web interface.
  • Singled out database selection on Setup > New page.
  • New option to edit the SSH port number on Setup > New page.
  • Cosmetic web interface updates (smaller font size, new header layout).
  • New menu item "About" added to Dbvserver main menu.
  • Improved Create Standby Database (CSDprerequisite checks.
  • Fixes:
  • Exclude READONLY tablespaces in hot back up mode during creation of
  • standby database using direct copy.
  • Improved Dbvserver stability (error handling and debugging information).
  • Improved reverse templates for creating standby database (CSDfollowing
  • a graceful switchover.
  • Improved Dbvserver SQL*Plus shell security.
  • Fix index creation during repository upgrade process.
  • Fix erroneous redirect in Dbvserver reporting page.

New in Dbvisit Standby 6.0.28 (Oct 8, 2012)

  • New features:
  • Create standby database (CSDthrough the web browser has been enhanced
  • to provide greater stability, flexibility and robustness.
  • SQL*Plus command can be run through the web browser under Run commands.
  • Recreation of the standby control file functions through the
  • dbv_functions -Q command has been extended to be able to handle ASM, OMF,
  • regular file system and different primary and standby database layouts.
  • CSD has been enhanced to further handle different primary and standby
  • database layouts. For example an ASM primary database with a non ASM
  • standby database.
  • Added more options to find the Oracle alert log in the web interface.
  • Add "AS COMPRESSED BACKUPSET" to take compressed backup of datafiles
  • during creation of standby database (CSD), for Oracle versions 10 and
  • higher.

New in Dbvisit Standby 6.0.26 (Oct 8, 2012)

  • New features:
  • Enable Dbvisit Standby to be installed with a Windows Domain account.
  • Workaround using a local account is no longer needed.
  • Add check owner function for resolving "Check owner" issues.
  • Run: dbv_functions -a check_owner
  • Allow for unattended install for setting Dbvisit Standby license.
  • Gracefull Switchover will attempt to reset Oracle parameters
  • db_file_name_convert and log_file_name_convert to default values.
  • Use ssh compression during CSD instead of file compression.
  • Fixes:
  • Dbvisit Standby can now be installed in non default location in Windows.
  • Fix for Spanish language setting and RAC.
  • Fix for CSD (create standby databasestop point through web browser.
  • Fix for connectivity between primary and standby scheduler for Windows
  • domain accounts.

New in Dbvisit Standby 6.0.24 (Oct 8, 2012)

  • Fixes:
  • Scheduler message error (dbv_functions: not foundon the standby server
  • when Dbvisit Standby is installed in a different location to the primary
  • server.
  • Improved Scheduler messaging.
  • Activation of standby database through web interface did not update the
  • DDC file - fixed.