RMAN 备份路径困惑(使用plus archivelog时)

最新推荐文章于 2021-04-06 04:44:16 发布
最新推荐文章于 2021-04-06 04:44:16 发布
阅读量46 收藏
点赞数

--*******************************************

-- RMAN 备份路径困惑(使用plus archivelog时)

--*******************************************

最近RMAN备份时，碰到一点疑惑。即使用plus archivelog 时不管是使用format参数指定备份文件的路径还是使用configure配置RMAN备份路径，都不能

将数据文件和日志文件备份到同一路径。在因为以前使用RMAN备份，都是单独备份数据文件和日志文件，所以一直没有在意这个问题。下面给出具体事例。

一、指定备份路径备份数据库及归档日志

RMAN> backup database format '/u01/bk/bk_db_%U' plus archivelog;

Starting backup at 02-MAY-11

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=146 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=50 recid=10 stamp=750091269

input archive log thread=1 sequence=51 recid=11 stamp=750091281

input archive log thread=1 sequence=52 recid=12 stamp=750091286

input archive log thread=1 sequence=53 recid=13 stamp=750092325

input archive log thread=1 sequence=54 recid=14 stamp=750092487

input archive log thread=1 sequence=55 recid=15 stamp=750093621

input archive log thread=1 sequence=56 recid=16 stamp=750094799

input archive log thread=1 sequence=57 recid=17 stamp=750095198

input archive log thread=1 sequence=58 recid=18 stamp=750099671

input archive log thread=1 sequence=59 recid=19 stamp=750099848

input archive log thread=1 sequence=60 recid=20 stamp=750099945

input archive log thread=1 sequence=61 recid=21 stamp=750103678

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/flash_recovery_area/ODBP/backupset/2011_05_02/ --归档日志放在了闪回区

o1_mf_annnn_TAG20110502T180758_6vx0mzl2_.bkp tag=TAG20110502T180758 comment=NONE

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

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/odbp/system01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradata/odbp/undotbs01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradata/odbp/sysaux01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/odbp/users01.dbf

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1dmbbb40_1_1 tag=TAG20110502T180800 comment=NONE --数据文件存放在了指定的路径

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/odbp/system01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradata/odbp/undotbs01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradata/odbp/sysaux01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/odbp/users01.dbf

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/flash_recovery_area/ODBP/backupset/2011_05_02/ --数据文件同时也存放在了闪回区

o1_mf_nnndf_TAG20110502T180800_6vx0og2z_.bkp tag=TAG20110502T180800 comment=NONE

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1fmbbb6r_1_1 tag=TAG20110502T180800 comment=NONE --控制文件和spfile存放到了指定路径

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/flash_recovery_area/ODBP/backupset/2011_05_02/ --控制文件和spfile同时也保存到了闪回区

o1_mf_ncsnf_TAG20110502T180800_6vx0pycl_.bkp tag=TAG20110502T180800 comment=NONE

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

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=62 recid=22 stamp=750103776

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/flash_recovery_area/ODBP/backupset/2011_05_02/ --归档日志放在了闪回区

o1_mf_annnn_TAG20110502T180936_6vx0q1dg_.bkp tag=TAG20110502T180936 comment=NONE

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

Finished backup at 02-MAY-11

--查看备份的数据文件、控制文件等信息

[oracle@odbp 2011_05_02]$ ls -hltr

total 703M

-rw-r----- 1 oracle oinstall 4.5M May 2 18:08 o1_mf_annnn_TAG20110502T180758_6vx0mzl2_.bkp

-rw-r----- 1 oracle oinstall 691M May 2 18:09 o1_mf_nnndf_TAG20110502T180800_6vx0og2z_.bkp

-rw-r----- 1 oracle oinstall 6.9M May 2 18:09 o1_mf_ncsnf_TAG20110502T180800_6vx0pycl_.bkp

-rw-r----- 1 oracle oinstall 15K May 2 18:09 o1_mf_annnn_TAG20110502T180936_6vx0q1dg_.bkp

[oracle@odbp 2011_05_02]$ ls -hltr /u01/bk

total 698M

-rw-r----- 1 oracle oinstall 691M May 2 18:08 bk_db_1dmbbb40_1_1

-rw-r----- 1 oracle oinstall 6.9M May 2 18:09 bk_db_1fmbbb6r_1_1

从上面的情况来看，

1.当指定了db_recovery_file_dest参数为 /u01/app/oracle/flash_recovery_area时，则归档日志被备份到此目录。

2.在参数db_recovery_file_dest参数为闪回区时，则数据文件与控制文件及spfile被使用了双重备份。

--RMAN配置信息为缺省，未做任何调整

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/10g/dbs/snapcf_odbp.f'; # default

--将db_recovery_file_dest参数置空

SQL> alter system set db_recovery_file_dest='';

System altered.

二、再次使用RMAN进行备份

RMAN> backup database format '/u01/bk/bk_db_%U' plus archivelog;

Starting backup at 02-MAY-11

current log archived

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=138 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=50 recid=10 stamp=750091269

input archive log thread=1 sequence=51 recid=11 stamp=750091281

input archive log thread=1 sequence=52 recid=12 stamp=750091286

input archive log thread=1 sequence=53 recid=13 stamp=750092325

input archive log thread=1 sequence=54 recid=14 stamp=750092487

input archive log thread=1 sequence=55 recid=15 stamp=750093621

input archive log thread=1 sequence=56 recid=16 stamp=750094799

input archive log thread=1 sequence=57 recid=17 stamp=750095198

input archive log thread=1 sequence=58 recid=18 stamp=750099671

input archive log thread=1 sequence=59 recid=19 stamp=750099848

input archive log thread=1 sequence=60 recid=20 stamp=750099945

input archive log thread=1 sequence=61 recid=21 stamp=750103678

input archive log thread=1 sequence=62 recid=22 stamp=750103776

input archive log thread=1 sequence=63 recid=23 stamp=750104981

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/10g/dbs/1imbbccm_1_1 tag=TAG20110502T182942 comment=NONE --归档日志备份位于$ORACLE_HOME/dbs路径下

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

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/odbp/system01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradata/odbp/undotbs01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradata/odbp/sysaux01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/odbp/users01.dbf

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1jmbbcco_1_1 tag=TAG20110502T182944 comment=NONE --数据文件存放在了指定的路径

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/odbp/system01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradata/odbp/undotbs01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradata/odbp/sysaux01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/odbp/users01.dbf

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/10g/dbs/1kmbbceg_1_1 tag=TAG20110502T182944 comment=NONE--数据文件同时也存放在$ORACLE_HOME/dbs路径下

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1lmbbcg7_1_1 tag=TAG20110502T182944 comment=NONE --控制文件及spfile备份位于指定路径下

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

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11

piece handle=/u01/app/oracle/10g/dbs/1mmbbcgc_1_1 tag=TAG20110502T182944 comment=NONE--归档日志文件备份位于$ORACLE_HOME/dbs路径下

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

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting archive log backupset

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

input archive log thread=1 sequence=64 recid=24 stamp=750105102

channel ORA_DISK_1: starting piece 1 at 02-MAY-11

channel ORA_DISK_1: finished piece 1 at 02-MAY-11 --控制文件及spfile备同时也存放在$ORACLE_HOME/dbs路径下

piece handle=/u01/app/oracle/10g/dbs/1nmbbcge_1_1 tag=TAG20110502T183142 comment=NONE

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

Finished backup at 02-MAY-11

从上面的情况来看，

1.当db_recovery_file_dest参数为空值时，则归档日志，控制文件及spfile被备份到$ORACLE_HOME/dbs路径下

2.数据文件及控制文件同样实现了双重备份，一份位于$ORACLE_HOME/dbs路径下，一份位于用户指定路径下

三、如何将归档日志文件，控制文件，spfile文件以及数据文件备份到同一路径下，

RMAN> run{

2> allocate channel ch1 device type disk;

3> allocate channel ch2 device type disk;

4> backup database format '/u01/bk/bk_db_%U'

5> plus archivelog format '/u01/bk/bk_lg_%U';

6> release channel ch1;

7> release channel ch2;}

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: sid=141 devtype=DISK

allocated channel: ch2

channel ch2: sid=148 devtype=DISK

Starting backup at 02-MAY-11

current log archived

channel ch1: starting archive log backupset

channel ch1: specifying archive log(s) in backup set

input archive log thread=1 sequence=59 recid=19 stamp=750099848

input archive log thread=1 sequence=60 recid=20 stamp=750099945

input archive log thread=1 sequence=61 recid=21 stamp=750103678

input archive log thread=1 sequence=62 recid=22 stamp=750103776

input archive log thread=1 sequence=63 recid=23 stamp=750104981

input archive log thread=1 sequence=64 recid=24 stamp=750105102

input archive log thread=1 sequence=65 recid=25 stamp=750767326

input archive log thread=1 sequence=66 recid=26 stamp=750769794

channel ch1: starting piece 1 at 02-MAY-11

channel ch2: starting archive log backupset

channel ch2: specifying archive log(s) in backup set

input archive log thread=1 sequence=50 recid=10 stamp=750091269

input archive log thread=1 sequence=51 recid=11 stamp=750091281

input archive log thread=1 sequence=52 recid=12 stamp=750091286

input archive log thread=1 sequence=53 recid=13 stamp=750092325

input archive log thread=1 sequence=54 recid=14 stamp=750092487

input archive log thread=1 sequence=55 recid=15 stamp=750093621

input archive log thread=1 sequence=56 recid=16 stamp=750094799

input archive log thread=1 sequence=57 recid=17 stamp=750095198

input archive log thread=1 sequence=58 recid=18 stamp=750099671

channel ch2: starting piece 1 at 02-MAY-11

channel ch1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_lg_1ombvlk3_1_1 tag=TAG20110510T110954 comment=NONE --归档日志存放到指定路径

channel ch1: backup set complete, elapsed time: 00:00:03

channel ch2: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_lg_1pmbvlk3_1_1 tag=TAG20110510T110954 comment=NONE --归档日志存放到指定路径

channel ch2: backup set complete, elapsed time: 00:00:03

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

channel ch1: starting full datafile backupset

channel ch1: specifying datafile(s) in backupset

input datafile fno=00001 name=/u01/app/oracle/oradata/odbp/system01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradata/odbp/sysaux01.dbf

channel ch1: starting piece 1 at 02-MAY-11

channel ch2: starting full datafile backupset

channel ch2: specifying datafile(s) in backupset

input datafile fno=00002 name=/u01/app/oracle/oradata/odbp/undotbs01.dbf

input datafile fno=00004 name=/u01/app/oracle/oradata/odbp/users01.dbf

channel ch2: starting piece 1 at 02-MAY-11

channel ch2: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1rmbvlk7_1_1 tag=TAG20110510T110958 comment=NONE --数据文件存放到指定路径

channel ch2: backup set complete, elapsed time: 00:01:09

channel ch2: starting full datafile backupset

channel ch2: specifying datafile(s) in backupset

including current control file in backupset

channel ch2: starting piece 1 at 02-MAY-11

channel ch2: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1smbvlmd_1_1 tag=TAG20110510T110958 comment=NONE --数据文件存放到指定路径

channel ch2: backup set complete, elapsed time: 00:00:07

channel ch2: starting full datafile backupset

channel ch2: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ch2: starting piece 1 at 02-MAY-11

channel ch2: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1tmbvlml_1_1 tag=TAG20110510T110958 comment=NONE --控制文件，spfile文件存放到指定路径

channel ch2: backup set complete, elapsed time: 00:00:08

channel ch1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_db_1qmbvlk7_1_1 tag=TAG20110510T110958 comment=NONE

channel ch1: backup set complete, elapsed time: 00:01:31

Finished backup at 02-MAY-11

Starting backup at 02-MAY-11

current log archived

channel ch1: starting archive log backupset

channel ch1: specifying archive log(s) in backup set

input archive log thread=1 sequence=67 recid=27 stamp=750769890

channel ch1: starting piece 1 at 02-MAY-11

channel ch1: finished piece 1 at 02-MAY-11

piece handle=/u01/bk/bk_lg_1umbvln2_1_1 tag=TAG20110510T111130 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:02

Finished backup at 02-MAY-11

released channel: ch1

released channel: ch2

四、总结（RMAN备份路径）

1.在未通过configure命令设定RMAN备份文件路径以及未修改db_recovery_file_dest，且指定了format参数，则备份的数据文件，参数文件，

控制文件，采用了双重保护方式，一份位于指定路径，一份位于缺省的闪回区。同时归档日志保存在闪回区。

2.一旦修改了db_recovery_file_dest至特定路径，则同上述功能一样，所不同的是存放到非缺省的闪回区。

3.当db_recovery_file_dest为空值时，同样使用双重保护，但这些文件被放置到了$ORACLE_HOME/dbs路径下。

4.当使用了configure channel device type disk format = '/u01/bk/db_%U'配置RMAN，则对于badkup database plus archivelog同样会出现上

述的情况。

5.如果指定了configure channel device type disk format = '/u01/bk/db_%U'，则单独备份数据文件和日志文件不存在问题，都会存放在指定路径。

6.在同一条命令来完成(badkup database plus archivelog)则需要单独指定数据文件和日志文件的位置，如下方式：

backup database format '/u01/bk/bk_db_%U'

plus archivelog format '/u01/bk/bk_lg_%U'

五、更多参考

有关性能优化请参考

Oracle 硬解析与软解析

共享池的调整与优化(Shared pool Tuning)

Buffer cache 的调整与优化(一)

Oracle 表缓存(caching table)的使用

有关闪回特性请参考

Oracle 闪回特性(FLASHBACK DATABASE)

Oracle 闪回特性(FLASHBACK DROP & RECYCLEBIN)

Oracle 闪回特性(Flashback Query、Flashback Table)

Oracle 闪回特性(Flashback Version、Flashback Transaction)

有关基于用户管理的备份和备份恢复的概念请参考

Oracle 冷备份

Oracle 热备份

Oracle 备份恢复概念

Oracle 实例恢复

Oracle 基于用户管理恢复的处理(详细描述了介质恢复及其处理)

有关RMAN的恢复与管理请参考

RMAN 概述及其体系结构

RMAN 配置、监控与管理

RMAN 备份详解

RMAN 还原与恢复

fyd222
关注
oracle 列出备份文件路径,RMAN备份、恢复实验室 之 备份篇 【查看备份情况】
weixin_39903846的博客
04-14 1686
概要：查看备份集查看SCHEMA统计信息查看表空间的备份情况查看数据文件的备份情况查看控制文件的备份情况查看不同类型设备上的备份情况查看归档日志及其备份情况查看系统中不存在(或者说是不在指定路径下)的备份查看过期的备份查看几天前的schema状态查看需要备份的文件查看违反规则的备份操作命令：查看备份集：RMAN> list backupset;List of Backup Sets=====...
使用Rman的Plus archvielog选项简化数据库备份操作
编程开发资料库
11-30 106
Oracle9i开始Rman提供plus archivelog选项，极大的简化了Rman备份的操作。 当你定义plus archivelog语句时，RMAN执行如下步骤的操作：1。运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令2。运行BACKUP ARCHIVELOG ALL命令。注意如果备份优化被启用，RMAN只会备份未备份过的日志3。备份BACKUP命令中定义...
oracle rman plus archivelog自动执行的步骤
千里足迹
11-23 970
backup database plus archivelog; Oracle9i开始Rman提供plus archivelog选项，使Rman备份操作更加方便。 当你定义plus archivelog语句时，RMAN执行如下步骤的操作： 1。运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令 2。运行BACKUP ARCHIVELOG ALL命令。注意如果
Rman plus archivelog
clj229982100的博客
09-17 112
在SAP中﹐Archivelog backup默認采用完成兩次備份后才可以從Archive目錄刪除﹐這點SAP做的相當嚴謹﹐但對于一般應用系統﹐如果硬盤資源十分有限﹐想加快Archivelog的備份頻率以防止整個磁盤系統介質故障...
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf
09-13
Oracle 11g R2 的 RMAN (Recovery Manager) 是 Oracle 数据库管理系统中的一个关键工具，主要用于数据库的备份和恢复。RMAN 提供了一种高效且灵活的方式来管理和保护数据库，确保在数据丢失或系统故障时能够快速恢复...
Oracle19c rac备份数据通过rman恢复到单实例
最新发布
07-02
在进行Oracle 19c RAC（Real Application Clusters）数据库的数据备份与恢复操作时，可能会遇到需要将RAC集群环境下的备份数据恢复到单实例环境中的场景。这种情况下，RMAN（Recovery Manager）作为Oracle提供的强大...
理解RMAN backup database plus archivelog命令
congxinlan3332的博客
10-31 323
相关文章： 《理解RMAN backup database plus archivelog delete all input命令》http://space.itpub.net/?uid-231...
oracle plus archivelog,Oracle 11g RMAN备份-RMAN的backup database plus archivelog命令背后的操作...
weixin_33700405的博客
04-06 582
--查看当前的日志组sys@TESTDB11>selectsequence#,group#,statusfromv$log;SEQUENCE#GROUP# STATUS---------- ---------- ----------------191INACTIVE202INACTIVE213CURRENT--查看归档的日志信息sys@TESTDB11>selectsequence#,...
rman里面的PLUS ARCHIVELOG方式
cjh6456022的博客
06-24 489
os: redhat linux as 3 + u3db: oracle 10.1.0.4 rac PLUS ARCHIVELOG方式的备份RMAN执行如下步骤的操作：1)运行一个ALTER SYSTEM ARCHIVELOG...
RMAN 备份中的redo log切换- bakcup ...plus archivelog命令
文档搬运工
03-29 966
原文地址： https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/backing-up-database.html#GUID-5A2AEEA4-CB81-421A-8C4A-805B92DBD8FA 9.7.1.2 About Online Redo Log Switching Automatic onli...
backup database plus archivelog; 命令详解
cpk86585的博客
03-02 1688
RMAN> backup database plus archivelog;命令的理解！ 个人理解如下： 执行命令后系统 切换redo log并归档à备份归档文件(scn：604010～609123...
oracle在archivelog模式进行rman备份和恢复
edonzhon
03-05 546
归档模式下的数据库恢复数据的时候还需要将归档日志内容应用到数据上面 1.确认数据库为归档模式 select log_mode from v$database; 2.通过rman备份USERS表空间 RMAN>run{ allocate channel ch_1 type disk; allocate channel ch_2 type disk; backup tablespace users format '/backup/usersTablespace.bak'; } 3.模拟U
RMAN BACKUP...PLUS ARCHIVELOG命令执行步骤
zhenjiang412518的专栏
03-20 2313
BACKUP...PLUS ARCHIVELOG命令在备份过程中会依次执行下列步骤： 　　1 ）运行ALTER SYSTEM ARCHIVE LOG CURRENT语句对当前 Redolog 进行归档。 　　2 ）执行BACKUP ARCHIVELOG ALL命令备份所有已归档日志。 　　3 ）执行BACKUP命令对指定项进行备份。 　　4 ）再次运行ALTER SYSTE
oracle plus archivelog,用Rman的Plus archvielog选项简化数据库备份
weixin_42439576的博客
04-06 418
用Rman的Plus archvielog选项简化数据库备份Oracle9i开始Rman提供plus archivelog选项，极大的简化了Rman备份的操作。当你定义plus archivelog语句时，RMAN执行如下步骤的操作：1。运行一个ALTER SYSTEM ARCHIVELOG CURRENT命令2。运行BACKUP ARCHIVELOG ALL命令。注意如果备份优化被启用，RMAN...
RMAN中：backup archivelog all 和plus archivelog的区别
07-05 1050
备份归档日志方式： 单独备份归档日志：backup archivelog all 在执行备库时一起备份归档日志：backup database plus archivelog; 这两种方式有什么区别呢？ 运行backup archivelog all 命令时执行的步骤： 1.alter sy...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值