Using RMAN duplicate Created Remote Auxiliary Database

2024-02-01 09:08
文章标签 using duplicate database remote rman created auxiliary

本文主要是介绍Using RMAN duplicate Created Remote Auxiliary Database，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

目标数据库SID=backupdb
辅助数据库SID=backupdb
准备工作包括：目标数据库的全备；在辅助数据库端安装oracle10gR2软件，创建相应的目录、口令文件、pfile，拷贝备份集到辅助数据库

备份全库和当前的controlfile

RMAN> run {
2> allocate channel c1 device type disk;
3> backup as compressed backupset
4> incremental level=0
5> format='/orabackup/inc0_%d_%U' tag='inc0'
6> channel=c1
7> database plus archivelog delete input;
8> backup
9> format='/orabackup/bkctl.ctl' tag='bkctl'
10> channel=c1
11> current controlfile;
12> release channel c1;
13> }
released channel: ORA_DISK_1
allocated channel: c1
channel c1: sid=145 devtype=DISKStarting backup at 28-MAR-12
current log archived
channel c1: starting compressed archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=6 recid=4 stamp=779120629
channel c1: starting piece 1 at 28-MAR-12
channel c1: finished piece 1 at 28-MAR-12
piece handle=/orabackup/inc0_BACKUPDB_01n70rvl_1_1 tag=INC0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/arch/1_6_778974218.dbf recid=4 stamp=779120629
Finished backup at 28-MAR-12Starting backup at 28-MAR-12
channel c1: starting compressed incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00006 name=/u01/app/oracle/oradata/backupdb/catalog01.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/backupdb/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/backupdb/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/backupdb/example01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/backupdb/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/backupdb/users01.dbf
channel c1: starting piece 1 at 28-MAR-12
channel c1: finished piece 1 at 28-MAR-12
piece handle=/orabackup/inc0_BACKUPDB_02n70rvn_1_1 tag=INC0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:55
channel c1: starting compressed incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel c1: starting piece 1 at 28-MAR-12
channel c1: finished piece 1 at 28-MAR-12
piece handle=/orabackup/inc0_BACKUPDB_03n70s1e_1_1 tag=INC0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 28-MAR-12Starting backup at 28-MAR-12
current log archived
channel c1: starting compressed archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7 recid=5 stamp=779120688
channel c1: starting piece 1 at 28-MAR-12
channel c1: finished piece 1 at 28-MAR-12
piece handle=/orabackup/inc0_BACKUPDB_04n70s1g_1_1 tag=INC0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
channel c1: deleting archive log(s)
archive log filename=/arch/1_7_778974218.dbf recid=5 stamp=779120688
Finished backup at 28-MAR-12Starting backup at 28-MAR-12
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
including current control file in backupset
channel c1: starting piece 1 at 28-MAR-12
channel c1: finished piece 1 at 28-MAR-12
piece handle=/orabackup/bkctl.ctl tag=BKCTL comment=NONE
channel c1: backup set complete, elapsed time: 00:00:02
Finished backup at 28-MAR-12released channel: c1RMAN>
RMAN> list backupset summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 28-MAR-12 1 1 YES INC0
2 B 0 A DISK 28-MAR-12 1 1 YES INC0
3 B 0 A DISK 28-MAR-12 1 1 YES INC0
4 B A A DISK 28-MAR-12 1 1 YES INC0
5 B F A DISK 28-MAR-12 1 1 NO BKCTLRMAN>

在远端服务器上创建相应的目录 

[oracle@zhong ~]$ mkdir -p $ORACLE_BASE/admin/backupdb/adump
[oracle@zhong ~]$ mkdir -p $ORACLE_BASE/admin/backupdb/bdump
[oracle@zhong ~]$ mkdir -p $ORACLE_BASE/admin/backupdb/cdump
[oracle@zhong ~]$ mkdir -p $ORACLE_BASE/admin/backupdb/udump
[oracle@zhong ~]$ mkdir -p $ORACLE_BASE/oradata/backupdb
[oracle@zhong ~]$ mkdir -p /u01/app/oracle/flash_recovery_area
[oracle@zhong ~]$ su - root
Password:
[root@zhong ~]# mkdir -p /arch/
[root@zhong ~]# chown oracle.oinstall /arch/
[root@zhong ~]# su - oracle
[oracle@zhong ~]$

在远端服务器上创建口令文件，pfile 

[oracle@zhong ~]$ orapwd file=$ORACLE_HOME/dbs/orapwbackupdb password=oracle entries=5
[oracle@zhong ~]$ cat $ORACLE_HOME/dbs/initbackupdb.ora
backupdb.__db_cache_size=184549376
backupdb.__java_pool_size=4194304
backupdb.__large_pool_size=4194304
backupdb.__shared_pool_size=88080384
backupdb.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/backupdb/adump'
*.background_dump_dest='/u01/app/oracle/admin/backupdb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/backupdb/control01.ctl','/u01/app/oracle/oradata/backupdb/control02.ctl','/u01/app/oracle/oradata/backupdb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/backupdb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='backupdb'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.dispatchers='(PROTOCOL=TCP) (SERVICE=backupdbXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/arch'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='SIMPLIFIED CHINESE'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/backupdb/udump'

将目标数据库的备份集传输到远端，这里我的目录结构是一致的 

[oracle@catalog orabackup]$ scp -r * oracle@192.168.106.162:/orabackup
The authenticity of host '192.168.106.162 (192.168.106.162)' can't be established.
RSA key fingerprint is a0:e4:b0:94:30:e4:20:56:00:12:c7:fa:48:9e:c8:d0.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.106.162' (RSA) to the list of known hosts.
oracle@192.168.106.162's password:
bkctl.ctl 100% 6944KB 6.8MB/s 00:00
inc0_BACKUPDB_01n70rvl_1_1 100% 5635KB 5.5MB/s 00:00
inc0_BACKUPDB_02n70rvn_1_1 100% 116MB 29.0MB/s 00:04
inc0_BACKUPDB_03n70s1e_1_1 100% 1072KB 1.1MB/s 00:00
inc0_BACKUPDB_04n70s1g_1_1 100% 3072 3.0KB/s 00:00

启动远端数据库到nomount状态 

[oracle@zhong ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 28 15:16:56 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SYS@backupdb:~>startup nomount
ORACLE instance started.Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
SYS@backupdb:~>


tnsnames.ora里配置好了网络服务名，在远端使用RMAN连接目标数据库,查看备份集，检查备份集状态

[oracle@zhong ~]$ rman target sys/oracle@target
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 28 15:48:21 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: BACKUPDB (DBID=4125018504)RMAN> list backupset summary;using target database control file instead of recovery catalogList of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A A DISK 28-MAR-12 1 1 YES INC0
2 B 0 A DISK 28-MAR-12 1 1 YES INC0
3 B 0 A DISK 28-MAR-12 1 1 YES INC0
4 B A A DISK 28-MAR-12 1 1 YES INC0
5 B F A DISK 28-MAR-12 1 1 NO BKCTLRMAN> crosscheck backupset;allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/inc0_BACKUPDB_01n70rvl_1_1 recid=1 stamp=779120630
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/inc0_BACKUPDB_02n70rvn_1_1 recid=2 stamp=779120631
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/inc0_BACKUPDB_03n70s1e_1_1 recid=3 stamp=779120687
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/inc0_BACKUPDB_04n70s1g_1_1 recid=4 stamp=779120689
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/orabackup/bkctl.ctl recid=5 stamp=779120691
Crosschecked 5 objects

然后连接到本机nomount状态的辅助数据库 

RMAN> connect auxiliary sys/oracle@backupdb;
connected to auxiliary database: BACKUPDB (not mounted)RMAN> list backupset by file;using target database control file instead of recovery catalogList of Datafile Backups
========================File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 2 B 0 A 555821 28-MAR-12 1 1 YES INC0
2 2 B 0 A 555821 28-MAR-12 1 1 YES INC0
3 2 B 0 A 555821 28-MAR-12 1 1 YES INC0
4 2 B 0 A 555821 28-MAR-12 1 1 YES INC0
5 2 B 0 A 555821 28-MAR-12 1 1 YES INC0
6 2 B 0 A 555821 28-MAR-12 1 1 YES INC0List of Archived Log Backups
============================Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 6 548132 28-MAR-12 1 A 1 1 YES INC0
1 7 555817 28-MAR-12 4 A 1 1 YES INC0List of Control File Backups
============================CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
555849 28-MAR-12 5 A 1 1 NO BKCTL
555839 28-MAR-12 3 A 1 1 YES INC0
List of SPFILE Backups
======================Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
26-MAR-12 3 A 1 1 YES INC0RMAN>

使用RMAN创建辅助数据库 

RMAN> connect auxiliary sys/oracle@backupdb;
connected to auxiliary database: BACKUPDB (not mounted)RMAN> run {
2> allocate auxiliary channel c1 device type disk;
3> duplicate target database to backupdb nofilenamecheck until logseq 8;
4> }using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=155 devtype=DISKStarting Duplicate Db at 28-MAR-12contents of Memory Script:
{
set until scn 555843;
set newname for datafile 1 to
"/u01/app/oracle/oradata/backupdb/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/backupdb/undotbs01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/backupdb/sysaux01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/backupdb/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/backupdb/example01.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/backupdb/catalog01.dbf";
restore
check readonly
clone database
;
}
executing Memory Scriptexecuting command: SET until clauseexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 28-MAR-12channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/backupdb/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/backupdb/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/backupdb/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/backupdb/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/backupdb/example01.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/backupdb/catalog01.dbf
channel c1: reading from backup piece /orabackup/inc0_BACKUPDB_02n70rvn_1_1
channel c1: restored backup piece 1
piece handle=/orabackup/inc0_BACKUPDB_02n70rvn_1_1 tag=INC0
channel c1: restore complete, elapsed time: 00:00:39
Finished restore at 28-MAR-12
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "BACKUPDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
'/u01/app/oracle/oradata/backupdb/system01.dbf'
CHARACTER SET ZHS16GBKcontents of Memory Script:
{
switch clone datafile all;
}
executing Memory Scriptdatafile 2 switched to datafile copy
input datafile copy recid=1 stamp=779126597 filename=/u01/app/oracle/oradata/backupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=779126597 filename=/u01/app/oracle/oradata/backupdb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=779126597 filename=/u01/app/oracle/oradata/backupdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=779126597 filename=/u01/app/oracle/oradata/backupdb/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=779126597 filename=/u01/app/oracle/oradata/backupdb/catalog01.dbfcontents of Memory Script:
{
set until scn 555843;
recover
clone database
delete archivelog
;
}
executing Memory Scriptexecuting command: SET until clauseStarting recover at 28-MAR-12starting media recoverychannel c1: starting archive log restore to default destination
channel c1: restoring archive log
archive log thread=1 sequence=7
channel c1: reading from backup piece /orabackup/inc0_BACKUPDB_04n70s1g_1_1
channel c1: restored backup piece 1
piece handle=/orabackup/inc0_BACKUPDB_04n70s1g_1_1 tag=INC0
channel c1: restore complete, elapsed time: 00:00:02
archive log filename=/arch/1_7_778974218.dbf thread=1 sequence=7
channel clone_default: deleting archive log(s)
archive log filename=/arch/1_7_778974218.dbf recid=1 stamp=779126599
media recovery complete, elapsed time: 00:00:01
Finished recover at 28-MAR-12contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Scriptdatabase dismounted
Oracle instance shut downconnected to auxiliary database (not started)
Oracle instance startedTotal System Global Area 285212672 bytesFixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "BACKUPDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 50 M ,
GROUP 2 SIZE 50 M ,
GROUP 3 SIZE 50 M
DATAFILE
'/u01/app/oracle/oradata/backupdb/system01.dbf'
CHARACTER SET ZHS16GBKcontents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/backupdb/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/backupdb/undotbs01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/backupdb/sysaux01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/backupdb/users01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/backupdb/example01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/backupdb/catalog01.dbf";
switch clone datafile all;
}
executing Memory Scriptexecuting command: SET NEWNAMErenamed temporary file 1 to /u01/app/oracle/oradata/backupdb/temp01.dbf in control filecataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/backupdb/undotbs01.dbf recid=1 stamp=779126606cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/backupdb/sysaux01.dbf recid=2 stamp=779126607cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/backupdb/users01.dbf recid=3 stamp=779126607cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/backupdb/example01.dbf recid=4 stamp=779126607cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/backupdb/catalog01.dbf recid=5 stamp=779126607datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=779126606 filename=/u01/app/oracle/oradata/backupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=779126607 filename=/u01/app/oracle/oradata/backupdb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=779126607 filename=/u01/app/oracle/oradata/backupdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=779126607 filename=/u01/app/oracle/oradata/backupdb/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=779126607 filename=/u01/app/oracle/oradata/backupdb/catalog01.dbfcontents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Scriptdatabase opened
Finished Duplicate Db at 28-MAR-12RMAN>

验证 

[oracle@zhong ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 28 16:06:33 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSYS@backupdb:~>select open_mode from v$database;OPEN_MODE
----------
READ WRITESYS@backupdb:~>select member from v$logfile;MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/flash_recovery_area/BACKUPDB/onlinelog/o1_mf_3_7q5kgjwh_.log
/u01/app/oracle/flash_recovery_area/BACKUPDB/onlinelog/o1_mf_2_7q5kghoy_.log
/u01/app/oracle/flash_recovery_area/BACKUPDB/onlinelog/o1_mf_1_7q5kghf5_.logSYS@backupdb:~>select count(*) from hr.employees;COUNT(*)
----------
107SYS@backupdb:~>


这篇关于Using RMAN duplicate Created Remote Auxiliary Database的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/666779。

相关文章

MySQL 删除数据详解(最新整理)

MySQL 删除数据详解(最新整理)

《MySQL删除数据详解(最新整理)》：本文主要介绍MySQL删除数据的相关知识,本文通过实例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友参考下吧... 目录一、前言二、mysql 中的三种删除方式1.DELETE语句✅ 基本语法： 示例：2.TRUNCATE语句✅ 基本语
阅读更多...
MySQL中查找重复值的实现

MySQL中查找重复值的实现

《MySQL中查找重复值的实现》查找重复值是一项常见需求,比如在数据清理、数据分析、数据质量检查等场景下,我们常常需要找出表中某列或多列的重复值,具有一定的参考价值,感兴趣的可以了解一下... 目录技术背景实现步骤方法一：使用GROUP BY和HAVING子句方法二：仅返回重复值方法三：返回完整记录方法四：
阅读更多...
从入门到精通MySQL联合查询

从入门到精通MySQL联合查询

《从入门到精通MySQL联合查询》：本文主要介绍从入门到精通MySQL联合查询,本文通过实例代码给大家介绍的非常详细,需要的朋友可以参考下... 目录摘要1. 多表联合查询时mysql内部原理2. 内连接3. 外连接4. 自连接5. 子查询6. 合并查询7. 插入查询结果摘要前面我们学习了数据库设计时要满
阅读更多...
MySQL查询JSON数组字段包含特定字符串的方法

MySQL查询JSON数组字段包含特定字符串的方法

《MySQL查询JSON数组字段包含特定字符串的方法》在MySQL数据库中,当某个字段存储的是JSON数组,需要查询数组中包含特定字符串的记录时传统的LIKE语句无法直接使用,下面小编就为大家介绍两种... 目录问题背景解决方案对比1. 精确匹配方案（推荐）2. 模糊匹配方案参数化查询示例使用场景建议性能优
阅读更多...
mysql表操作与查询功能详解

mysql表操作与查询功能详解

《mysql表操作与查询功能详解》本文系统讲解MySQL表操作与查询,涵盖创建、修改、复制表语法,基本查询结构及WHERE、GROUPBY等子句,本文结合实例代码给大家介绍的非常详细,感兴趣的朋友跟随... 目录01.表的操作1.1表操作概览1.2创建表1.3修改表1.4复制表02.基本查询操作2.1 SE
阅读更多...
MySQL中的锁机制详解之全局锁,表级锁,行级锁

MySQL中的锁机制详解之全局锁,表级锁,行级锁

《MySQL中的锁机制详解之全局锁,表级锁,行级锁》MySQL锁机制通过全局、表级、行级锁控制并发,保障数据一致性与隔离性,全局锁适用于全库备份,表级锁适合读多写少场景,行级锁(InnoDB)实现高并... 目录一、锁机制基础：从并发问题到锁分类1.1 并发访问的三大问题1.2 锁的核心作用1.3 锁粒度分
阅读更多...
MySQL数据库中ENUM的用法是什么详解

MySQL数据库中ENUM的用法是什么详解

《MySQL数据库中ENUM的用法是什么详解》ENUM是一个字符串对象,用于指定一组预定义的值,并可在创建表时使用,下面：本文主要介绍MySQL数据库中ENUM的用法是什么的相关资料,文中通过代码... 目录mysql 中 ENUM 的用法一、ENUM 的定义与语法二、ENUM 的特点三、ENUM 的用法1
阅读更多...
MySQL count()聚合函数详解

MySQL count()聚合函数详解

《MySQLcount()聚合函数详解》MySQL中的COUNT()函数,它是SQL中最常用的聚合函数之一,用于计算表中符合特定条件的行数,本文给大家介绍MySQLcount()聚合函数,感兴趣的朋... 目录核心功能语法形式重要特性与行为如何选择使用哪种形式？总结深入剖析一下 mysql 中的 COUNT
阅读更多...
mysql中的服务器架构详解

mysql中的服务器架构详解

《mysql中的服务器架构详解》：本文主要介绍mysql中的服务器架构,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录1、背景2、mysql服务器架构解释3、总结1、背景简单理解一下mysqphpl的服务器架构。2、mysjsql服务器架构解释mysql的架
阅读更多...
MySQL之InnoDB存储引擎中的索引用法及说明

MySQL之InnoDB存储引擎中的索引用法及说明

《MySQL之InnoDB存储引擎中的索引用法及说明》：本文主要介绍MySQL之InnoDB存储引擎中的索引用法及说明,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐... 目录1、背景2、准备3、正篇【1】存储用户记录的数据页【2】存储目录项记录的数据页【3】聚簇索引【4】二
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2