[20171101]rman to destination.txt

[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当作闪回区目录,非常像将备份放在闪回区.

时间： 2024-09-20 15:23:59

[20171101]rman to destination.txt的相关文章

[20171130]关于rman备份疑问.txt

[20171130]关于rman备份疑问.txt --//前面测试太乱,重新做一些rman as copy相关测试. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- --------------------------------------------------------------

[20171206]rman与truncate.txt

[20171206]rman与truncate.txt --//昨天下班在回家的路上,突然想起以前遇到的问题,就是truncate表后,rman做备份时会备份多少truncate表的信息, --//当时在itpub上,还存在讨论,就是rman会备份空block吗?参考链接:http://www.itpub.net/thread-2050864-9-1.html --//zergduan兄还开了SR,答复如下: 终于有回复了 经过dump的确认,unused block compression 特

[20171031]rman xxx Failure.txt

[20171031]rman xxx Failure.txt --//简单测试 List Failure, Advise Failure and Repair Failure命令在11g下,也许以后工作需要. --//虽然我自己很少使用这个命令,感觉这个有点傻瓜化. 1.环境: SYS@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ ----

[20170626]rman merge例子.txt

[20170626]rman merge例子.txt 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux

[20171208]rman与truncate3.txt

[20171208]rman与truncate3.txt --//前几天测试truncate表依旧备份一部分信息,测试几次确定备份8extent.当时的测试几个extents是相邻的. --//今天补充测试如果数据分布是离散的,情况是否一样? 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER ------------------------------ --------------

[20130803]ORACLE 12C RMAN 功能增强.txt

[20130803]ORACLE 12C RMAN 功能增强.txt 在oracle 12c rman中可以直接输入sql语句,缺点就是仅仅输出最大仅仅80列,不知道如何调整. d:\tmp>rman target sys/xxxx@test01p Recovery Manager: Release 12.1.0.1.0 - Production on Fri Aug 2 22:53:49 2013 Copyright (c) 1982, 2013, Oracle and/or its affi

[20130412]rman备份文件大小.txt

[20130412]rman备份文件大小.txt 记得以前看rman的书,rman仅仅备份已经格式话的块,如果这样一个表被truncate后,即使空间回收了.但是在rman备份时,备份大小不会变化太多,这些前面使用的块一定会备份.实际的测试情况是,备份文件会变小. 测试的链接:http://space.itpub.net/267265/viewspace-750049 如果是索引删除的情况呢?自己不能凭想象,还是做测试来看看. 1.测试环境: SQL> @verBANNER-----------

[20171031]rman merge例子2.txt

[20171031]rman merge例子2.txt --//以前做的测试 [20170626]rman merge例子.txt --//链接 http://blog.itpub.net/267265/viewspace-2141253/ --//不断应用日志,常用的方式如下: 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER --------------------------

Oracle数据库rman备份计划及恢复

原文:http://www.cnblogs.com/vijayfly/p/5045175.html 1.rman完全恢复的前提条件:历史的datafile,controlfile和spfile备份,加上完整的archivelog和完好的redolog. 2.rman备份脚本: a.RMAN 0级备份命令: run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk