c. Create standby redologs alter database add standby logfile thread 1 '/u01/app/oracle/oradata/oradb/stdredo01.log' size 200m reuse; alter database add standby logfile thread 1 '/u01/app/oracle/oradata/oradb/st
duplicate target database for standby from active database; 1. 2. 3. 打开备库的pdb sqlplus / as sysdba shutdown immediate; startup alter pluggable database skedupdb open; alter session set container=SKEDUPDB; 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 检查测试: 检查datagu...
duplicate target database for standby from active database nofilenamecheck dorecover spfile parameter_value_convert 'xkdb','xkdg','+DATA','+DG_DATA','+CRS','+DG_REDO' set db_name='XKDB' set db_unique_name='xkdg' set db_create_file_dest='+DG_DATA' set db_create_online_log_dest_...
SQL> alter database add standby logfile '/ora/oracle/oradata/ORCL/standby_redo01.log' size 512M; SQL> alter database add standby logfile '/ora/oracle/oradata/ORCL/standby_redo02.log' size 512M; SQL> alter database add standby logfile '/ora/oracle/oradata/ORCL/standby_redo03.log' size...
alter database force logging; #打开数据库 alter database open; #查看归档 archive log list; #查看是否为强制日志 select force_logging from v$database; ---主添加standby日志文件--- #新增一组大小为200M的Standby Redo,这里的group号不得与Online redo重复 alter database add standby...
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200M; 1. 2. 3. 4. 1.1.3 设置主库参数 SQL> alter system set log_archive_config='dg_config=(cdb,cdb_stby)' scope=both; SQL> alter system set log_archive_dest_2='service=cdb_stby async valid_for=(online_logfile,primary_role) db_unique...
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER SPFILE SET db_unique_name='CDB1_STBY'COMMENT'Is standby'NOFILENAMECHECK; 命令完成后将显示如下所示的消息: 输出 media recovery complete, elapsed time: 00:00:00 Finished recover at 29-JUN-22 Finished Duplicate Db at 29-JUN-22...
这是整个Data Guard搭建过程中最核心、也最耗时的一步。我们使用RMAN的DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK SPFILE命令。为了方便管理和记录,我们将RMAN脚本写入了一个shell脚本rman_duplicate_mmdb.sh。 脚本的核心内容: ...
oracle19c使用dbca配置DG的命令在12.1.0.2之后,oracle就提供了使用dbca直接创建物理备库的方法The DBCA commandqualifier used to create the physical standby databaseis createDuplicateDB .DBCA can only be used to create standbydatabases for non-multitenant primary databases.In addition, this capability create...
(ORACLE_HOME= /oracle/app/oracle/19c) ) ) 3.密码文件 主: orapwdfile=orapwmtxdb entries=10password=P1ssW-rd force=y 备: orapwdfile=orapwmtxdg entries=10password=P2ssW-rd force=y 4.pfile: 主: alterdatabaseforce logging;altersystemsetdb_recovery_file_dest_size=5g;altersystemsetdb_recover...