[20171101]rman to destination.txt

简介: [20171101]rman to destination.txt --//国庆放假,看了一些rman方面的书,看到一个不常用的参数to destination,测试看看.

[20171101]rman to destination.txt

--//国庆放假,看了一些rman方面的书,看到一个不常用的参数to destination,测试看看.

1.环境:
SYS@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.测试:
RMAN> backup as copy datafile 6 to destination '/home/oracle/backup/';

Starting backup at 2017-11-01 09:01:58
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
output file name=/home/oracle/backup/BOOK/datafile/o1_mf_tea_dzl786k3_.dbf tag=TAG20171101T090158 RECID=61 STAMP=958899718
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2017-11-01 09:01:59

Starting Control File and SPFILE Autobackup at 2017-11-01 09:01:59
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_11_01/o1_mf_s_958899719_dzl787nw_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-11-01 09:02:00

RMAN> backup  datafile 6 to destination '/home/oracle/backup/';
Starting backup at 2017-11-01 09:02:25
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=00006 name=/mnt/ramdisk/book/tea01.dbf
channel ORA_DISK_1: starting piece 1 at 2017-11-01 09:02:26
channel ORA_DISK_1: finished piece 1 at 2017-11-01 09:02:27
piece handle=/home/oracle/backup/BOOK/backupset/2017_11_01/o1_mf_nnndf_TAG20171101T090225_dzl7921x_.bkp tag=TAG20171101T090225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2017-11-01 09:02:27

Starting Control File and SPFILE Autobackup at 2017-11-01 09:02:27
piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_11_01/o1_mf_s_958899747_dzl79354_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2017-11-01 09:02:28

$ tree /home/oracle/backup/BOOK/
/home/oracle/backup/BOOK/
|-- backupset
|   `-- 2017_11_01
|       `-- o1_mf_nnndf_TAG20171101T090225_dzl7921x_.bkp
`-- datafile
    `-- o1_mf_tea_dzl786k3_.dbf

--//有点像将/home/oracle/backup当作闪回区目录,非常像将备份放在闪回区.

目录
相关文章
|
Oracle 关系型数据库 Linux
[20180115]RMAN-06820.txt
[20180115]RMAN-06820.txt --//在备库做归档备份出现RMAN-06820的问题。就是如果在备库做全表,因为要做主库日志切换,一般执行rman target /会出现问题。
1416 0
|
Oracle 关系型数据库 测试技术
[20171225]RMAN-06808.txt
[20171225]RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect.txt --//朋友拿我的一些例子来测试遇到的RMAN-06808: SECTION SIZE cannot be used when piece limit is in effect问题.
947 0
|
关系型数据库
[20171221]RMAN-05501.txt
[20171221]RMAN-05501 aborting duplication of target database.txt --//昨天使用rman duplicate建立dg,出现如下错误: rman > duplicate target database for standby from active database; .
1068 0
|
Oracle 关系型数据库
[20171130]关于rman的一些总结.txt
[20171130]关于rman的一些总结.txt --//最近一直做rman相关测试,测试那个乱,没办法.无法从周围的人获得帮助,纯粹是自己的乱猜,乱测,不知道别人是否能看懂我写的东西.
1087 0
|
Oracle 关系型数据库 Shell
[20171121]rman backup as copy 2.txt
[20171121]rman backup as copy 2.txt --//昨天测试backup as copy ,备份时备份文件的文件头什么时候更新.是最后完成后还是顺序写入备份文件.
1011 0
|
Oracle 关系型数据库 Linux
[20171121]rman backup as copy.txt
[20171121]rman backup as copy.txt --//上个星期做数据文件块头恢复时,提到使用rman备份数据文件时,文件头数据库信息是最后写入备份集文件的,在filesperset=1的情况 --//下写入备份集文件中的倒数第2块就是文件头的备份.
1225 0
|
缓存 Oracle 关系型数据库
[20171122]rman filesystemio_options.txt
[20171122]rman备份与参数filesystemio_options设置.txt --//这几天写了几篇filesystemio_options参数设置的文章,单独测试这个参数对rman备份以及os缓存的影响.
985 0
|
Oracle 关系型数据库 数据库
[20170616]recover copy of datafile 6.txt
[20170616]no copy of datafile 6 found to recover.txt --//最近几天一直被这个问题纠缠,我虽然不知道问题在哪来,还是找到简单的解决方法,做1个记录: --//链接:http://www.
1151 0
|
Oracle 关系型数据库
[20170310]V$RMAN_OUTPUT的stamp 2.txt
[20170310]V$RMAN_OUTPUT的stamp 2.txt http://blog.itpub.net/267265/viewspace-1979123/ --//以前写的,今天才发现自己再次犯严重的错误.
933 0
|
Oracle 关系型数据库 API
[20170208]rman tape.txt
[20170208]rman tape.txt --前一阵子,同事测试使用磁带做rman备份,留下一些备份信息在控制文件,要清除. --我依稀记得我以前也干过这些事情,晚上看了一下书: Apress.
983 0