oracle标准版备份数据,Oracle 11g 利用备份复制数据库

最新推荐文章于 2021-04-11 03:11:14 发布
最新推荐文章于 2021-04-11 03:11:14 发布
阅读量228 收藏
点赞数
文章标签： oracle标准版备份数据

测试在同一机器不同数据库实例复制数据库

1.环境

Target DB:

IP:10.131.119.114

HOSTNAME:openstack-node1.example.com

ORACLE_SID:orcl11g

Auxiliary DB:

IP:10.131.119.114

HOSTNAME:openstack-node1.example.com

ORACLE_SID:aux

2.创建Auxiliary DB 参数文件

[oracle@openstack-node1 dbs]$ cat initaux.ora

*.audit_file_dest='/u2/oracle/admin/aux/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u2/oracle/oradata/aux/control01.ctl','/u2/oracle/fast_recovery_area/aux/control02.ctl'

*.db_block_size=8192

*.db_domain='us.oracle.com'

*.db_name='aux'

*.db_recovery_file_dest='/u2/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4227858432

*.diagnostic_dest='/u2/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=auxXDB)'

*.log_archive_dest_1='location=/u2/oracle/arch/aux'

*.open_cursors=300

*.pga_aggregate_target=104857600

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_max_size=272629760

*.sga_target=272629760

*.undo_tablespace='UNDOTBS1'

*.db_file_name_convert=('orcl11g','aux')

3.创建Auxiliary DB需要的目录

[oracle@openstack-node1 ~]$ mkdir -p /u2/oracle/admin/aux/adump

[oracle@openstack-node1 ~]$ mkdir -p /u2/oracle/oradata/aux

[oracle@openstack-node1 ~]$ mkdir -p /u2/oracle/fast_recovery_area/aux

[oracle@openstack-node1 ~]$ mkdir -p /u2/oracle/arch/aux

4.创建Auxiliary DB密码文件[oracle@openstack-node1 dbs]$ cp orapworcl11g orapwaux

5.配置监听与TNS

监听：

[oracle@openstack-node1 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u2/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl11g)

(ORACLE_HOME = /u2/oracle/product/11.2.0/dbhome_1)

(SID_NAME = orcl11g)

)

(SID_DESC =

(GLOBAL_DBNAME = aux)

(ORACLE_HOME = /u2/oracle/product/11.2.0/dbhome_1)

(SID_NAME = aux)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.119.114)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /u2/oracle

TNS：

[oracle@openstack-node1 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u2/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL11G =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.119.114)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl11g)

)

)

aux =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.131.119.114)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = aux)

)

)

6.开始复制操作

[oracle@openstack-node1 ~]$ rman target /   ----连接target DB

Recovery Manager: Release 11.2.0.2.0 - Production on Thu Jan 14 11:33:21 2016

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

connected to target database: ORCL11G (DBID=1007320894)

RMAN> backup database plus archivelog;    ----备份数据库与日志

Starting backup at 14-JAN-16

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=2 RECID=1 STAMP=900437233

input archived log thread=1 sequence=3 RECID=2 STAMP=900482409

input archived log thread=1 sequence=4 RECID=3 STAMP=900541603

input archived log thread=1 sequence=5 RECID=4 STAMP=900597615

input archived log thread=1 sequence=6 RECID=5 STAMP=900655218

input archived log thread=1 sequence=7 RECID=6 STAMP=900684500

input archived log thread=1 sequence=8 RECID=7 STAMP=900734434

input archived log thread=1 sequence=9 RECID=8 STAMP=900770943

input archived log thread=1 sequence=10 RECID=9 STAMP=900813623

input archived log thread=1 sequence=11 RECID=10 STAMP=900885622

input archived log thread=1 sequence=12 RECID=11 STAMP=900950581

input archived log thread=1 sequence=13 RECID=12 STAMP=900982859

input archived log thread=1 sequence=14 RECID=13 STAMP=901058420

input archived log thread=1 sequence=15 RECID=14 STAMP=901101608

input archived log thread=1 sequence=16 RECID=15 STAMP=901102699

input archived log thread=1 sequence=17 RECID=16 STAMP=901102770

input archived log thread=1 sequence=18 RECID=17 STAMP=901107986

channel ORA_DISK_1: starting piece 1 at 14-JAN-16

channel ORA_DISK_1: finished piece 1 at 14-JAN-16

piece handle=/u2/oracle/fast_recovery_area/ORCL11G/backupset/2016_01_14/o1_mf_annnn_TAG20160114T114626_c9g6jlyk_.bkp tag=TAG20160114T114626 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

Finished backup at 14-JAN-16

Starting backup at 14-JAN-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u2/oracle/oradata/orcl11g/system01.dbf

input datafile file number=00002 name=/u2/oracle/oradata/orcl11g/sysaux01.dbf

input datafile file number=00005 name=/u2/oracle/oradata/orcl11g/tom01.dbf

input datafile file number=00003 name=/u2/oracle/oradata/orcl11g/undotbs01.dbf

input datafile file number=00004 name=/u2/oracle/oradata/orcl11g/users01.dbf

channel ORA_DISK_1: starting piece 1 at 14-JAN-16

channel ORA_DISK_1: finished piece 1 at 14-JAN-16

piece handle=/u2/oracle/fast_recovery_area/ORCL11G/backupset/2016_01_14/o1_mf_nnndf_TAG20160114T114712_c9g6l0l2_.bkp tag=TAG20160114T114712 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15

Finished backup at 14-JAN-16

Starting backup at 14-JAN-16

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=1 sequence=19 RECID=18 STAMP=901108107

channel ORA_DISK_1: starting piece 1 at 14-JAN-16

channel ORA_DISK_1: finished piece 1 at 14-JAN-16

piece handle=/u2/oracle/fast_recovery_area/ORCL11G/backupset/2016_01_14/o1_mf_annnn_TAG20160114T114827_c9g6ncw6_.bkp tag=TAG20160114T114827 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 14-JAN-16

Starting Control File and SPFILE Autobackup at 14-JAN-16

piece handle=/u2/oracle/fast_recovery_area/ORCL11G/autobackup/2016_01_14/o1_mf_s_901108109_c9g6nffq_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 14-JAN-16

RMAN> connect auxiliary sys/oracle@aux      ----连接auxiliary DB

connected to auxiliary database: AUX (not mounted)

RMAN> duplicate target database to aux      ----开始复制

2> pfile=/u2/oracle/product/11.2.0/dbhome_1/dbs/initaux.ora

3> logfile

4> '/u2/oracle/oradata/aux/redo01.dbf' size 50M,

5> '/u2/oracle/oradata/aux/redo02.dbf' size 50M,

6> '/u2/oracle/oradata/aux/redo03.dbf' size 50M;

Starting Duplicate Db at 14-JAN-16

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=125 device type=DISK

contents of Memory Script:

{

sql clone "create spfile from memory";

}

executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:

{

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area     271400960 bytes

Fixed Size                     2225672 bytes

Variable Size                109054456 bytes

Database Buffers             155189248 bytes

Redo Buffers                   4931584 bytes

contents of Memory Script:

{

sql clone "alter system set  db_name =

''ORCL11G'' comment=

''Modified by RMAN duplicate'' scope=spfile";

sql clone "alter system set  db_unique_name =

''AUX'' comment=

''Modified by RMAN duplicate'' scope=spfile";

shutdown clone immediate;

startup clone force nomount

restore clone primary controlfile;

alter clone database mount;

}

executing Memory Script

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area     271400960 bytes

Fixed Size                     2225672 bytes

Variable Size                109054456 bytes

Database Buffers             155189248 bytes

Redo Buffers                   4931584 bytes

Starting restore at 14-JAN-16

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=133 device type=DISK

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: restoring control file

channel ORA_AUX_DISK_1: reading from backup piece /u2/oracle/fast_recovery_area/ORCL11G/autobackup/2016_01_14/o1_mf_s_901108109_c9g6nffq_.bkp

channel ORA_AUX_DISK_1: piece handle=/u2/oracle/fast_recovery_area/ORCL11G/autobackup/2016_01_14/o1_mf_s_901108109_c9g6nffq_.bkp tag=TAG20160114T114828

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u2/oracle/oradata/aux/control01.ctl

output file name=/u2/oracle/fast_recovery_area/aux/control02.ctl

Finished restore at 14-JAN-16

database mounted

contents of Memory Script:

{

set until scn  1404181;

set newname for datafile  1 to

"/u2/oracle/oradata/aux/system01.dbf";

set newname for datafile  2 to

"/u2/oracle/oradata/aux/sysaux01.dbf";

set newname for datafile  3 to

"/u2/oracle/oradata/aux/undotbs01.dbf";

set newname for datafile  4 to

"/u2/oracle/oradata/aux/users01.dbf";

set newname for datafile  5 to

"/u2/oracle/oradata/aux/tom01.dbf";

restore

clone database

;

}

executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-JAN-16

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /u2/oracle/oradata/aux/system01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /u2/oracle/oradata/aux/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /u2/oracle/oradata/aux/undotbs01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /u2/oracle/oradata/aux/users01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /u2/oracle/oradata/aux/tom01.dbf

channel ORA_AUX_DISK_1: reading from backup piece/u2/oracle/fast_recovery_area/ORCL11G/backupset/2016_01_14/o1_mf_nnndf_TAG20160114T114712_c9g6l0l2_.bkp

channel ORA_AUX_DISK_1: piece handle=/u2/oracle/fast_recovery_area/ORCL11G/backupset/2016_01_14/o1_mf_nnndf_TAG20160114T114712_c9g6l0l2_.bkp tag=TAG20160114T114712

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15

Finished restore at 14-JAN-16

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=6 STAMP=901108249 file name=/u2/oracle/oradata/aux/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=7 STAMP=901108249 file name=/u2/oracle/oradata/aux/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=8 STAMP=901108249 file name=/u2/oracle/oradata/aux/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=9 STAMP=901108249 file name=/u2/oracle/oradata/aux/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=10 STAMP=901108249 file name=/u2/oracle/oradata/aux/tom01.dbf

contents of Memory Script:

{

set until scn  1404181;

recover

clone database

delete archivelog

;

}

executing Memory Script

executing command: SET until clause

Starting recover at 14-JAN-16

using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 19 is already on disk as file /u2/oracle/arch/1_19_900436609.dbf

archived log file name=/u2/oracle/arch/1_19_900436609.dbf thread=1 sequence=19

media recovery complete, elapsed time: 00:00:01

Finished recover at 14-JAN-16

Oracle instance started

Total System Global Area     271400960 bytes

Fixed Size                     2225672 bytes

Variable Size                104860152 bytes

Database Buffers             159383552 bytes

Redo Buffers                   4931584 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUX" RESETLOGS ARCHIVELOG

MAXLOGFILES     16

MAXLOGMEMBERS      3

MAXDATAFILES      100

MAXINSTANCES     8

MAXLOGHISTORY      292

LOGFILE

GROUP  1 '/u2/oracle/oradata/aux/redo01.dbf' SIZE 50 M ,

GROUP  2 '/u2/oracle/oradata/aux/redo02.dbf' SIZE 50 M ,

GROUP  3 '/u2/oracle/oradata/aux/redo03.dbf' SIZE 50 M

DATAFILE

'/u2/oracle/oradata/aux/system01.dbf'

CHARACTER SET WE8MSWIN1252

contents of Memory Script:

{

set newname for tempfile  1 to

"/u2/oracle/oradata/aux/temp01.dbf";

switch clone tempfile all;

catalog clone datafilecopy  "/u2/oracle/oradata/aux/sysaux01.dbf",

"/u2/oracle/oradata/aux/undotbs01.dbf",

"/u2/oracle/oradata/aux/users01.dbf",

"/u2/oracle/oradata/aux/tom01.dbf";

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u2/oracle/oradata/aux/temp01.dbf in control file

cataloged datafile copy

datafile copy file name=/u2/oracle/oradata/aux/sysaux01.dbf RECID=1 STAMP=901108255

cataloged datafile copy

datafile copy file name=/u2/oracle/oradata/aux/undotbs01.dbf RECID=2 STAMP=901108255

cataloged datafile copy

datafile copy file name=/u2/oracle/oradata/aux/users01.dbf RECID=3 STAMP=901108255

cataloged datafile copy

datafile copy file name=/u2/oracle/oradata/aux/tom01.dbf RECID=4 STAMP=901108255

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=901108255 file name=/u2/oracle/oradata/aux/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=901108255 file name=/u2/oracle/oradata/aux/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=901108255 file name=/u2/oracle/oradata/aux/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=901108255 file name=/u2/oracle/oradata/aux/tom01.dbf

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 14-JAN-16

7.检查auxiliary DB

[oracle@openstack-node1 ~]$ export ORACLE_SID=aux

[oracle@openstack-node1 ~]$ echo $ORACLE_SID

aux

[oracle@openstack-node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 14 14:15:36 2016

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u2/oracle/oradata/aux/system01.dbf

/u2/oracle/oradata/aux/sysaux01.dbf

/u2/oracle/oradata/aux/undotbs01.dbf

/u2/oracle/oradata/aux/users01.dbf

/u2/oracle/oradata/aux/tom01.dbf

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL> show parameter name;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert                 string      orcl11g, aux

db_name                              string      aux

db_unique_name                       string      aux

global_names                         boolean     FALSE

instance_name                        string      aux

lock_name_space                      string

log_file_name_convert                string

service_names                        string      aux.us.oracle.com

烧麦Van
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Database 11G RMAN 连接数据库
怀旧豆酱味的专栏
05-16 438
Oracle Database 11G RMAN 连接数据库Before you beginAbout this taskPrecedureResultExampleWhat to do nextReference Before you begin 已安装 Oracle 11G Database. About this task 对 Oracle 11G Database 进行 RMAN 的连接 ...
Oracle11g数据库基础教程课后习题答案.doc
11-13
1. Oracle 11g 数据库服务器分类：企业版、标准版和个人版数据库服务器。企业版数据库服务器包含所有的数据库组件，主要针对高端的应用环境；标准版数据库服务器提供大部分核心的数据库功能和特性，适合于工作组或...
oracle 测试库搭建,Oracle Study之--通过RMAN克隆测试库
weixin_35326667的博客
04-09 219
Oracle Study之--通过RMAN克隆测试库通过使用数据库备份，DBA可以在同一服务器或其它服务器上建立副本数据库。这个副本数据库可以和主数据库有相同的名称(拷贝)或与主数据库名称不同(克隆)。ORACLE在数据库拷贝和数据库克隆之间惟一不同的是拷贝的数据库不能更改名称。使用RMAN的复制数据库特性，可以从RMAN备份创建一个新的数据库，并为这个副本数据库保留已有的数据库名称或者赋予新的名...
windows下oracle11g数据泵自动备份脚本
05-22
windows下oracle11g数据泵自动备份脚本含删除过期备份和使用方法 1、先建备份用的路径对象：（注：此处认为用来做备份的用户backupuser已经建好了，且已经有连接数据库的相应权限） sqlplus / as sysdba CREATE OR REPLACE DIRECTORY TS_DB as 'D:\backup'; grant read,write on directory TS_DB to backupuser; grant exp_full_database,imp_full_database to backupuser;(如果该用户要执行整库备份需要加上这条) 2、将backup.bat文件放在D:\backup下，针对你自己的环境脚本中需要修改的地方如下： 备份保存天数： 如下两行中的d-3代表保存3天以内的备份，你希望保存几天的就将3改成几就行： forfiles /p "D:\backup" /m *.log /d -3 /c "cmd /c echo deleting @file ... && del /f @path" forfiles /p "D:\backup" /m *.dmp /d -3 /c "cmd /c echo deleting @file ... && del /f @path" 修改用户名和密码为你自己用来备份的用户： expdp backupuser（用户名）/backupuser（用户密码） full=y directory=TS_DB dumpfile=%backupfile% logfile=%logfile%
DG搭建常见问题处理
Root__Liu的博客
08-13 1078
在搭建DG的过程中，会遇见好多问题，现在整理出部分产常见的错误及解决方法。 1、ORA-09925报错 报错1: connected to auxiliary database (not started) released channel: prmy1 released channel: prmy2 released channel: prmy3 released channel: pr...
Oracle 11gR2 使用RMAN Duplicate复制数据库
热门推荐
PrudentWoo 的个人空间
06-03 2万+
Oracle 11gR2 使用RMAN Duplicate复制数据库 作者:吴伟龙 PrudentWoo QQ：286507175   前言:    上周刚做完一个项目，用户要求RAC的数据库能够自动备份到另外一个单节点上，单节点能够正常拿起来就能用。当时跟他们讨论的是用ADG来做，但通过描述后，用户觉得如果要人工干预的话太麻烦，它不想做任何的人工干预，实现数据自动到这台单机上来，那只是一台备用的
Oracle数据库11g标准版和企业版区别.docx
01-14
Oracle数据库11g标准版和企业版区别 Oracle数据库11g标准版和企业版是两个不同的版本，分别具有不同的特点和功能。标准版主要面向中小型企业和个人用户，而企业版面向大型企业和高级用户。 CPU 最大数量 标准版...
oracle11g数据库客户端安装版
01-10
Oracle 11g客户端安装版还包括了完整版的Oracle客户端，除了Instant Client的组件外，还包含开发工具、企业管理器、数据泵（expdp/impdp）、备份恢复工具等更全面的功能。在需要更高级功能或调试工具的场景下，完整...
[Oracle11g数据库基础教程（第2版）][孙风栋][程序源代码]
12-01
《Oracle11g数据库基础教程（第2版）》是由知名数据库专家孙风栋编著的一本关于Oracle数据库系统的入门教程。这本书旨在帮助初学者掌握Oracle11g的基本概念、安装配置、数据管理以及SQL查询语言等核心知识。源代码...
Oracle 11g concept 中英文对照版
最新发布
11-04
2. **SQL（Structured Query Language）**：SQL是用于管理关系数据库的标准语言，Oracle 11g支持其所有标准功能，如数据查询、插入、更新、删除以及创建和管理数据库对象。 3. **数据存储**：Oracle采用行式和列式...
RMAN-04006: error from auxiliary database
高云平的博客
04-10 2503
在搭建DG的过程中，之前都是使用备份集恢复数据库的。此次是使用在线恢复，使用duplicate恢复全库，发现报错如下 [oracle@stephenDG admin]$ rman target sys/oracle@stephen auxiliary sys/oracle@stephenDG Recovery Manager: Release 11.2.0.1.0 - Production on...
Duplicating a Database Without Recovery Catalog or Target Connection
小麦苗DBA宝典
08-03 440
Duplicating a Database Without Recovery Catalog or Target Connection Duplicating a Database Without Recovery Catalog or Target Connection duplicate体系结构 搞点英语出来吧，英语不好的哥们就好好翻译翻译吧，这段英语是必须看...
oracle异机复制,通过RMAN 异机克隆数据库
weixin_42719781的博客
04-02 385
平台准备：OracleLinux + Oracle 11G目标库：ORACLE_HOME=/uoracle/appORACLE_BASE=/orabaseORACLE_SID= orclIP : 192.168.0.45辅助库：ORACLE_HOME=/uoracle/appORACLE_BASE=/orabaseORACLE_SID=orclIP : 192.168.0.46操作步骤(异机和...
RMAN备份整库和归档日志的方法
cjh81378066的博客
09-15 308
发现一点：只要开启了CONTROLFILE AUTOBACKUP，就算只备份一个归档日志最后一步也一定会备份控制文件和spfile(如果是pfile启动，则不会备份spfile) 整库备份的最好方法 CONFIGURE ...
oracle12c+数据库备份,Oracle 12c 数据库备份与恢复
weixin_29558841的博客
04-05 877
这是一篇学习笔记，在这篇笔记中，对Oracle数据库和归档日志进行了备份，然后将数据库删掉。之后通过恢复spfile+恢复控制文件+restore数据库+recover数据库的方式进行了恢复。环境： Oracle 12.2.0.1.0 on LINUX准备工作： 数据库为归档模式，归档目录为/home/oracle/archlog/orcl。并且已经将归档目录里的文件清空。打开数据库，查询表T1的...
oracle11g 冷备,oracle11G Windows冷备恢复
weixin_36411999的博客
04-11 167
现有Windows oracle 冷备全部数据文件，全部的控制文件，全部的redo日志文件。丢失参数文件恢复思路：指定恢复原库的sidC:\>set oracle_sid=orcl设置环境变量的目地是在默认的情况下，指定命令行中所操作的数据库实例是orcl创建实例(即后台控制服务)C:\>oradim –new –sid orcloradim是创建实例的工具程序名称，-new表明执行新...
windows下oracle数据库导出,Windows下Oracle11g数据库导出备份
weixin_27155667的博客
04-06 332
参考来源:https://jingyan.baidu.com/article/9113f81b2040862b3314c757.html第一步:1，用管理员权限打开dos窗口2，登录命令:sqlplus sys/oracle as sysdba----------------------------sqlplus system/oracle@orcl注意：如果提示命令无效，那就是你没有配置好ora...
win Oracle自动备份,windows下oracle数据库每天自动备份一次
weixin_39564386的博客
04-03 130
背景：Oracle 10g 服务器，Oracle 10g 客户端，windows 操作平台要求：Oracle 数据库服务器对数据库 gzepbmotor每天自动备份一次。解决方案：利用任务计划、批处理文件和 Oracle 的 exp 导出功能，根据日期自动生成 Oracle 备份文件。详细步骤：1 创建批处理文件 gzepbmotorAutoBackup.batgzepbmotorAutoBack...
windows自动导出oracle数据库,Windows下Oracle11g数据库导出备份
weixin_30245667的博客
04-03 336
参考来源:https://jingyan.baidu.com/article/9113f81b2040862b3314c757.html第一步:1，用管理员权限打开dos窗口2，登录命令:sqlplus sys/oracle as sysdba----------------------------sqlplus system/[emailprotected]注意：如果提示命令无效，那就是你没有...
Oracle数据库基础及应用第3章ORACLE11g的安装和卸载.ppt
11-21
安装Oracle 11g之前，我们还需要备份数据库和操作系统，以防止数据丢失或操作系统出现问题。 在实际安装过程中，我们需要按照Oracle官方提供的安装指南逐步进行，包括创建数据库实例、配置数据库参数、安装数据库...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值