开发者社区> lfreeali> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

[20121126]backup as copy datafile 1的问题.txt

简介: [20121126]backup as copy datafile 1的问题.txtSQL> select * from v$version where rownumBANNER------------------------------------------...
+关注继续查看
[20121126]backup as copy datafile 1的问题.txt

SQL> select * from v$version where rownumBANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TEST 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 COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f'; # default

在使用rman备份的时候,为什么出现如下提示呢?
RMAN> backup as copy datafile 1 format '/data/testtest/system01.dbf';
Starting backup at 2012-11-26 11:33:19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle11g/oradata/test/system01.dbf
output file name=/data/testtest/system01.dbf tag=TAG20121126T113322 RECID=3 STAMP=800364837
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
copying current control file
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/26/2012 11:33:59
ORA-01580: error creating control backup file /data/testtest/system01.dbf
ORA-27038: created file already exists
Additional information: 1
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2012-11-26 11:33:59
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/26/2012 11:34:00
ORA-19504: failed to create file "/data/testtest/system01.dbf"
ORA-27038: created file already exists
Additional information: 1

--这是备份或者as copy datafile 1文件时,要自动做control file以及spfile文件的备份。而以上format的格式已经设置死了,就是
--format '/data/testtest/system01.dbf',由于文件已经存在,备份控制文件以及spfile文件失败。出现如上的错误。

--如果这样写,问题就不存在了。

RMAN> backup as copy datafile 1 format '/data/testtest/system01_%U.dbf';

Starting backup at 2012-11-26 11:39:59
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle11g/oradata/test/system01.dbf
output file name=/data/testtest/system01_data_D-TEST_I-2071943378_TS-SYSTEM_FNO-1_0lnr96kh.dbf tag=TAG20121126T114000 RECID=4 STAMP=800365230
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/data/testtest/system01_cf_D-TEST_id-2071943378_0mnr96ll.dbf tag=TAG20121126T114000 RECID=5 STAMP=800365241
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2012-11-26 11:40:45
channel ORA_DISK_1: finished piece 1 at 2012-11-26 11:40:46
piece handle=/data/testtest/system01_0nnr96lt_1_1.dbf tag=TAG20121126T114000 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2012-11-26 11:40:46

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Can‘t bind to formControl since it isn‘t a known property of input错误消息的处理
试图给input标签页施加formControl这个Directive的时候,出现如下错误:
40 0
Access the OData service exposed by your CDS view via Smart Business Tile
It is possible to configure a Smart business tile which consumes the OData service exposed by your CDS view. Create a new KPI definition:
35 0
SAP UI5:how to connect mock data
Created by Wang, Jerry, last modified on Feb 02, 2015
31 0
[20171122]rman backup as copy的备份问题
[20171122]rman backup as copy的备份问题.txt --//以前曾经写过一篇[20160524]rman备份与检查点4.txt=>链接:http://blog.
1016 0
Codeforces Round #442 (Div. 2) A B
A. Alex and broken contest time limit per test2 seconds memory limit per test256 megaby...
916 0
[20160421]backup as copy问题2.txt
[20160421]backup as copy问题2.txt http://blog.itpub.net/267265/viewspace-2070878/ --前面提到使用backup as copy datafile 1 format '/home/orac...
987 0
[20160329]backup as copy问题.txt
[20160329]backup as copy问题.txt --别人问的一个问题,想通过dg建立测试库,我建议他停止日志应用,然后使用拷贝的方式建立测试库,只要路径一样,生成一个新的控 --制文件就ok了。
674 0
ORA-01157: cannot identify/lock data file %s - see DBWR trace file的处理
<span style="color:rgb(102,102,102); font-family:宋体,Arial; line-height:26px">一个测试环境,由于主机工程师更换存储,在没有停数据库的情况下关闭操作系统,导致启动数据库时报ORA-</span><span style="color:rgb(102,102,102); font-family:宋体,Arial; lin
2374 0
OpenGL ES From the Ground Up, Part 2: A Look at Simple Drawing
MONDAY, APRIL 20, 2009 OpenGL ES From the Ground Up, Part 2: A Look at Simple Drawing Okay, there's still a lot of theory to ta...
1338 0
+关注
lfreeali
熟悉oracle数据库性能优化,rman备份,数据库恢复技术.
2121
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载