cmd访问数据库如笔者在部署数据库应用的时候,比较倾向于在Uniux或者Linux平台上
这些备用数据库可能位于距生产数据中心数千英里的远程灾难恢复站点,或者可能位于同一城市、同一校园乃至同一建筑物内
互联网产业迫切的需要新式数据库来解决种种问题,大量的传统企业纷纷进行互联网化也加速了新式数据库的成熟
卸下数据库的命令:Sp_detach_db 数据库名连接数据库的命令:Sp_attach_db或者sp_attach_single_file_dbs_attach_db [@dbname =] ''dbname'', [@filename1 =] ''filename_n'' [,...16]sp_attach_single_file_db [@dbname =] ''dbname'', [@physname =] ''physical_name''使用此方法可以正确恢复SQL Sever7.0和SQL Server 2000的数据库文件,要点是备份的时候一定要将mdf和ldf两个文件都备份下来,mdf文件是数据库数据文件,ldf是数据库日志文件
不说别其他的,单就技术本身而论,开源是一个很好的提升技术档次的模式
特别提醒:本网信息来自于互联网,目的在于传递更多信息,并不代表本网赞同其观点
SQL Azure Database 帮助简化多数据库的供应和部署,开发人员无需安装、设置数据库软件,也不必为数据库打补丁或进行管理
"对Oracle10g ASM生产数据库运维服务备份和恢复新的10g ASM生产数据库即将上线,以下是上线前做的简单的备份恢复测试:1.首先执行备份$ rman target / @full_bak.sqlRecovery Manager: Release 10.1.0.3.0 - 64bit ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.connected to target database: MMSDB (DBID=799462343)RMAN> run {2> backup database plus archivelog delete all input;3> delete obsolete;4> }5>Starting backup at 13-APR-05current log archivedusing target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=162 devtype=DISKchannel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=28 recid=2 stamp=555502358channel ORA_DISK_1: starting piece 1 at 13-APR-05channel ORA_DISK_1: finished piece 1 at 13-APR-05piece handle=/msflsh/MMSDB/backupset/2005_04_13/o1_mf_annnn_TAG20050413T101239_15s00ry0_.bkp comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/msflsh/MMSDB/archivelog/2005_04_13/o1_mf_1_28_15s00pg2_.arc recid=2 stamp=555502358Finished backup at 13-APR-05Starting backup at 13-APR-05using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=+DATADG/mmsdb/datafile/system.259.3input datafile fno=00003 name=+DATADG/mmsdb/datafile/sysaux.257.3input datafile fno=00002 name=+DATADG/mmsdb/datafile/undotbs1.258.3input datafile fno=00004 name=+DATADG/mmsdb/datafile/users.256.3channel ORA_DISK_1: starting piece 1 at 13-APR-05channel ORA_DISK_1: finished piece 1 at 13-APR-05piece handle=/msflsh/MMSDB/backupset/2005_04_13/ o1_mf_nnndf_TAG20050413T101242_15s00thq_.bkp comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:15Finished backup at 13-APR-05Starting backup at 13-APR-05current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=29 recid=3 stamp=555502377channel ORA_DISK_1: starting piece 1 at 13-APR-05channel ORA_DISK_1: finished piece 1 at 13-APR-05piece handle=/msflsh/MMSDB/backupset/2005_04_13/o1_mf_annnn_TAG20050413T101257_15s01bwm_.bkpcomment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_1: deleting archive log(s)archive log filename=/msflsh/MMSDB/archivelog/2005_04_13/o1_mf_1_29_15s019mj_.arc recid=3stamp=555502377Finished backup at 13-APR-05Starting Control File and SPFILE Autobackup at 13-APR-05piece handle=/msflsh/MMSDB/autobackup/2005_04_13/o1_mf_s_555502380_15s01df2_.bkpcomment=NONEFinished Control File and SPFILE Autobackup at 13-APR-05RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 2using channel ORA_DISK_1no obsolete backups foundRecovery Manager complete.2.冻结HA,停止数据库进行恢复$ iduid=101(oracle) gid=101(dba)$ exit# iduid=0(root) gid=1(other)# hagrp -freeze MMSDB -persistent# su - oracleSun Microsystems Inc. SunOS 5.8 Generic Patch October 2001You have new mail.$ iduid=101(oracle) gid=101(dba)$ sqlplus ""/ as sysdba""SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 13 10:19:28 2005Copyright (c) 1982, 2004, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit ProductionWith the Partitioning and Data Mining optionsSQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0- 64bit ProductionWith the Partitioning and Data Mining options3.执行恢复$ rman target /Recovery Manager: Release 10.1.0.3.0 - 64bit ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.connected to target database (not started)RMAN> startup mount;Oracle instance starteddatabase mountedTotal System Global Area3204448256 bytesFixed Size 1304912 bytesVariable Size651957936 bytesDatabase Buffers2550136832 bytesRedo Buffers 1048576 bytesRMAN> restore database;Starting restore at 13-APR-05using target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=160 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to +DATADG/mmsdb/datafile/system.259.3restoring datafile 00002 to +DATADG/mmsdb/datafile/undotbs1.258.3restoring datafile 00003 to +DATADG/mmsdb/datafile/sysaux.257.3restoring datafile 00004 to +DATADG/mmsdb/datafile/users.256.3channel ORA_DISK_1: restored backup piece 1piece handle=/msflsh/MMSDB/backupset/2005_04_13/ o1_mf_nnndf_TAG20050413T101242_15s00thq_.bkptag=TAG20050413T101242channel ORA_DISK_1: restore completeFinished restore at 13-APR-05RMAN> recover database;Starting recover at 13-APR-05using channel ORA_DISK_1starting media recoverymedia recovery completeFinished recover at 13-APR-05RMAN> alter database open;database openedRMAN>4.最后不要忘记解冻HA$ exit# iduid=0(root) gid=1(other)# hagrp -unfreeze MMSDB -persistent测试过程,仅供参考."
(表CASE_GA_AJZLZ大约有35万数据,有主键)首先在SQLPLUS中打开自动查询执行计划功能
建立该备份空白数据库过程为:先建立主数据库FJJDBBK,然后在FJJDBBK中建立与当前数据库中一样结构的表
在Oracle8.1.6中,Statspack第一次发布,但是你也可以在以下链接找到可用于Oracle80~Oracle8.1.5的版本
物理日志就是记录每一行被改变的内容
定制器中的预览链接在上一个屏幕截图中,可以看到“共享预览链接”选项
WITH ROLLUP, WITH CUBE 和 ALL 等非 ISO 标准语法已经不再有效
接下来,StorageReview切换到VDI克隆测试,即完整克隆和链接克隆
4)访问层:任何一个授权用户都可以通过标准的公用应用接口来登录云存储系统,享受云存储服务
4.AmazonSageMaker Clarify让机器学习开发人员可以更好地掌控其训练数据和模型,从而识别和限制偏差并解释做出相关预测的原因
利用大Batch Size进行同步训练因为GPU设备相对于CPU带来的巨大的算力提升,以往需要上百台CPU节点的集群可以用几十台机器的GPU集群来代替
而且除非逻辑非常简单,否则最好封装到存储过程中