rman target sys/oracle@PROD1 auxiliary sys/oracle@PROD2

最新推荐文章于 2022-04-28 15:42:09 发布
最新推荐文章于 2022-04-28 15:42:09 发布
阅读量3.8k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： ORACLE_DUPLICATE
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/u011616400/article/details/51083739
本文详细介绍使用Oracle RMAN工具进行数据库复制的过程，包括设置环境、复制步骤及注意事项等关键信息。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

[oracle@lucky ~]$ rman target sys/oracle@PROD1 auxiliary sys/oracle@PROD2


//1.When you connect RMAN to the source database as TARGET, you must specify a password, even if RMAN uses operating system authentication.
//2.The source database and auxiliary instances must use the same SYSDBA password, which means that both instances must have password files. You can create the password file with a single password so you can start the auxiliary instance and enable the source database to connect to it.



Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 7 10:30:22 2016


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


connected to target database: PROD1 (DBID=2129277974)
connected to auxiliary database: PROD2 (not mounted)


DUPLICATE TARGET DATABASE TO PROD2 FROM ACTIVE DATABASE
    DB_FILE_NAME_CONVERT ('u01/app/oracle/oradata/PROD1/','u01/app/oracle/oradata/PROD2/')
    LOGFILE
      GROUP 1 ('/u01/app/oracle/oradata/PROD2/redo01_1.f',
               '/u01/app/oracle/oradata/PROD2/redo01_2.f') SIZE 4M,
      GROUP 2 ('/u01/app/oracle/oradata/PROD2/redo02_1.f',
               '/u01/app/oracle/oradata/PROD2/redo02_2.f') SIZE 4M,
      GROUP 3 ('/u01/app/oracle/oradata/PROD2/redo03_1.f',

9>                '/u01/app/oracle/oradata/PROD2/redo03_2.f') SIZE 4M REUSE;


//DB_FILE_NAME_CONVERT可以在参数文件中指定，也可以在duplicate中指定
//LOG_FILE_NAME_CONVERT只能在参数文件中指定


//Duplication with Oracle Managed Files


If the source database files are in the Oracle Managed Files (OMF) format, then you cannot use the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT initialization parameters or the fileNameConversionSpec clause to generate new OMF file names for the duplicate database. If you do not follow this rule, the new OMF files generated from these three methods can cause problems. For more information on OMF names, see the "Considerations When Renaming OMF Auxiliary Set Files in TSPITR" in the Oracle Database Backup and Recovery User's Guide


The only exception to this rule is when changing only an ASM disk group name. Assume that source data files and online redo log files are stored in ASM disk group +SOURCEDSK. You want to store the duplicate database files in ASM disk group +DUPDSK. In this case, you can set the initialization parameters as follows:


DB_FILE_NAME_CONVERT = ("+SOURCEDSK","+DUPDSK")
LOG_FILE_NAME_CONVERT = ("+SOURCEDSK","+DUPDSK")
RMAN uses DB_FILE_NAME_CONVERT or LOG_FILE_NAME_CONVERT to convert the disk group name, and then generates a new, valid file name based on the converted disk group name.


You have the following other supported options for naming data files when the source files are in the Oracle Managed Files format:


Use SET NEWNAME to specify names for individual data files.


Set DB_FILE_CREATE_DEST to make all data files of the new database Oracle-managed files, except the files for which SET NEWNAME is used. You should not set DB_FILE_NAME_CONVERT if you set DB_FILE_CREATE_DEST.


Supported options for naming online redo logs duplicated from Oracle-managed files are DB_CREATE_FILE_DEST, DB_RECOVERY_FILE_DEST, or DB_CREATE_ONLINE_LOG_DEST_n.



Starting Duplicate Db at 07-APR-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=129 device type=DISK


contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''PROD1'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''PROD2'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliary format  '/u01/app/oracle/oradata/PROD2/control01.ctl';
   restore clone controlfile to  '/u01/app/oracle/oradata/PROD2/control02.ctl' from 
 '/u01/app/oracle/oradata/PROD2/control01.ctl';
   alter clone database mount;
}
executing Memory Script


sql statement: alter system set  db_name =  ''PROD1'' comment= ''Modified by RMAN duplicate'' scope=spfile


sql statement: alter system set  db_unique_name =  ''PROD2'' comment= ''Modified by RMAN duplicate'' scope=spfile


Oracle instance shut down


Oracle instance started


Total System Global Area    1068937216 bytes


Fixed Size                     2220200 bytes
Variable Size                616566616 bytes
Database Buffers             444596224 bytes
Redo Buffers                   5554176 bytes


Starting backup at 07-APR-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=71 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_PROD1.f tag=TAG20160407T103039 RECID=5 STAMP=908533839
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 07-APR-16


Starting restore at 07-APR-16
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=63 device type=DISK


channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 07-APR-16


database mounted


contents of Memory Script:
{
   set newname for datafile  1 to 
 "/u01/app/oracle/oradata/PROD2/system01.dbf";
   set newname for datafile  2 to 
 "/u01/app/oracle/oradata/PROD2/sysaux01.dbf";
   set newname for datafile  3 to 
 "/u01/app/oracle/oradata/PROD2/undotbs01.dbf";
   set newname for datafile  4 to 
 "/u01/app/oracle/oradata/PROD2/USERS.DBF";
   set newname for datafile  5 to 
 "/u01/app/oracle/oradata/PROD2/INDX.DBF";
   set newname for datafile  6 to 
 "/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF";
   set newname for datafile  7 to 
 "/u01/app/oracle/oradata/PROD2/OLTP.DBF";
   set newname for datafile  8 to 
 "/u01/app/oracle/oradata/PROD2/BATCH.DBF";
   backup as copy reuse
   datafile  1 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/system01.dbf"   datafile 
 2 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/sysaux01.dbf"   datafile 
 3 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/undotbs01.dbf"   datafile 
 4 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/USERS.DBF"   datafile 
 5 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/INDX.DBF"   datafile 
 6 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF"   datafile 
 7 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/OLTP.DBF"   datafile 
 8 auxiliary format 
 "/u01/app/oracle/oradata/PROD2/BATCH.DBF"   ;
   sql 'alter system archive log current';
}
executing Memory Script


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


Starting backup at 07-APR-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/PROD1/EXAMPLE.DBF
output file name=/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbf
output file name=/u01/app/oracle/oradata/PROD2/system01.dbf tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/sysaux01.dbf
output file name=/u01/app/oracle/oradata/PROD2/sysaux01.dbf tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/undotbs01.dbf
output file name=/u01/app/oracle/oradata/PROD2/undotbs01.dbf tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/u01/app/oracle/oradata/PROD1/BATCH.DBF
output file name=/u01/app/oracle/oradata/PROD2/BATCH.DBF tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/PROD1/USERS.DBF
output file name=/u01/app/oracle/oradata/PROD2/USERS.DBF tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/PROD1/OLTP.DBF
output file name=/u01/app/oracle/oradata/PROD2/OLTP.DBF tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/PROD1/INDX.DBF
output file name=/u01/app/oracle/oradata/PROD2/INDX.DBF tag=TAG20160407T103046
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 07-APR-16


sql statement: alter system archive log current


contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/u01/app/oracle/flash_recovery_area/PROD1/archivelog/2016_04_07/o1_mf_1_15_cjckmt5d_.arc" auxiliary format 
 "/u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_%u_.arc"   ;
   catalog clone recovery area;
   switch clone datafile all;
}
executing Memory Script


Starting backup at 07-APR-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=15 RECID=7 STAMP=908533882
output file name=/u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_2jr2e83q_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 07-APR-16


searching for all files in the recovery area


List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_14_29r2e805_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_13_1vr2e51c_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_12_1lr2e440_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_2jr2e83q_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_11_1br2e3i8_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_06/o1_mf_1_8_cj9mx7h1_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/flashback/o1_mf_cj9mfzx5_.flb
cataloging files...
cataloging done


List of Cataloged Files
=======================
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_14_29r2e805_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_13_1vr2e51c_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_12_1lr2e440_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_2jr2e83q_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_11_1br2e3i8_.arc
File Name: /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_06/o1_mf_1_8_cj9mx7h1_.arc


List of Files Which Where Not Cataloged
=======================================
File Name: /u01/app/oracle/flash_recovery_area/PROD2/flashback/o1_mf_cj9mfzx5_.flb
  RMAN-07518: Reason: Foreign database file DBID: 1560297317  Database Name: PROD2


datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/USERS.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/INDX.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=10 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=11 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/OLTP.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=12 STAMP=908533883 file name=/u01/app/oracle/oradata/PROD2/BATCH.DBF


contents of Memory Script:
{
   set until scn  353161;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script


executing command: SET until clause


Starting recover at 07-APR-16
using channel ORA_AUX_DISK_1


starting media recovery


archived log for thread 1 with sequence 15 is already on disk as file /u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_2jr2e83q_.arc
archived log file name=/u01/app/oracle/flash_recovery_area/PROD2/archivelog/2016_04_07/o1_mf_1_15_2jr2e83q_.arc thread=1 sequence=15
media recovery complete, elapsed time: 00:00:00
Finished recover at 07-APR-16


contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
   sql clone "alter system set  db_name = 
 ''PROD2'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script


database dismounted
Oracle instance shut down


connected to auxiliary database (not started)
Oracle instance started


Total System Global Area    1068937216 bytes


Fixed Size                     2220200 bytes
Variable Size                616566616 bytes
Database Buffers             444596224 bytes
Redo Buffers                   5554176 bytes


sql statement: alter system set  db_name =  ''PROD2'' comment= ''Reset to original value by RMAN'' scope=spfile


sql statement: alter system reset  db_unique_name scope=spfile


Oracle instance shut down


connected to auxiliary database (not started)
Oracle instance started


Total System Global Area    1068937216 bytes


Fixed Size                     2220200 bytes
Variable Size                616566616 bytes
Database Buffers             444596224 bytes
Redo Buffers                   5554176 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PROD2" RESETLOGS ARCHIVELOG 
  MAXLOGFILES      5
  MAXLOGMEMBERS      5
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( '/u01/app/oracle/oradata/PROD2/redo01_1.f', '/u01/app/oracle/oradata/PROD2/redo01_2.f' ) SIZE 4 M ,
  GROUP  2 ( '/u01/app/oracle/oradata/PROD2/redo02_1.f', '/u01/app/oracle/oradata/PROD2/redo02_2.f' ) SIZE 4 M ,
  GROUP  3 ( '/u01/app/oracle/oradata/PROD2/redo03_1.f', '/u01/app/oracle/oradata/PROD2/redo03_2.f' ) SIZE 4 M  REUSE
 DATAFILE
  '/u01/app/oracle/oradata/PROD2/system01.dbf'
 CHARACTER SET AL32UTF8




contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/u01/app/oracle/oradata/PROD2/temp01.dbf";
   set newname for tempfile  2 to 
 "/u01/app/oracle/oradata/PROD2/TMP1_01_GRP.DBF";
   set newname for tempfile  3 to 
 "/u01/app/oracle/oradata/PROD2/TMP2_01_GRP.DBF";
   set newname for tempfile  4 to 
 "/u01/app/oracle/oradata/PROD2/TMP3_01_GRP.DBF";
   switch clone tempfile all;
   catalog clone datafilecopy  "/u01/app/oracle/oradata/PROD2/sysaux01.dbf", 
 "/u01/app/oracle/oradata/PROD2/undotbs01.dbf", 
 "/u01/app/oracle/oradata/PROD2/USERS.DBF", 
 "/u01/app/oracle/oradata/PROD2/INDX.DBF", 
 "/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF", 
 "/u01/app/oracle/oradata/PROD2/OLTP.DBF", 
 "/u01/app/oracle/oradata/PROD2/BATCH.DBF";
   switch clone datafile all;
}
executing Memory Script


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


executing command: SET NEWNAME


renamed tempfile 1 to /u01/app/oracle/oradata/PROD2/temp01.dbf in control file
renamed tempfile 2 to /u01/app/oracle/oradata/PROD2/TMP1_01_GRP.DBF in control file
renamed tempfile 3 to /u01/app/oracle/oradata/PROD2/TMP2_01_GRP.DBF in control file
renamed tempfile 4 to /u01/app/oracle/oradata/PROD2/TMP3_01_GRP.DBF in control file


cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/sysaux01.dbf RECID=1 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/undotbs01.dbf RECID=2 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/USERS.DBF RECID=3 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/INDX.DBF RECID=4 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF RECID=5 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/OLTP.DBF RECID=6 STAMP=908533900
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/PROD2/BATCH.DBF RECID=7 STAMP=908533900


datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/USERS.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/INDX.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/EXAMPLE.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/OLTP.DBF
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=908533900 file name=/u01/app/oracle/oradata/PROD2/BATCH.DBF


contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script


database opened
Finished Duplicate Db at 07-APR-16


RMAN> 
【Oracle】Oracle rman工具使用（真的细）
tttzzzqqq2018的博客
09-19 7458
Oracle RMAN（Recovery Manager）是Oracle数据库备份和恢复的官方工具，它提供的备份和恢复功能非常强大和可靠。RMAN可以备份整个数据库或特定表空间、数据文件、控制文件和归档日志，同时还可以进行增量备份和增量恢复。RMAN还提供了诸如备份验证、备份优化、备份复制、备份集管理、恢复操作、自动备份、自动恢复等高级功能。它使用的备份和恢复格式是Oracle通用的备份集（Backup Set），这使得备份和恢复非常灵活和高效。
Oracle OCP 19c 认证1Z0-083考试(第71-80题) - #宝，输了液
#真题在线#
06-18 1873
==本真题，100%有效， Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connec.
RMAN利用auxiliary复制数据库
热门推荐
孔老先生的博客
07-21 1万+
这个是经理给的一份复制备份计划，只需要利用rman智能管理复制，无需手工操作。关键字是auxiliary，在rman中使用到，其实不是什么技术名称。操作过程整理及错误收集如下。 1 在主库上备份数据库 RMAN> backup database plus archivelog; 2 把备份片scp到目标库，路径同原库一样 scp /home/oracle/rmanbk/VI
rman auxiliary
wish503的博客
11-06 1493
目的，将oracle库TESTA的数据覆盖TESTB库。 1源端和目标端重建密码文件 TESTA: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID  password=test1234 force=y TESTB: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID  password=te
oracle rman catalogo,Oracle rman 命令总结
weixin_42524945的博客
04-03 132
--登录rmanrman target /rman target sys/passworkrman target sys/passwork nocatalog (控制文件方式)rman target sys/passwork catalog (恢复目录方式)--查看参数show all--修改保存天数用sqlplus修改备份信息在控制文件中保留的天数show parameter con...
RMAN客户端使用介绍
jetliu05的博客
04-28 3052
rman client使用介绍
命令行使用oracle19c_【Oracle19c】Oracle19c rman使用简单测试
weixin_35146121的博客
01-13 1371
### 本次我们主要一起学习rman相关使用，包含复制，迁移---##### 19c新特性- PDB 支持 资料库```--连接示例connect target "sbu@prod AS SYSBACKUP"```- 自动删除闪回日志```--默认1440分钟/一天，19c开始超过自动清理db_flashback_retention_target```##### 18C新特性- 复制一个pdb到另...
Oracle 数据迁移
qq_41141058的博客
07-16 1232
一、数据迁移课程概述 Oracle 跨平台跨版本数据迁移 停机时间 100G 4小时，20TB 2小时 数据量 数据库版本11.2.0.1 11.2.0.4 操作系统平台 win->linux,aix->linux,hpxu->linux 字节序 大端还是小端 x86 合适的迁移技术 数据迁移技术: dataguard RMAN异机恢复 exp/imp、expdp/impdp...
oracle rman
04-22
- **同时连接到目标数据库和恢复目录**：`rman target sys/secret@prod catalog dba/secret@catlog` #### 四、执行命令 RMAN提供了丰富的命令集，可用于执行各种备份和恢复任务。这些命令大致分为几类： - **备份...
oracle 基于备份 duplicate 没有目标连接,RMAN 概述及其体系结构
weixin_26805597的博客
04-05 264
--=========================-- RMAN概述及其体系结构--=========================一、Recovery Manager(RMAN)特性是一种用于集备份(backup)、还原(restore)和恢复(recover)数据库于一体的Oracle工具，支持命令行及图形界面操作能够备份整个数据库、表空间、数据文件、控制文件、归档文件以及Spfile参...
RAC +DG
上帝之手&传奇 - MartinLee
09-13 3141
此测试实验为 RAC 数据源 + 单实例 node 目标端。RAC 为 asm 存储， node 为systemfile系统。 其实都一样，和node+node: 1 环境： RAC : DB_NAME= DB_UNIQUE_NAME=DOMINIC                            NODE: DB_NAME= DOMINIC              
rman target sys/111111@orcl auxiliary sys/111111@aux
Perry
10-24 937
[oracle@lucky admin]$ rman target /  auxiliary sys/111111@aux Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 13 15:05:37 2014 Copyright (c) 1982, 2009, Oracle and/or its affili
DG搭建之巧用RMAN进行主备库数据迁移
05-08 356
我们在搭建DG（data guard）的时候，你的数据时如何从主库到达备库的？使用热备的方式么？再用scp命令拷贝过去？啊！那你就OUT了！告诉你一个秘密，我使用rman工...
Oracle16——认识并使用RMAN
weixin_38400733的博客
03-30 547
1-请分别写出数据文件、日志文件、控制文件的后缀名、本机存放路径、92数据库存放路径、各自的作用？ 2-写出:启动RMAN的步骤… 3-手画 RMAN会话与服务器进程通信的图… 手画 不是excel或者截图！！！ 4-[RMAN工具简介] cuschannel 手敲代码并加注释… 5-[使用RMAN工具备份] RMAN备份策略：请收索详细备份原理… 6-[使用RMAN工具备份] backupdb...
rman异机duplicate active数据库
tempsitegoogle
06-21 168
实验环境： 源数据库服务器名：beijing 数据库全局名和SID：orcl 辅助数据库:suzhou 只安装数据库软件，没有新建数据库 在辅助服务器suzhou上复制一个例程名和数据库名都是bj的数据库. ---------------------------------------------------------------- 步骤如下： （1）辅助数据库服务器...
rman恢复system表空间
Baron_ccy
06-15 737
本文描述：模拟恢复system表空间丢失并恢复的过程 试验如下: (1)连接sqlplus，并创建一张表 C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期二 6月 13 16:12:50 2017 Copyright (c) 1982, 2010, Oracle
oracle dg安装,oracle物理dg安装：方法二
weixin_36397256的博客
04-09 464
本文记录了物理dg的第二种安装方法，使用rmanduplicatefrom active database，不需要做备份文件。准备工作：1.两台虚拟机，主机名：n1, n2，操作系统：centos6.7，建好信任关系2.oracle database 11.2.0.4软件已装好3.节点1(n1)数据库创建好，db_name=orcl，db_unique_name=dg1，归档模式(归档目录/o...
oracle连接 登陆,RMAN登陆及连接target数据库的步骤方法
weixin_31312621的博客
04-03 986
一、方法一：a)[oracle@odd-oelr4u8~]$ rman target sys/oracle@PROD1521 catalogcatalog_admin/catalog_admin@PROD21521b)c)RecoveryManager: Release 10.2.0.1.0 - Production on Mon Jan 20 07:56:30 2014d)e)Copyright...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值