分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
--*******************************************
-- 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