GVKun编程网logo

在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本(mac docker安装部署)

17

本文的目的是介绍在Mac上通过Docker部署OracleDatabase11.2.0版本的详细情况,特别关注macdocker安装部署的相关信息。我们将通过专业的研究、有关数据的分析等多种方式,为您

本文的目的是介绍在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本的详细情况,特别关注mac docker安装部署的相关信息。我们将通过专业的研究、有关数据的分析等多种方式,为您呈现一个全面的了解在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本的机会,同时也不会遗漏关于68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database、73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO、78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R、81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,的知识。

本文目录一览:

在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本(mac docker安装部署)

在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本(mac docker安装部署)

一、首先要做的是准备工作,备好需要的软件,安装 Docker 环境,这些极其简单。

下载一个 Docker 的稳定版本,『Docker Community Edition for Mac』即可:

以下链接:

https://store.docker.com/editions/community/docker-ce-desktop-mac

选择稳定版本:

https://download.docker.com/mac/stable/Docker.dmg

二、在 Github 上下载 Oracle 的 Docker Image 文件(下载之后的文件是 docker-images-master.zip ):

https://github.com/oracle/docker-images

三、在 oracel 官网下载 oracle 的镜像,下载的文件名:oracle-xe-11.2.0-1.0.x86_64.rpm.zip

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

 

四、解压 dock-images-master 并准备 oracle 文件

unzip docker-images-master.zip
mv oracle-xe-11.2.0-1.0.x86_64.rpm.zip docker-images-master/OracleDatabase/SingleInstance/dockerfiles/11.2.0.2/

五、构建数据库的镜像

docker-images-master/OracleDatabase/SingleInstance/dockerfiles/buildDockerImage.sh -v 11.2.0.2 -x

六、启动 oracle 镜像

1、运行 oracle

docker run --name oracle --shm-size=1GB -p 1521:1521 -p 5500:5500 -v /Users/oracle/u02/oradata:/opt/oracle/oradata oracle/database:11.2.0.2-xe

这个命令有几个主要参数:-p 指定端口映射,主机到 Docker 的端口对应;-shm-size:/dev/shm 的大小,不指定,默认是 64M,会报错。-v 指定数据库的对应存储路径,我指定了一个 Docker 之外的本地存储,将数据库独立出来。

完成这个命令,会在本地完成数据库的构建并启动数据库,同时输出告警日志的监控。

2、开启 oracle

docker container start <container_id>

3、修改数据库缺省的口令

docker exec oracle ./setPassword.sh youpassword

4、其他命令:

docker start oracle

docker stop oracle

docker logs oracle

docker ps

七、下载 sql-developer

    http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 

八、进入 sqlplus 界面

    docker exec -ti oracle sqlplus /nolog

68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database

68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database

68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task? A.Multiplex all database files. B.Configure the Flash Recovery Area. C.Configure the database instance for ARCHIVELOG mode. D.Configure the FAST_START_MTTR_TARGET initialization parameter. 答案:C 解析:这个说是恢复到错误发生的时间点,这个相当于不完全恢复,不完全恢复的先觉条件是@R_301_6250@处于归档模式 当@R_301_6250@设置为归档模式之后对@R_301_6250@意味着 1.当@R_301_6250@(磁盘或系统文件问题所导致的)崩溃之后,所有提交的数据都能恢复 2.可以对@R_301_6250@进行联机备份,而且在联机备份期间可以继续进行其他的操作 3.当某一非系统表空间脱机时,@R_301_6250@的其他部分继续正常工作 4.可以进行如下的不完全恢复 a.恢复到某一特定的时间点 b.恢复到某一特定的scn号 c.恢复到某一特定的归档文件的结尾

73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO

73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO

73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.) A.You must shut down the database instance to perform the backups. B.You must configure the Flash Recovery Area (FRA) for the database. C.You can perform complete database backups without closing the database. D.All the prevIoUs closed database backups including control files become invalid after you configure the database to ARCHIVELOG mode. 答案:CD 解析: A.归档模式后,备份不需要关闭数据库,属于热备,因此A是错误的,当然也可以关闭进行一致性备份,但不是必须关闭数据库 B.fra默认路径为$ORACLE_BASE/fast_recovery_area,不需要费的配置,因此B也是错误的 C.正确,备份的时候,是备份了一个点,然后通过归档日志执行前滚实现了完全备份 D.正确,当打开归档后 sql> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 77 Next log sequence to archive 77 Current log sequence 79 这里的Current log sequence将会被重置为1,也就是之前的都变成了invalid

78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R

78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R

78.You are managing an Oracle Database 11g database. The database is open,and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.) A.The backups would be consistent. B.The backups would be inconsistent. C.The backups would be possible only if the database is running in ARCHIVELOG mode. D.The backups would be possible only if the database is running in NOARCHIVELOG mode. E.The backups need to be restored and the database has to be recovered in case of a media failure. 答案:BCE 解析:只要是open状态进行备份的都是不一致备份排除A rman在非归档模式下执行进行脱机备份也就是冷备,因此排除D E说的是介质有问题了,备份必须restore然后recovered,这里说一下restore和recover的区别 restore:从备份位置还原一个或者多个数据库文件 recover:应用归档和联机重做日志文件,将整个数据库或单独数据库文件前滚到指定的scn 这就是归档文件的作用,当执行备份的时候,只是备份到一个点的数据,但是在备份之后这段时间执行的数据,就需要 通过recover利用归档日志,来进行前滚实现,因此需要这两步

81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,

81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,

81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,level 0 backup is performed. - On Monday night and subsequent days,level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday's backup is true? A.The backup contains all the used blocks. B.The backup contains all the used and unused blocks. C.The backup contains blocks that have changed since the last level 0 backup. D.The backup contains blocks that have changed since the last level 1 backup taken last week. 答案:C 解析:参考80题,这个是1级Incremental Differential 备份,由于周日是0级,因此周1应该在周日的基础上进行 备份,选择C

关于在 Mac 上通过 Docker 部署 Oracle Database 11.2.0 版本mac docker安装部署的介绍现已完结,谢谢您的耐心阅读,如果想了解更多关于68.You are managing an Oracle Database 11g database. You want to ensure the recovery of the database、73.You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELO、78.You are managing an Oracle Database 11g database. The database is open, and you plan to perform R、81.You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night,的相关知识,请在本站寻找。

本文标签: