RMAN Duplicate Database 的学习与测试_20100129

最新推荐文章于 2021-04-11 10:34:13 发布
最新推荐文章于 2021-04-11 10:34:13 发布
阅读量101 收藏
点赞数

RMAN Duplicate Database 的学习与测试_20100129

如何快速Clone一个生产系统作为测试环境.
1 拷贝生产库的冷备,到另一台机器上恢复.
分析:影响业务,要求停机

2 RMAN Duplicate Command.
分析: 不影响业务,保持生产系统在线.

还有其它方法吗?

Duplicates a Database

To prepare for database duplication, you must first create an auxiliary

instance.
For the duplication to work, you must connect RMAN to both the target(primary)

database
and auxiliary instance started in NOMOUNT mode.

You must have at least one auxiliary channel allocated on the auxiliary

instance. The principal work of the duplication
is performed by the auxiliary channel, which starts a server session on the

duplicate host. This channel then restores the
necessary backups of the primary database, uses them to create the duplicate

database, and initiates recovery.

During duplication, RMAN must perform. incomplete recovery because the online

redo logs in the target are not backed up and cannot be applied to the duplicate

database. The farthest that RMAN can go in recovery of the duplicate database is

the most recent redo log archived by the target database.
(在Duplicating过程中,RMAN执行的是不完全恢复.不包括在线日志.)

1 Preparing the Auxiliary Instance for Duplication: Basic Steps
Task 1: Create an Oracle Password File for the Auxiliary Instance
Task 2: Ensure Oracle Net Connectivity to the Auxiliary Instance
Task 3: Create an Initialization Parameter File for the Auxiliary Instance
Task 4: Start the Auxiliary Instance
Task 5: Mount or Open the Target Database
Task 6: Make Sure You Have the Necessary Backups and Archived Redo Logs
Task 7: DUPLICATE TARGET DATABASE TO duplicate;

2 Creating a Duplicate Database on a Local or Remote Host


Duplicate Test:

target database: 192.168.1.34 ORACLE_SID=mydb
ORACLE_HOME:/opt/oracle/product/9ir2

duplicate database: 192.168.1.29 ORACLE_SID=dupdb
ORACLE_HOME:/opt/oracle/product/9ir2

目标将192.168.1.34上的mydb通过
rman duplicate的方式Clone到 192.168.1.29上的dupdb上.
更改了数据库名,数据文件路径,在线日志路径


2.1 备份 target database
In 192.168.1.34:
backup database plus archivelog;

并将所有的备份Piece拷贝到 dupdb 相同的目录
/u01/backup/backup_MYDB_20100129_15_1
/u01/backup/backup_MYDB_20100129_16_1
/u01/backup/backup_MYDB_20100129_17_1
/opt/oracle/product/9ir2/dbs/c-2621354619-20100129-00;


除了物理拷贝的方式外,也可以通过NFS共享的形式加载Mount point.

2.2 在dupdb上建立密码文件
orapwd FILE=/opt/oracle/product/9ir2/dbs/orapwdupdb PASSWORD=sys ENTRIES=30

 

2.3 配置NET
In 192.168.1.29:
targetdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mydb)
    )
  )
lsnrctl start 打开监听

tnsping dupdb

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010

14:03:54

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =

TCP)(HOST = 192.168.1.29)(PORT = 1521))) (CONNECT_DATA = (SID = mydb)))
OK (10 msec)

手工注册监听
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dupdb)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (SID_NAME = dupdb)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.29)(PORT = 1521))
      )
    )
  )

 
In 192.168.1.34:
dupdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mydb)
    )
  )

lsnrctl start 打开监听
tnsping targetdb

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010

13:14:17

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/opt/oracle/product/9ir2/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =

TCP)(HOST = 192.168.1.34)(PORT = 1521))) (CONNECT_DATA = (SID = mydb)))
OK (10 msec)

 

2.4 拷贝target的参数文件到dupdb


更改
DB_NAME='dupdb'
CONTROL_FILES='/opt/oracle/oradata/dupdb/control01.ctl','/opt/oracle/oradata/dup

db/control03.ctl','/opt/oracle/oradata/dupdb/control03.ctl'
DB_FILE_NAME_CONVERT=(/opt/oracle/oradata/mydb/,/opt/oracle/oradata/dupdb/)
LOG_FILE_NAME_CONVERT=(/opt/oracle/oradata/mydb/,/opt/oracle/oradata/dupdb/)

并更改一些xxx_dest路径:如background_dump_dest,如目录不存在,则先建立目录.

(在dupdb上)
更改后的pfile_20100129.ora
*.aq_tm_processes=1
*.background_dump_dest='/opt/oracle/admin/dupdb/bdump'
*.compatible='9.2.0.0.0'
*.core_dump_dest='/opt/oracle/admin/dupdb/cdump'
*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dupdb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=mydbXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='dupdb'
*.java_pool_size=117440512
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_dest='/opt/oracle/archive/'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=117440512
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/dupdb/udump'
CONTROL_FILES='/opt/oracle/oradata/dupdb/control01.ctl','/opt/oracle/oradata/dup

db/control03.ctl','/opt/oracle/oradata/dupdb/control03.ctl'
DB_FILE_NAME_CONVERT=(/opt/oracle/oradata/mydb/,/opt/oracle/oradata/dupdb/)
LOG_FILE_NAME_CONVERT=(/opt/oracle/oradata/mydb/,/opt/oracle/oradata/dupdb/)


注意在参数文件中必须设置至少两个参数
DB_NAME='dupdb' (即使更改了instance_name='dupdb')
CONTROL_FILES='/opt/oracle/oradata/dupdb/control01.ctl','/opt/oracle/oradata/dup

db/control03.ctl','/opt/oracle/oradata/dupdb/control03.ctl'

 

4 Start the Auxiliary Instance
(在dupdb上)

export ORACLE_SID=dupdb
sqlplus /nolog
conn /as sysdba
create spfile from pfile='?/pfile_20100129.ora';
SQL> startup force nomount
ORACLE instance started.

Total System Global Area  320308744 bytes
Fixed Size                   742920 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 798720 bytes

show parametes xxx 确认更改是符合要求的


2.5 Duplicate target to dupdb
(在target上,实际上在两端都可做)
oracle@Z814:/opt/oracle/oradata> rman TARGET /  AUXILIARY sys/sys@dupdb;

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: MYDB (DBID=2621354619)
connected to auxiliary database: dupdb (not mounted)

RMAN> DUPLICATE TARGET DATABASE TO dupdb;
(使用默认通道)

Starting Duplicate Db at 29-JAN-10
using target database controlfile instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=14 devtype=DISK

printing stored script. Memory Script
{
   set until scn  5481059;
   set newname for datafile  1 to
 "/opt/oracle/oradata/dupdb/system01.dbf";
   set newname for datafile  2 to
 "/opt/oracle/oradata/dupdb/undotbs01.dbf";
   set newname for datafile  3 to
 "/opt/oracle/oradata/dupdb/cwmlite01.dbf";
   set newname for datafile  4 to
 "/opt/oracle/oradata/dupdb/drsys01.dbf";
   set newname for datafile  5 to
 "/opt/oracle/oradata/dupdb/example01.dbf";
   set newname for datafile  6 to
 "/opt/oracle/oradata/dupdb/indx01.dbf";
   set newname for datafile  7 to
 "/opt/oracle/oradata/dupdb/odm01.dbf";
   set newname for datafile  8 to
 "/opt/oracle/oradata/dupdb/tools01.dbf";
   set newname for datafile  9 to
 "/opt/oracle/oradata/dupdb/users01.dbf";
   set newname for datafile  10 to
 "/opt/oracle/oradata/dupdb/xdb01.dbf";
   restore
   check readonly
   clone database
   ;
}
executing script. 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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 29-JAN-10

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/dupdb/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/dupdb/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/dupdb/cwmlite01.dbf
restoring datafile 00004 to /opt/oracle/oradata/dupdb/drsys01.dbf
restoring datafile 00005 to /opt/oracle/oradata/dupdb/example01.dbf
restoring datafile 00006 to /opt/oracle/oradata/dupdb/indx01.dbf
restoring datafile 00007 to /opt/oracle/oradata/dupdb/odm01.dbf
restoring datafile 00008 to /opt/oracle/oradata/dupdb/tools01.dbf
restoring datafile 00009 to /opt/oracle/oradata/dupdb/users01.dbf
restoring datafile 00010 to /opt/oracle/oradata/dupdb/xdb01.dbf
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u01/backup/backup_MYDB_20100129_16_1 tag=TAG20100129T135654

params=NULL
channel ORA_AUX_DISK_1: restore complete
Finished restore at 29-JAN-10
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "dupdb" RESETLOGS

ARCHIVELOG
  MAXLOGFILES     50
  MAXLOGMEMBERS      5
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/opt/oracle/oradata/dupdb/redo01.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/opt/oracle/oradata/dupdb/redo02.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/opt/oracle/oradata/dupdb/redo03.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/opt/oracle/oradata/dupdb/system01.dbf'
 CHARACTER SET ZHS16GBK


printing stored script. Memory Script
{
   switch clone datafile all;
}
executing script. Memory Script

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=709573853

filename=/opt/oracle/oradata/dupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=709573853

filename=/opt/oracle/oradata/dupdb/cwmlite01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=709573853

filename=/opt/oracle/oradata/dupdb/drsys01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=709573853

filename=/opt/oracle/oradata/dupdb/example01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=709573853

filename=/opt/oracle/oradata/dupdb/indx01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=709573853

filename=/opt/oracle/oradata/dupdb/odm01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=709573853

filename=/opt/oracle/oradata/dupdb/tools01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=709573853

filename=/opt/oracle/oradata/dupdb/users01.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=709573853

filename=/opt/oracle/oradata/dupdb/xdb01.dbf

printing stored script. Memory Script
{
   set until scn  5481059;
   recover
   clone database
    delete archivelog
   ;
}
executing script. Memory Script

executing command: SET until clause

Starting recover at 29-JAN-10
using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=26
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u01/backup/backup_MYDB_20100129_17_1 tag=TAG20100129T135720

params=NULL
channel ORA_AUX_DISK_1: restore complete
archive log filename=/opt/oracle/archive/1_26.dbf thread=1 sequence=26
channel clone_default: deleting archive log(s)
archive log filename=/opt/oracle/archive/1_26.dbf recid=1 stamp=709573855
media recovery complete
Finished recover at 29-JAN-10

printing stored script. Memory Script
{
   shutdown clone;
   startup clone nomount ;
}
executing script. Memory Script


database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     320308744 bytes

Fixed Size                      742920 bytes
Variable Size                285212672 bytes
Database Buffers              33554432 bytes
Redo Buffers                    798720 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "dupdb" RESETLOGS

ARCHIVELOG
  MAXLOGFILES     50
  MAXLOGMEMBERS      5
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY      226
 LOGFILE
  GROUP  1 ( '/opt/oracle/oradata/dupdb/redo01.log' ) SIZE  104857600  REUSE,
  GROUP  2 ( '/opt/oracle/oradata/dupdb/redo02.log' ) SIZE  104857600  REUSE,
  GROUP  3 ( '/opt/oracle/oradata/dupdb/redo03.log' ) SIZE  104857600  REUSE
 DATAFILE
  '/opt/oracle/oradata/dupdb/system01.dbf'
 CHARACTER SET ZHS16GBK


printing stored script. Memory Script
{
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/undotbs01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/cwmlite01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/drsys01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/example01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/indx01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/odm01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/tools01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/users01.dbf";
   catalog clone datafilecopy  "/opt/oracle/oradata/dupdb/xdb01.dbf";
   switch clone datafile all;
}
executing script. Memory Script

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/undotbs01.dbf recid=1

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/cwmlite01.dbf recid=2

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/drsys01.dbf recid=3

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/example01.dbf recid=4

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/indx01.dbf recid=5

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/odm01.dbf recid=6

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/tools01.dbf recid=7

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/users01.dbf recid=8

stamp=709575024

cataloged datafile copy
datafile copy filename=/opt/oracle/oradata/dupdb/xdb01.dbf recid=9

stamp=709575024

datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=709575024

filename=/opt/oracle/oradata/dupdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=709575024

filename=/opt/oracle/oradata/dupdb/cwmlite01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=709575024

filename=/opt/oracle/oradata/dupdb/drsys01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=709575024

filename=/opt/oracle/oradata/dupdb/example01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=709575024

filename=/opt/oracle/oradata/dupdb/indx01.dbf
datafile 7 switched to datafile copy
input datafilecopy recid=6 stamp=709575024

filename=/opt/oracle/oradata/dupdb/odm01.dbf
datafile 8 switched to datafile copy
input datafilecopy recid=7 stamp=709575024

filename=/opt/oracle/oradata/dupdb/tools01.dbf
datafile 9 switched to datafile copy
input datafilecopy recid=8 stamp=709575024

filename=/opt/oracle/oradata/dupdb/users01.dbf
datafile 10 switched to datafile copy
input datafilecopy recid=9 stamp=709575024

filename=/opt/oracle/oradata/dupdb/xdb01.dbf

printing stored script. Memory Script
{
   Alter clone database open resetlogs;
}
executing script. Memory Script

database opened
Finished Duplicate Db at 29-JAN-10

注意如果发现 hang 住了

printing stored script. Memory Script
{
   shutdown clone;(???)
   startup clone nomount ;
}
executing script. Memory Script

而一直不动,
可能是你在dupdb上登录了,shutdown clone 在等待你的退出.


2.6 如何做到定时同步呢?
每天拷贝增量备份或归档文件到dupdb. 每天执行DUPLICATE TARGET DATABASE TO dupdb;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10248702/viewspace-626402/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10248702/viewspace-626402/

cprkdx1264
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Rman Active Database Duplicate 迁移方案V1.1.pdf
09-24
Oracle Rman Active Database Duplicate 迁移方案 本文档主要介绍 Oracle Rman Active Database Duplicate 迁移方案，适用于 Oracle 11g/12c 版本。该方案旨在帮助数据库管理员快速迁移数据库，减少迁移时间和风险...
oracle adg不传输归档,Oracle 11g Active DataGuard(ADG) 优化及 duplicate hang 诊断案例
weixin_32820457的博客
04-04 671
前段时间因为硬件原因，standby DB crash，主库删除了日志且无备份，后期需要重建，该环境是主备两套11.2.0.3 2-NODES RAC ON EXADATA Machine ，存储在ASM， 数据库70TB 大小， 闲时每天1T归档日志， 忙时每天可达4T+归档， 之前朋友重建DG一直使用主机上一个shell 放后台，我查看了该shell 确实不算复杂，但是duplicate 一直...
duplicate database
cri3224的博客
12-01 772
工作很久了，也一直都没有操作过duplicate database，因为平常的备份恢复，用rman普通方式就可以搞定了，但这个duplicate database是必须了解的，所以现在实验一下，以免以后用到。 带着疑问...
主备库内存不一致的Data Guard环境搭建
weixin_43085475的博客
11-11 336
前言 前几天朋友问了我一个问题，一个单节点RAC，要做一套Data Guard，但是备库能给数据库的内存只有主库的一半左右，能不能成功。不知道，没做过，试试呗。 一．概况 1. 涉及的技术点 1）RAC作为primary database，nonRAC作为standby database 2）使用RMAN作为数据库的备份方式 3）使用duplicate database for standby创建...
主备库内存不一致的Data Guard环境搭建全过程
Enmotech的博客
05-27 712
墨墨导读：一个单节点RAC，要做一套Data Guard，但是备库能给数据库的内存只有主库的一半左右，可以实现吗？答案是可以的，本文详述整个过程。一．概况1. 涉及的技术点1）RAC作为...
创建辅助oracle数据库,dg实验之duplicate创建辅助数据库
weixin_33140809的博客
04-11 667
实验环境：系统环境：redhat-as4.7oracle: oracle10.2.0.4主数据库：ip地址：192.168.1.220主机名称：db-primary实例名称：lizidb数据库名称：lizidboracle软件目录：/opt/oracle/product/10.2.0数据库数据文件目录：/u00/oracle/lizidbrman备份目录：/u00/dbbackup辅助数据库：...
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
02-28
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库 Oracle 11gR2 中使用 RMAN duplicate from active database 复制数据库是一种高效的数据库复制方法。这种方法可以直接从活动数据库复制，省去...
使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库.docx
07-08
【使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库】 在Oracle数据库管理中，创建物理备用数据库（Physical Standby Database）是数据保护策略的重要组成部分，主要用于实现Data Guard环境中的灾难恢复和...
Oracle RMAN Database Duplication(Apress,2015)
05-07
Oracle RMAN Database Duplication is a deep dive into RMAN's duplication feature set, showing how RMAN can make it so much easier for you as a database administrator to satisfy the many requests from ...
Rman通过duplicate创建standby
09-18
RMAN> DUPLICATE TARGET DATABASE TO standby FROM ACTIVE DATABASE; ``` 这个命令将从活动的主数据库复制所有的结构和数据到备用数据库。 6. **同步备用数据库**： 创建备用数据库后，需要定期使用`switch log...
RMAN-06034: at least 1 channel must be allocated to execute this command
killvoon的专栏
12-28 1074
下午做过单表恢复， recover table user.table_name until time "to_date('2018-12-21 15:00:00','yyyy-mm-dd hh24:mi:ss')" auxiliary destination '/backup/bak' remap table 'USER'.'TABLE_NAME':'USER'.'TABLE_NEW_NAME'...
Duplicate 复制数据库 搭建Dataguard
weixin_30667301的博客
11-23 268
1 操作系统环境 　　此处隐藏具体信息 SystemIP-addressdb_namedb_versionComment Target DB Auxiliary DB 2 复制数据库前的准备工作 2.1 standby 端安装数据库软件 ...
OCM_Session3_2_Using RMAN
一抹曦阳-Oracle
03-21 2410
2. Using RMAN  2.1 Configure RMAN options for the PROD database  2.1.1 Turn backup optimization on  2.1.2 Set your default channel to write to /home/oracle/backup (you may have to create this dir
auxiliary恢复备库详细记录
weixin_34162629的博客
02-09 588
   -bash-3.2$ rman target / auxiliary sys/password@standby     Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 8 22:01:47 2012     Copyright (c) 1982, 200...
如何使用RMAN创建测试库(duplicate)
10-30 79
截图是个体力活,把图片弄到文章里又是一通折腾,俺是坚定地纯文字版! 场景: 2台虚拟机,一台有数据库ORCL,另一台只装了数据库软件 要求: 将ORCL 迁移到另一台上,不允许宕机 约定:采用最简单的相同路径设置 生产库: 192.168.0.1 oracle linux 5.8 64 bit ORACLE_BASE: /u01/app/oracle ORACLE_HOME
Oracle 11g单实例RMAN恢复到Oracle 11g RAC
weixin_34195142的博客
09-17 139
一、环境说明操作系统版本: RHEL 6.5 x641. 源数据库服务器Oracle版本: Oracle 11g 11.2.0.4 64位(单机)Oracle_SID: orcl db_name : orcl背景：一台生产oracle10g（10.2.0.5）数据库计划迁移到Oracle 11.2.0.4.0 RAC.1) 先oracle10g（10.2.0.5）升级...
Oracle RMAN 备份及不完全恢复(删除archievelog)
weixin_30646315的博客
06-18 208
RMAN备份命令 backup Database format='/home/oracle/backup/bak_full_%U_%T' tag='bak_full';sql 'alter system archive log current';backup archivelog all tag='arc_bak' format='/home/oracle/b...
html css js网页设计
最新发布
07-12
HTML、CSS和JavaScript是构建网页和网站的基本技术，它们共同工作来创建和设计用户界面。下面是关于这三种技术的详细介绍： ### HTML (HyperText Markup Language) - **定义**：HTML是构建网页内容的标准标记语言。 - **作用**：用于创建网页的结构和内容，如段落、链接、图片、表格等。 - **语法**：使用标签（如 `<p>`, `<div>`, `<a>`, `<img>` 等）来定义网页元素。 ### CSS (Cascading Style Sheets) - **定义**：CSS是一种样式表语言，用于描述HTML文档的呈现方式。 - **作用**：用于设置网页的布局、颜色、字体和其他视觉元素。 - **语法**：通过选择器（如 `p`, `.myclass`, `#myid` 等）应用样式规则。 ### JavaScript - **定义**：JavaScript是一种脚本语言，通常用于网页上实现交互功能。 - **作用**：允许网页与用户进行交互，如响应用户操作、动态更新内容、动画效果等。 - **语法**：Java

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值