sybase数据库的启动及关闭

合集下载
  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。


AIX Version 5
Copyright IBM Corporation, 1982, 2007.
login: sybase
sybase's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: Thu Jul 10 10:25:51 BEIST 2008 on ftp from ::ffff:192.168.100.198
Last login: Fri Jul 11 18:01:41 BEIST 2008 on /dev/pts/0 from 192.168.100.67

查看服务启动情况:(结果未启动)
% showserver
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND

启动主服务:
% cd /opt/sybase/ASE-12_5/install
% ls
ASE_HA.sh RUN_hbcnc_back auditinit setperm_all startserver
RUN_hbcnc SPR auditinit.sym showserver sybhauser
% startserver -f RUN_hbcnc
% 00:00000:00000:2008/07/12 11:56:28.07 kernel Use license file /opt/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2008/07/12 11:56:28.11 kernel Checked out license ASE_SERVER
00:00000:00000:2008/07/12 11:56:28.11 kernel Adaptive Server Enterprise Edition
00:00000:00000:2008/07/12 11:56:28.26 kernel Using config area from primary master device.
00:00000:00000:2008/07/12 11:56:28.36 kernel Using 2000 file descriptors.
00:00000:00000:2008/07/12 11:56:28.38 kernel Adaptive Server Enterprise/12.5.4/EBF 13383/P/RS6000/AIX 5.1/ase1254/2006/64-bit/FBO/Sat May 20 07:06:10 2006
00:00000:00000:2008/07/12 11:56:28.38 kernel Confidential property of Sybase, Inc.
00:00000:00000:2008/07/12 11:56:28.38 kernel Copyright 1987, 2006
00:00000:00000:2008/07/12 11:56:28.38 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2008/07/12 11:56:28.38 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2008/07/12 11:56:28.38 kernel
00:00000:00000:2008/07/12 11:56:28.38 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2008/07/12 11:56:28.38 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2008/07/12 11:56:28.38 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2008/07/12 11:56:28.38 kernel agreement between the Government and Sybase, Inc. or other w

ritten
00:00000:00000:2008/07/12 11:56:28.38 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2008/07/12 11:56:28.38 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2008/07/12 11:56:28.38 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2008/07/12 11:56:28.38 kernel ASE booted on AIX release 3 version 5.
00:00000:00000:2008/07/12 11:56:28.38 kernel Using '/opt/sybase/ASE-12_5/hbcnc.cfg' for configuration information.
00:00000:00000:2008/07/12 11:56:28.38 kernel Logging ASE messages in file '/sybdata/log/install/hbcnc.log'.
00:00000:00000:2008/07/12 11:56:28.56 kernel SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2008/07/12 11:56:28.57 kernel SSL Plus v3.1.14 security modules loaded successfully.
00:00000:00000:2008/07/12 11:56:28.58 kernel Network and device connection limit is 1985.
00:00000:00000:2008/07/12 11:56:32.65 server Number of blocks left for proc headers: 819072.
00:00000:00000:2008/07/12 11:56:32.91 server Proc header memory allocated 409536 pages for each per engine cache
00:00000:00000:2008/07/12 11:56:37.87 server Size of the 2K memory pool: 2750426 Kb
00:00000:00000:2008/07/12 11:56:37.87 server Memory allocated for the default data cache cachelet 1: 2750426 Kb
00:00000:00000:2008/07/12 11:56:37.88 kernel Initializing virtual device 0, '/sybdata/data/master.dat' with dsync 'on'.
00:00000:00000:2008/07/12 11:56:37.90 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2008/07/12 11:56:37.91 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/07/12 11:56:37.91 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:00000:00000:2008/07/12 11:56:37.91 kernel Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2008/07/12 11:56:37.96 kernel engine 0, os pid 823520 online
00:00000:00000:2008/07/12 11:56:37.98 server No active traceflags
00:00000:00001:2008/07/12 11:56:38.00 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.4/EBF 13383/P/RS6000/AIX 5.1/ase1254/2006/64-bit/INST/Sat May 20 03:34:55 2006'.
00:00000:00001:2008/07/12 11:56:38.00 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF13166 ESD #12/DRV.12.5.1.4/ibmaix64/AIX 5.1/BUILD1251-045/OPT/Thu Jan 12 19:55:13 2006'
00:00000:00001:2008/07/12 11:56:38.00 server Opening Master Database ...
00:00000:00001:2008/07/12 11:56:38.27 server Loading SQL Server's default sort order and character set
00:00000:00001:2008/07/12 11:56:38.35 server Loaded default Unilib conversion handle.
00:00000:00001:2008/07/12 11:56:38.41 server Recovering database 'master'

.
00:00000:00001:2008/07/12 11:56:38.42 server Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2008/07/12 11:56:38.43 server Database 'master', checkpoint=(6094, 9), first=(6094, 9), last=(6094, 9).
00:00000:00001:2008/07/12 11:56:38.43 server Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2008/07/12 11:56:38.43 server Started ANALYSIS pass for database 'master'.
00:00000:00001:2008/07/12 11:56:38.43 server Completed ANALYSIS pass for database 'master'.
00:00000:00001:2008/07/12 11:56:38.43 server Started REDO pass for database 'master'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:38.43 server Completed REDO pass for database 'master'.
00:00000:00001:2008/07/12 11:56:38.43 server Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:38.43 server Started recovery checkpoint for database 'master'.
00:00000:00001:2008/07/12 11:56:38.44 server Completed recovery checkpoint for database 'master'.
00:00000:00001:2008/07/12 11:56:38.44 server Started filling free space info for database 'master'.
00:00000:00001:2008/07/12 11:56:38.46 server Completed filling free space info for database 'master'.
00:00000:00001:2008/07/12 11:56:38.46 server Started cleaning up the default data cache for database 'master'.
00:00000:00001:2008/07/12 11:56:38.55 server Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2008/07/12 11:56:38.56 server Checking external objects.
00:00000:00001:2008/07/12 11:56:38.57 server Database 'master' is now online.
00:00000:00001:2008/07/12 11:56:38.57 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:38.70 server Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2008/07/12 11:56:38.72 server server name is 'hbcnc'
00:00000:00001:2008/07/12 11:56:38.72 server Activating disk 'dev_alarm_db' of size 5242880 KB.
00:00000:00001:2008/07/12 11:56:38.72 kernel Initializing virtual device 4, '/sybdata/data/dev_alarm_db.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.72 kernel Virtual device 4 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.72 server Activating disk 'dev_resource_db' of size 10485760 KB.
00:00000:00001:2008/07/12 11:56:38.72 kernel Initializing virtual device 6, '/sybdata/data/dev_resource_db.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.72 kernel Virtual device 6 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.72 server Activating disk 'log_dev_alarm_db' of size 1048576 KB.
00:00000:00001:2008/07/12 11:56:38.72 kernel Initializing virtual device 5, '/sybdata/data/log_dev_alarm_db.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.72 kernel Virtual device 5 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.72 serve

r Activating disk 'log_dev_resource_db' of size 2097152 KB.
00:00000:00001:2008/07/12 11:56:38.73 kernel Initializing virtual device 7, '/sybdata/data/log_dev_resource_db.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.73 kernel Virtual device 7 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.73 server Activating disk 'sysprocsdev' of size 126976 KB.
00:00000:00001:2008/07/12 11:56:38.73 kernel Initializing virtual device 1, '/sybdata/data/sysprocs.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.73 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.73 server Activating disk 'systemdbdev' of size 1024000 KB.
00:00000:00001:2008/07/12 11:56:38.73 kernel Initializing virtual device 2, '/sybdata/data/sybsysdb.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.73 kernel Virtual device 2 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.73 server Activating disk 'tempdev' of size 1024000 KB.
00:00000:00001:2008/07/12 11:56:38.73 kernel Initializing virtual device 3, '/sybdata/data/tempdev.dat' with dsync 'on'.
00:00000:00001:2008/07/12 11:56:38.73 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00001:2008/07/12 11:56:38.80 server Recovering database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Database 'sybsystemdb', checkpoint=(667, 14), first=(667, 14), last=(667, 14).
00:00000:00001:2008/07/12 11:56:38.80 server Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:38.80 server Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:38.80 server Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.80 server Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.81 server Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.81 server Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.90 server Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2008/07/12 11:56:38.90 server Boot Count: 11
00:00000:00001:2008/07/12 11:56:38.9

1 server Checking external objects.
00:00000:00001:2008/07/12 11:56:38.91 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:39.00 server Database 'sybsystemdb' is now online.
00:00000:00001:2008/07/12 11:56:39.01 server Recovering database 'model'.
00:00000:00001:2008/07/12 11:56:39.01 server Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2008/07/12 11:56:39.01 server Database 'model', checkpoint=(629, 0), first=(629, 0), last=(629, 0).
00:00000:00001:2008/07/12 11:56:39.01 server Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2008/07/12 11:56:39.01 server Started ANALYSIS pass for database 'model'.
00:00000:00001:2008/07/12 11:56:39.01 server Completed ANALYSIS pass for database 'model'.
00:00000:00001:2008/07/12 11:56:39.01 server Started REDO pass for database 'model'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:39.02 server Completed REDO pass for database 'model'.
00:00000:00001:2008/07/12 11:56:39.02 server Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:39.02 server Started recovery checkpoint for database 'model'.
00:00000:00001:2008/07/12 11:56:39.02 server Completed recovery checkpoint for database 'model'.
00:00000:00001:2008/07/12 11:56:39.02 server Started filling free space info for database 'model'.
00:00000:00001:2008/07/12 11:56:39.02 server Completed filling free space info for database 'model'.
00:00000:00001:2008/07/12 11:56:39.02 server Started cleaning up the default data cache for database 'model'.
00:00000:00001:2008/07/12 11:56:39.11 server Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2008/07/12 11:56:39.11 server Checking external objects.
00:00000:00001:2008/07/12 11:56:39.11 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:39.21 server Database 'model' is now online.
00:00000:00001:2008/07/12 11:56:39.21 server The logical pagesize of the server is 2 Kb.
00:00000:00001:2008/07/12 11:56:39.21 server 0 dump conditions detected at boot time
00:00000:00001:2008/07/12 11:56:39.22 server Resident Node id: 92ff02f45d1b
00:00000:00001:2008/07/12 11:56:39.23 server Transaction coordinator initialized.
00:00000:00001:2008/07/12 11:56:39.23 server Clearing temp db
00:00000:00001:2008/07/12 11:56:48.19 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:48.28 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:48.39 server Database 'tempdb' is now online.
00:00000:00001:2008/07/12 11:56:48.48 server Recovering database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.48 server Started estimating recovery log boundaries for database '

sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Database 'sybsystemprocs', checkpoint=(51832, 20), first=(51832, 20), last=(51832, 20).
00:00000:00001:2008/07/12 11:56:48.49 server Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:48.49 server Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:48.49 server Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Completed recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.49 server Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.50 server Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.50 server Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.59 server Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2008/07/12 11:56:48.59 server Checking external objects.
00:00000:00001:2008/07/12 11:56:48.60 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:48.70 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:48.81 server Database 'sybsystemprocs' is now online.
00:00000:00001:2008/07/12 11:56:48.92 server Database 'master' is now online.
00:00000:00001:2008/07/12 11:56:49.01 server Database 'model' is now online.
00:00000:00001:2008/07/12 11:56:49.12 server Database 'sybsystemdb' is now online.
00:00000:00001:2008/07/12 11:56:49.22 server Database 'tempdb' is now online.
00:00000:00008:2008/07/12 11:56:49.25 kernel network name HBCNCDB, interface IPv4, address 192.168.100.17, type tcp, port 5000, filter NONE
00:00000:00001:2008/07/12 11:56:49.94 server The wash size of the 2K buffer pool in cache default data cache has been changed from 61440 Kb to 61440 Kb due to a change in the size of the pool.
00:00000:00001:2008/07/12 11:56:49.95 server Recovery has tuned the size of '16K' pool in 'default data cache' to benefit recovery performance. The original configuration will be restored at the end of recovery.
00:00000:00001:2008/07/12 11:56:49.95 server Recovery has tuned the size of '2K' pool in 'default data cache' to benefit recovery performance. The original configuration will be res

tored at the end of recovery.
00:00000:00001:2008/07/12 11:56:49.95 server Recovery has tuned the '16K' 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:00000:00001:2008/07/12 11:56:49.95 server Recovery has tuned the '2K' 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:00000:00001:2008/07/12 11:56:49.95 server The server will recover databases serially.
00:00000:00001:2008/07/12 11:56:50.04 server Recovering database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.04 server Started estimating recovery log boundaries for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.05 server Database 'alarm_db', checkpoint=(2560007, 18), first=(2560007, 18), last=(2560007, 18).
00:00000:00001:2008/07/12 11:56:50.05 server Completed estimating recovery log boundaries for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.05 server Started ANALYSIS pass for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.05 server Completed ANALYSIS pass for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.05 server Started REDO pass for database 'alarm_db'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:50.06 server Completed REDO pass for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.06 server Recovery of database 'alarm_db' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:50.06 server Started recovery checkpoint for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.06 server Completed recovery checkpoint for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.06 server Started filling free space info for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.07 server Completed filling free space info for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.07 server Started cleaning up the default data cache for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.16 server Completed cleaning up the default data cache for database 'alarm_db'.
00:00000:00001:2008/07/12 11:56:50.16 server Checking external objects.
00:00000:00001:2008/07/12 11:56:50.18 server The transaction log in the database 'alarm_db' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:50.27 server The transaction log in the database 'alarm_db' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:50.37 server Database 'alarm_db' is now online.
00:00000:00001:2008/07/12 11:56:50.44 server Recovering database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.44 server Started estimating recovery log boundaries for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.44 server Database 'resource_db', checkpoint=(5120007, 18), first=(5120007, 18), last=(5120007, 18).
00:00000:00001:2008/07/12 11:56:50.44 server

Completed estimating recovery log boundaries for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.44 server Started ANALYSIS pass for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.44 server Completed ANALYSIS pass for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.44 server Started REDO pass for database 'resource_db'. The total number of log records to process is 1.
00:00000:00001:2008/07/12 11:56:50.45 server Completed REDO pass for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.45 server Recovery of database 'resource_db' will undo incomplete nested top actions.
00:00000:00001:2008/07/12 11:56:50.45 server Started recovery checkpoint for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.45 server Completed recovery checkpoint for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.45 server Started filling free space info for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.46 server Completed filling free space info for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.46 server Started cleaning up the default data cache for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.54 server Completed cleaning up the default data cache for database 'resource_db'.
00:00000:00001:2008/07/12 11:56:50.54 server Checking external objects.
00:00000:00001:2008/07/12 11:56:50.55 server The transaction log in the database 'resource_db' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:50.64 server The transaction log in the database 'resource_db' will use I/O size of 2 Kb.
00:00000:00001:2008/07/12 11:56:50.76 server Database 'resource_db' is now online.
00:00000:00001:2008/07/12 11:56:50.76 server Recovery has restored the value of 'local async prefetch limit' for '16K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2008/07/12 11:56:50.76 server Recovery has restored the value of 'local async prefetch limit' for '2K' pool in 'default data cache' from '80' to 'DEFAULT'.
00:00000:00001:2008/07/12 11:56:50.84 server Recovery has restored the original size for '16K' pool and '2K' pool in 'default data cache'.
00:00000:00001:2008/07/12 11:56:50.85 server Recovery complete.
00:00000:00001:2008/07/12 11:56:50.85 server SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2008/07/12 11:56:50.86 server SQL Server's default sort order is:
00:00000:00001:2008/07/12 11:56:50.86 server 'bin_cp936' (ID = 50)
00:00000:00001:2008/07/12 11:56:50.86 server on top of default character set:
00:00000:00001:2008/07/12 11:56:50.86 server 'cp936' (ID = 171).
00:00000:00001:2008/07/12 11:56:50.86 server Master device size: 500 megabytes, or 256000 virtual pages. (A virtual page is 2048 bytes.)

启动备份服务:
% startserver -f RUN_hbcnc_back
% Backup Server/12.5.4/EBF 13382/P/RS6000/AIX 4.3.3/ase1254/2418/32-bit/OPT/Mon May 8 20:35:43 2006
Confidential property of Sybase, Inc.
Copyri

ght 1987, 2006
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

Logging Backup Server messages in file '/sybdata/log/hbcnc_back.log'

%
查看启动以后的状态:(已启动)
% showserver
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND
sybase 823520 1.1 0.0 25928 17036 pts/7 A 11:56:27 0:16 /opt/sybase/ASE-12_5/bin/dataserver -d/sybdata/data/master.dat -e/sybdata/log/install/hbcnc.log -c/opt/sybase/ASE-12_5/hbcnc.cfg -M/opt/sybase/ASE-12_5 -shbcnc
sybase 413746 0.0 0.0 7028 7068 pts/7 A 11:58:07 0:00 /opt/sybase/ASE-12_5/bin/backupserver -e/sybdata/log/hbcnc_back.log -N25 -C20 -M/opt/sybase/ASE-12_5/bin/sybmultbuf -Shbcnc_back
%

进入到sql命令行:
% isql -Usa -Psybase -Shbcnc
Msg 2401, Level 11, State 2:
Server 'hbcnc':
1>



\\提示:

关机、关闭sybase数据库:


% isql -Usa -Psybase -Shbcnc (-U后是用户名sa,-P后是密码sybase,-S后是服务hbcnc)

% isql -Usa -Psybase -Shbcnc
Msg 2401, Level 11, State 2:
Server 'hbcnc':
1>

先关备份服务:
1> shutdown SYB_BACKUP
2> go
Backup Server: 3.48.1.1: The Backup Server will go down immediately.
Terminating sessions.
1> 00:00000:00011:2008/07/12 12:03:07.60 kernel Cannot read, host process disconnected: SYB_BACKUP spid: 11

*****************************************************************************************
\\提示:相关命令输完以后,执行go,才会生效,如果输入命令手误输错,可以使用 reset重置
1> shutdown SYB_backs
2> reset
1> shutdown SYB_BACKUP
2> go
*****************************************************************************************

再关主服务:
1> shutdown
2> go
00:00000:00010:2008/07/12 12:05:43.61 server Shutdown started by user 'sa'. SQL text: shutdown
Server SHUTDOWN by request.
00:00000:00010:2008/07/12 12:05:43.70 server SQL Server shutdown by request.
The SQL Server is terminating this process.
00:00000:00010:2008/07/12 12:05:43.70 kernel ueshutdown: exiting
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
%
检查是否已经关闭:
% showserver
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND

关机:
% shutdown -F

相关文档
最新文档