Mirror de Device no Sybase

Além de ser trivial trabalhar com Raw Devices no Sybase ASE (pode-se controlar o espaço utilizado no dispositivo, e até alocar vários bancos de dados no mesmo Raw Device), é possível fazer um espelhamento de um Device em outro Device já existente, eliminando assim a necessidade de um RAID, enquanto continua-se com o ganho obtido pelo acesso direto ao disco rígido.

Este tipo de espelhamento pode ser feito também com Devices baseados em arquivos.

[sybase@Sybase01 ~]$ isql -Usa -PNerv2011 -SSYBASE01 -w 150
1> disk mirror name = "IMDB", mirror = "IMDB_mirror"
2> go
Msg 5155, Level 16, State 1:
Server 'SYBASE01', Line 1:
The command 'DISK MIRROR' cannot be executed since disk mirroring has been disabled. In order to enable disk mirroring, use: sp_configure 'disable
disk mirroring',0 and restart the server.
1> sp_configure 'disable disk mirroring',0
2> go
Parameter Name Default Memory Used
Config Value Run Value Unit
Type
------------------------------------------------------------ ---------------------------------------- ----------------------
---------------------------------------- ---------------------------------------- ----------------------------------------
----------------------------------------
disable disk mirroring 1 0
0 1 switch
static
(1 row affected)
Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.
Changing the value of 'disable disk mirroring' does not increase the amount of memory Adaptive Server uses.
(return status = 0)
1> shutdown
2> go
Server SHUTDOWN by request.
ASE is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
[sybase@Sybase01 ~]$ /opt/sybase/ASE-15_0/install/startserver -f /opt/sybase/ASE-15_0/install/RUN_SYBASE01
[sybase@Sybase01 ~]$ 00:00:00000:00000:2011/03/23 14:22:00.49 kernel SySAM: Using licenses from: /opt/sybase/SYSAM-2_0/licenses/SYBASE_ASE_DE.lic
00:00:00000:00000:2011/03/23 14:22:00.50 kernel SySAM: Checked out license for 1 ASE_CORE (2013.1231/permanent/0A1F EC50 7138 C903).
00:00:00000:00000:2011/03/23 14:22:00.50 kernel This product is licensed to: ASE Developer Edition - For Development and Test use only
00:00:00000:00000:2011/03/23 14:22:00.50 kernel Checked out license ASE_CORE
00:00:00000:00000:2011/03/23 14:22:00.50 kernel Adaptive Server Enterprise (Developer Edition)
00:00:00000:00000:2011/03/23 14:22:00.51 kernel Using config area from primary master device.
00:00:00000:00000:2011/03/23 14:22:00.52 kernel Could not allocate memory using Huge Pages. Allocated using regular pages. For better performance, reboot the server after configuring enough Huge Pages.
00:00:00000:00000:2011/03/23 14:22:00.52 kernel Internal run-time model set for Linux - Native
00:00:00000:00000:2011/03/23 14:22:00.52 kernel Using 1024 file descriptors.
00:00:00000:00000:2011/03/23 14:22:00.52 kernel Adaptive Server Enterprise/15.5/EBF 18159 SMP ESD#2/P/Linux Intel/Linux 2.6.9-55.ELsmp i686/asear155/2514/32-bit/FBO/Wed Aug 25 08:21:19 2010
00:00:00000:00000:2011/03/23 14:22:00.52 kernel Confidential property of Sybase, Inc.
00:00:00000:00000:2011/03/23 14:22:00.53 kernel Copyright 1987, 2010
00:00:00000:00000:2011/03/23 14:22:00.53 kernel Sybase, Inc. All rights reserved.
00:00:00000:00000:2011/03/23 14:22:00.53 kernel Unpublished rights reserved under U.S. copyright laws.
00:00:00000:00000:2011/03/23 14:22:00.53 kernel
00:00:00000:00000:2011/03/23 14:22:00.53 kernel This software contains confidential and trade secret information of Sybase,
00:00:00000:00000:2011/03/23 14:22:00.53 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00:00000:00000:2011/03/23 14:22:00.53 kernel the U.S. Government is subject to restrictions set forth in a license
00:00:00000:00000:2011/03/23 14:22:00.54 kernel agreement between the Government and Sybase, Inc. or other written
00:00:00000:00000:2011/03/23 14:22:00.54 kernel agreement specifying the Government's rights to use the software and any
00:00:00000:00000:2011/03/23 14:22:00.54 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00:00000:00000:2011/03/23 14:22:00.54 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00:00000:00000:2011/03/23 14:22:00.54 kernel Using /opt/sybase as the 'SYBASE' environment variable, found during startup.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel Using OCS-15_0 as the 'SYBASE_OCS' environment variable, found during startup.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel Using ASE-15_0 as the 'SYBASE_ASE' environment variable, found during startup.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel ASE booted on host 'Sybase01.localdomain' running Linux release 2.6.18-194.32.1.el5 version #1 SMP Wed Jan 5 17:53:09 EST 2011.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel Using '/opt/sybase/ASE-15_0/SYBASE01.cfg' for configuration information.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel Logging ASE messages in file '/opt/sybase/ASE-15_0/install/SYBASE01.log'.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel Platform TCP network support seems IPv6-aware, IPv4/IPv6 are both enabled.
00:00:00000:00000:2011/03/23 14:22:00.55 kernel ASE booted with TCP_NODELAY enabled.
00:00:00000:00000:2011/03/23 14:22:00.57 kernel SSL Plus v5.2.2 security modules loaded successfully.
00:00:00000:00000:2011/03/23 14:22:00.57 kernel Network and device connection limit is 1009.
00:00:00000:00000:2011/03/23 14:22:00.57 kernel ASE - Dynamic Pluggable Component Interface is disabled
00:00:00000:00000:2011/03/23 14:22:00.75 server Number of blocks left for proc headers: 51152.
00:00:00000:00000:2011/03/23 14:22:00.84 server Proc header memory allocated 10230 pages for each per engine cache
00:00:00000:00000:2011/03/23 14:22:00.84 kernel Enabling Linux Native Kernel asynchronous disk I/O strategy.
00:00:00000:00000:2011/03/23 14:22:00.85 kernel Initializing virtual device 0, '/opt/sybase/data/master.dat' with dsync 'off'.
00:00:00000:00000:2011/03/23 14:22:00.85 kernel Virtual device 0 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00000:2011/03/23 14:22:00.85 server Loaded default Unilib conversion handle.
00:00:00000:00000:2011/03/23 14:22:00.86 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00:00000:00000:2011/03/23 14:22:00.86 kernel Unix interval timer enabled for sysclk interrupts.
00:00:00000:00000:2011/03/23 14:22:00.86 kernel libsybibmmq - Sybase IBM MQ interface/15.5/EBF 18159 SMP ESD#2/P/Linux Intel/Linux 2.6.9-55.ELsmp i686/asear155/2514/32-bit/OPT/Wed Aug 25 05:46:01 2010
00:00:00000:00000:2011/03/23 14:22:00.86 kernel Confidential property of Sybase, Inc.
Copyright 1987, 2010
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreemen
00:00:00000:00000:2011/03/23 14:22:00.87 kernel Loaded encryption provider CSI-2.6.3M2-linux-2010/07/07 08:00:38 PDT-sybcsi_openssl-OpenSSL 0.9.8l 5 Nov 2009.
00:00:00000:00000:2011/03/23 14:22:00.87 kernel Begin processing to generate RSA keypair.
00:00:00000:00000:2011/03/23 14:22:00.93 kernel Completed processing to generate RSA keypair.
00:00:00000:00000:2011/03/23 14:22:00.94 kernel Encryption provider initialization succeeded on engine 0.
00:00:00000:00000:2011/03/23 14:22:00.94 kernel engine 0, os pid 2835 online
00:00:00000:00000:2011/03/23 14:22:00.94 server No active traceflags
00:00:00000:00001:2011/03/23 14:22:00.94 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/15.5/P-EBF18132 ESD #6/DRV.15.5.1/Linux Intel/Linux 2.6.9-55.ELsmp x86_64 Native Threads/BUILD1550-008/OPT/Mon Jul 26 21:02:32 2010'
00:00:00000:00001:2011/03/23 14:22:00.95 server Size of the 8K memory pool: 8192 Kb
00:00:00000:00001:2011/03/23 14:22:00.96 server Size of the 4K memory pool: 73728 Kb
Memory allocated for the default data cache cachelet 1: 81920 Kb
00:00:00000:00001:2011/03/23 14:22:00.98 server Size of the 4K memory pool: 81920 Kb
Memory allocated for the tempdb_cache cachelet 1: 81920 Kb
00:00:00000:00001:2011/03/23 14:22:00.98 server Opening Master Database ...
00:00:00000:00001:2011/03/23 14:22:01.02 server Loading ASE's default sort order and character set
00:00:00000:00001:2011/03/23 14:22:01.03 server Recovering database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.03 server Started estimating recovery log boundaries for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.04 server Database 'master', checkpoint=(3788, 27), first=(3788, 27), last=(3788, 27).
00:00:00000:00001:2011/03/23 14:22:01.04 server Completed estimating recovery log boundaries for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.04 server Started ANALYSIS pass for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.04 server Completed ANALYSIS pass for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.04 server Log contains all committed transactions until 2011/03/23 14:21:52.01 for database master.
00:00:00000:00001:2011/03/23 14:22:01.04 server Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:01.05 server Completed REDO pass for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.11 server Timestamp for database 'master' is (0x0000, 0x0000f5e4).
00:00:00000:00001:2011/03/23 14:22:01.11 server Recovery of database 'master' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:01.11 server Started recovery checkpoint for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.12 server Completed recovery checkpoint for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.12 server Started filling free space info for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.13 server Completed filling free space info for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.14 server Started cleaning up the default data cache for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.14 server Completed cleaning up the default data cache for database 'master'.
00:00:00000:00001:2011/03/23 14:22:01.16 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:01.22 server Database 'master' is now online.
00:00:00000:00001:2011/03/23 14:22:01.23 server The transaction log in the database 'master' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:01.25 server server name is 'SYBASE01'
00:00:00000:00001:2011/03/23 14:22:01.25 server Activating disk 'sysprocsdev' of size 155648 KB.
00:00:00000:00001:2011/03/23 14:22:01.25 kernel Initializing virtual device 1, '/opt/sybase/data/sysprocs.dat' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.25 kernel Virtual device 1 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.26 server Activating disk 'systemdbdev' of size 6144 KB.
00:00:00000:00001:2011/03/23 14:22:01.26 kernel Initializing virtual device 2, '/opt/sybase/data/sybsysdb.dat' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.26 kernel Virtual device 2 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.26 server Activating disk 'tempdbdev' of size 102400 KB.
00:00:00000:00001:2011/03/23 14:22:01.26 kernel Initializing virtual device 3, '/opt/sybase/data/tempdbdev.dat' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.26 kernel Virtual device 3 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.26 server Activating disk 'sybmgmtdev' of size 76800 KB.
00:00:00000:00001:2011/03/23 14:22:01.26 kernel Initializing virtual device 4, '/opt/sybase/data/sybmgmtdb.dat' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.27 kernel Virtual device 4 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.27 server Activating disk 'IMDB' of size 10240000 KB.
00:00:00000:00001:2011/03/23 14:22:01.27 kernel Initializing virtual device 5, '/dev/sdb1' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.27 kernel Virtual device 5 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.27 server Activating disk 'IMDB_mirror' of size 10240000 KB.
00:00:00000:00001:2011/03/23 14:22:01.27 kernel Initializing virtual device 6, '/dev/sdc1' with dsync 'off'.
00:00:00000:00001:2011/03/23 14:22:01.27 kernel Virtual device 6 started using asynchronous (with DIRECTIO) i/o.
00:00:00000:00001:2011/03/23 14:22:01.33 server Recovering database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.33 server Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.33 server Database 'sybsystemdb', checkpoint=(903, 14), first=(903, 14), last=(903, 14).
00:00:00000:00001:2011/03/23 14:22:01.33 server Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.34 server Started ANALYSIS pass for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.34 server Completed ANALYSIS pass for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.34 server Log contains all committed transactions until 2011/03/21 12:05:09.76 for database sybsystemdb.
00:00:00000:00001:2011/03/23 14:22:01.34 server Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:01.34 server Completed REDO pass for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.36 server Timestamp for database 'sybsystemdb' is (0x0000, 0x000013b0).
00:00:00000:00001:2011/03/23 14:22:01.36 server Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:01.36 server Started recovery checkpoint for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.36 server Completed recovery checkpoint for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.37 server Started filling free space info for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.37 server Completed filling free space info for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.38 server Started cleaning up the default data cache for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.38 server Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00:00000:00001:2011/03/23 14:22:01.38 server Boot Count: 11
00:00:00000:00001:2011/03/23 14:22:01.39 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:01.44 server The transaction log in the database 'sybsystemdb' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:01.44 server Resident Node id: a1600a66fa7e
00:00:00000:00001:2011/03/23 14:22:01.46 server Transaction coordinator initialized.
00:00:00000:00001:2011/03/23 14:22:01.46 server Database 'sybsystemdb' is now online.
00:00:00000:00001:2011/03/23 14:22:01.47 server Recovering database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.48 server Started estimating recovery log boundaries for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.48 server Database 'model', checkpoint=(898, 33), first=(898, 33), last=(898, 33).
00:00:00000:00001:2011/03/23 14:22:01.49 server Completed estimating recovery log boundaries for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.49 server Started ANALYSIS pass for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.49 server Completed ANALYSIS pass for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.49 server Log contains all committed transactions until 2011/03/21 12:05:09.76 for database model.
00:00:00000:00001:2011/03/23 14:22:01.49 server Started REDO pass for database 'model'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:01.50 server Completed REDO pass for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.50 server Timestamp for database 'model' is (0x0000, 0x00001302).
00:00:00000:00001:2011/03/23 14:22:01.50 server Recovery of database 'model' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:01.50 server Started recovery checkpoint for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.51 server Completed recovery checkpoint for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.51 server Started filling free space info for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.51 server Completed filling free space info for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.52 server Started cleaning up the default data cache for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.52 server Completed cleaning up the default data cache for database 'model'.
00:00:00000:00001:2011/03/23 14:22:01.52 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:01.57 server The transaction log in the database 'model' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:01.57 server Database 'model' is now online.
00:00:00000:00001:2011/03/23 14:22:01.57 server The logical pagesize of the server is 4 Kb.
00:00:00000:00001:2011/03/23 14:22:01.58 server 0 dump conditions detected at boot time
00:00:00000:00001:2011/03/23 14:22:01.58 server Clearing temporary database 'tempdb'.
00:00:00000:00001:2011/03/23 14:22:01.68 server Timestamp for database 'tempdb' is (0x0000, 0x00001302).
00:00:00000:00001:2011/03/23 14:22:01.73 server The transaction log in the database 'tempdb' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:01.73 server Database 'tempdb' is now online.
00:00:00000:00001:2011/03/23 14:22:01.79 server Recovering database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.79 server Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.80 server Database 'sybsystemprocs', checkpoint=(31833, 31), first=(31833, 31), last=(31833, 31).
00:00:00000:00001:2011/03/23 14:22:01.80 server Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.80 server Started ANALYSIS pass for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.80 server Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.80 server Log contains all committed transactions until 2011/03/22 17:41:35.13 for database sybsystemprocs.
00:00:00000:00001:2011/03/23 14:22:01.81 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:01.81 server Completed REDO pass for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.90 server Timestamp for database 'sybsystemprocs' is (0x0000, 0x000463c3).
00:00:00000:00001:2011/03/23 14:22:01.90 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:01.90 server Started recovery checkpoint for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.91 server Completed recovery checkpoint for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.91 server Started filling free space info for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.91 server Completed filling free space info for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.92 server Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.92 server Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00:00000:00001:2011/03/23 14:22:01.92 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:01.99 server The transaction log in the database 'sybsystemprocs' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:01.99 server Database 'sybsystemprocs' is now online.
00:00:00000:00009:2011/03/23 14:22:02.03 kernel network name Sybase01, interface IPv4, address 127.0.0.1, type tcp, port 5000, filter NONE
00:00:00000:00001:2011/03/23 14:22:02.19 server The wash size of the 4K buffer pool in cache default data cache has been changed from 14744 Kb to 8848 Kb due to a change in the size of the pool.
00:00:00000:00001:2011/03/23 14:22:02.20 server Recovery has tuned the size of '32K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00:00000:00001:2011/03/23 14:22:02.20 server Recovery has tuned the size of '4K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00:00000:00001:2011/03/23 14:22:02.20 server Recovery has tuned the '32K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00:00000:00001:2011/03/23 14:22:02.20 server Recovery has tuned the '4K' pool in 'default data cache' by changing its 'local async prefetch limit' from 10 to 80. The original configuration will be restored at the end of recovery.
00:00:00000:00001:2011/03/23 14:22:02.20 server The server will recover databases serially.
00:00:00000:00001:2011/03/23 14:22:02.21 server Recovering database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.22 server Started estimating recovery log boundaries for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.23 server Database 'pubs2', checkpoint=(1305, 31), first=(1305, 31), last=(1305, 31).
00:00:00000:00001:2011/03/23 14:22:02.23 server Completed estimating recovery log boundaries for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.23 server Started ANALYSIS pass for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.23 server Completed ANALYSIS pass for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.23 server Log contains all committed transactions until 2011/03/23 11:43:34.43 for database pubs2.
00:00:00000:00001:2011/03/23 14:22:02.23 server Started REDO pass for database 'pubs2'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:02.23 server Completed REDO pass for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.26 server Timestamp for database 'pubs2' is (0x0000, 0x0000260d).
00:00:00000:00001:2011/03/23 14:22:02.26 server Recovery of database 'pubs2' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:02.26 server Started recovery checkpoint for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.26 server Completed recovery checkpoint for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.27 server Started filling free space info for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.27 server Completed filling free space info for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.27 server Started cleaning up the default data cache for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.27 server Completed cleaning up the default data cache for database 'pubs2'.
00:00:00000:00001:2011/03/23 14:22:02.28 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:02.32 server The transaction log in the database 'pubs2' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:02.32 server Database 'pubs2' is now online.
00:00:00000:00001:2011/03/23 14:22:02.33 server Recovering database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.34 server Started estimating recovery log boundaries for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.34 server Database 'pubs3', checkpoint=(1223, 27), first=(1223, 27), last=(1223, 27).
00:00:00000:00001:2011/03/23 14:22:02.34 server Completed estimating recovery log boundaries for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.34 server Started ANALYSIS pass for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.35 server Completed ANALYSIS pass for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.35 server Log contains all committed transactions until 2011/03/23 11:43:35.68 for database pubs3.
00:00:00000:00001:2011/03/23 14:22:02.35 server Started REDO pass for database 'pubs3'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:02.35 server Completed REDO pass for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.36 server Timestamp for database 'pubs3' is (0x0000, 0x00002765).
00:00:00000:00001:2011/03/23 14:22:02.36 server Recovery of database 'pubs3' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:02.36 server Started recovery checkpoint for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.36 server Completed recovery checkpoint for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.37 server Started filling free space info for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.37 server Completed filling free space info for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.37 server Started cleaning up the default data cache for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.37 server Completed cleaning up the default data cache for database 'pubs3'.
00:00:00000:00001:2011/03/23 14:22:02.38 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:02.41 server The transaction log in the database 'pubs3' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:02.41 server Database 'pubs3' is now online.
00:00:00000:00001:2011/03/23 14:22:02.42 server Recovering database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.43 server Started estimating recovery log boundaries for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.43 server Database 'IMDB', checkpoint=(1048580, 13), first=(1048580, 13), last=(1048580, 13).
00:00:00000:00001:2011/03/23 14:22:02.43 server Completed estimating recovery log boundaries for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.43 server Started ANALYSIS pass for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.43 server Completed ANALYSIS pass for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.43 server Log contains all committed transactions until 2011/03/23 14:19:12.15 for database IMDB.
00:00:00000:00001:2011/03/23 14:22:02.43 server Started REDO pass for database 'IMDB'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:02.44 server Completed REDO pass for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.44 server Timestamp for database 'IMDB' is (0x0000, 0x0000131e).
00:00:00000:00001:2011/03/23 14:22:02.44 server Recovery of database 'IMDB' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:02.44 server Started recovery checkpoint for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.45 server Completed recovery checkpoint for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.45 server Started filling free space info for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.46 server Completed filling free space info for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.46 server Started cleaning up the default data cache for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.46 server Completed cleaning up the default data cache for database 'IMDB'.
00:00:00000:00001:2011/03/23 14:22:02.46 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:02.50 server The transaction log in the database 'IMDB' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:02.50 server Database 'IMDB' is now online.
00:00:00000:00001:2011/03/23 14:22:02.52 server Recovering database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.52 server Started estimating recovery log boundaries for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.53 server Database 'sybmgmtdb', checkpoint=(7211, 42), first=(7211, 42), last=(7211, 42).
00:00:00000:00001:2011/03/23 14:22:02.53 server Completed estimating recovery log boundaries for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.53 server Started ANALYSIS pass for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.53 server Completed ANALYSIS pass for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.53 server Log contains all committed transactions until 2011/03/23 14:21:51.94 for database sybmgmtdb.
00:00:00000:00001:2011/03/23 14:22:02.54 server Started REDO pass for database 'sybmgmtdb'. The total number of log records to process is 1.
00:00:00000:00001:2011/03/23 14:22:02.54 server Completed REDO pass for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.66 server Timestamp for database 'sybmgmtdb' is (0x0000, 0x0000c648).
00:00:00000:00001:2011/03/23 14:22:02.66 server Recovery of database 'sybmgmtdb' will undo incomplete nested top actions.
00:00:00000:00001:2011/03/23 14:22:02.67 server Started recovery checkpoint for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.67 server Completed recovery checkpoint for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.67 server Started filling free space info for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.68 server Completed filling free space info for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.68 server Started cleaning up the default data cache for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.68 server Completed cleaning up the default data cache for database 'sybmgmtdb'.
00:00:00000:00001:2011/03/23 14:22:02.68 server Checking external objects.
00:00:00000:00001:2011/03/23 14:22:02.74 server The transaction log in the database 'sybmgmtdb' will use I/O size of 8 Kb.
00:00:00000:00001:2011/03/23 14:22:02.74 server Database 'sybmgmtdb' is now online.
00:00:00000:00001:2011/03/23 14:22:02.74 server Recovery has restored the value of 'local async prefetch limit' for '32K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00:00000:00001:2011/03/23 14:22:02.74 server Recovery has restored the value of 'local async prefetch limit' for '4K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00:00000:00001:2011/03/23 14:22:02.74 server Recovery has restored the original size for '32K' pool and '4K' pool in 'default data cache'.
00:00:00000:00001:2011/03/23 14:22:02.75 server Recovery complete.
00:00:00000:00001:2011/03/23 14:22:02.75 server ASE's default unicode sort order is 'binary'.
00:00:00000:00001:2011/03/23 14:22:02.75 server ASE's default sort order is:
00:00:00000:00001:2011/03/23 14:22:02.75 server 'bin_iso_1' (ID = 50)
00:00:00000:00001:2011/03/23 14:22:02.75 server on top of default character set:
00:00:00000:00001:2011/03/23 14:22:02.75 server 'iso_1' (ID = 1).
00:00:00000:00001:2011/03/23 14:22:02.76 server Master device size: 60 megabytes, or 30720 virtual pages. (A virtual page is 2048 bytes.)
00:00:00000:00011:2011/03/23 14:22:02.77 kernel Initializing Job Scheduler Task
00:00:00000:00011:2011/03/23 14:22:02.83 kernel Installed Job Scheduler sequencer code version 0.27 - 27 tokens
JS Agent/15.5/EBF 18159 SMP ESD#2/P/Linux Intel/Linux 2.6.9-55.ELsmp i686/asear155/2514/32-bit/OPT/Wed Aug 25 05:46:01 2010
Confidential property of Sybase, Inc.
Copyright 1987, 2010
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00:00000:00011:2011/03/23 14:22:03.09 kernel Job Scheduler Task state set to running, startcount 1.
[sybase@Sybase01 ~]$ isql -Usa -PNerv2011 -SSYBASE01 -w 150
1> disk mirror name = "IMDB", mirror = "IMDB_mirror"
2> go
Creating the physical file for the mirror...
00:00:00000:00012:2011/03/23 14:22:06.48 kernel mirror for virtual device 5 started using asynchronous (with DIRECTIO) I/O
Starting Dynamic Mirroring of 2560000 pages for logical device 'IMDB'.
512 pages mirrored...
1024 pages mirrored...
1536 pages mirrored...
2048 pages mirrored...
2560 pages mirrored...
3072 pages mirrored...
3584 pages mirrored...
4096 pages mirrored...
4608 pages mirrored...
5120 pages mirrored...
5632 pages mirrored...
6144 pages mirrored...
6656 pages mirrored...
7168 pages mirrored...
7680 pages mirrored...
8192 pages mirrored...
8704 pages mirrored...
9216 pages mirrored...
9728 pages mirrored...
10240 pages mirrored...
...
1570304 pages mirrored...
1570816 pages mirrored...
1571328 pages mirrored...
1571840 pages mirrored...
1572352 pages mirrored...
1572864 pages mirrored...
The remaining 987136 pages are currently unallocated and will be mirrored as they are allocated.
1>

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.