环境:
Oracle database 10.2.0.5
Primary RAC + ASM
+ Non-ASM Standby Single 实例
目录
OS Oracle Linux 6 1。近日遇到一个小问题,在备用上连接controlfile进行全库备份,备份完成后,通过list bakcup,查询到的数据文件路径是“u01/数据/* * * *”
[美元,rman target /经理:Recovery Release 10.2.0.5.0 作用;Production 提醒Mon Sep 5 15:39:55 2016
Copyright (c), 1982年,2007年,甲骨文只All rights 保留。
数据库:connected 用target ORA10G (DBID=4146617466,, not 打开)
RMAN>, backup 数据库;
Starting backup at 05-SEP-16
using target database control file instead of recovery 目录
allocated 频道:ORA_DISK_1
channel ORA_DISK_1:, sid=160, devtype=磁盘
channel ORA_DISK_1:, starting full datafile backupset
channel ORA_DISK_1:, specifying 功能(s) backupset拷贝
input datafile fno=00001, name=/u01/数据/datafilesystem.259.827745351
input datafile fno=00002, name=/u01/数据/datafileundotbs1.260.827745359
input datafile fno=00004, name=/u01/数据/datafileundotbs2.263.827745369
input datafile fno=00003, name=/u01/数据/datafilesysaux.261.827745363
input datafile fno=00005, name=/u01/数据/datafileusers.264.827745371
……
Finished backup at 05-SEP-16
RMAN>, list 备份;
List of Backup 集===================BS Key Type LV Size Device Type Elapsed Time Completion 时间
- - - - - - - - - - -女人;-,- - - - - - - - - - -,- - - - - - - - - - -女人,- - - - - - - - - - - -,- - - - - - - - - - - - - - - - - -
5,Full 202.54 m DISK 00:00:11 05-SEP-16
关键:BP 5,状态:,AVAILABLE 压缩:,NO 标签:TAG20160905T152357
名称:Piece /u01/app/数据库/dbs/06 rf26kf_1_1
List of Datafiles 拷贝backup set 5
File LV Type Ckp SCN Ckp Time 名字
- - - - -,-,- - - - -,- - - - - - - - - - -,- - - - - - -安康;- - - - -
1,Full 345345, 05-SEP-16 /u01/数据/datafilesystem.259.827745351
2,Full 345345, 05-SEP-16 /u01/数据/datafileundotbs1.260.827745359
3,Full 345345, 05-SEP-16 /u01/数据/datafilesysaux.261.827745363
4,Full 345345, 05-SEP-16 /u01/数据/datafileundotbs2.263.827745369
5,Full 345345, 05-SEP-16 /u01/数据/datafileusers.264.827745371 & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt; & lt;/u01/数据/ 2只;但是在连接到目录,并同步之后,发现数据文件的路径变成“+数据/ora10g/功能/* * *”,,这是主要的数据库的实际路径只
,美元rman target /, catalog rman/rman@catalog
RMAN>, list 备份;
BS Key Type LV Size Device Type Elapsed Time Completion 时间
- - - - - - - - - - -女人;-,- - - - - - - - - - -,- - - - - - - - - - -女人,- - - - - - - - - - - -,- - - - - - - - - - - - - - - - - -
157年,Full 202.54 m DISK 00:00:11 05-SEP-16
关键:BP 159年,状态:,AVAILABLE 压缩:,NO 标签:TAG20160905T152357
名称:Piece /u01/app/数据库/dbs/06 rf26kf_1_1
List of Datafiles 拷贝backup set 157
File LV Type Ckp SCN Ckp Time 名字
- - - - -,-,- - - - -,- - - - - - - - - - -,- - - - - - -安康;- - - - -
1,Full 345345, 05-SEP-16 +数据/ora10g/功能/system.259.827745351
2,Full 345345, 05-SEP-16 +数据/ora10g/功能/undotbs1.260.827745359
3,Full 345345, 05-SEP-16 +数据/ora10g/功能/sysaux.261.827745363
4,Full 345345, 05-SEP-16 +数据/ora10g/功能/undotbs2.263.827745369
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
