来源:蜘蛛抓取(WebSpider)
时间:2016-05-28 04:29
标签:
.asm是什么文件
3.使用ASMCMD删除ASM中已有的SYSAUX表空间的数据文件
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有
Microsoft Corp.
C:\WINDOWS&set ORACLE_HOME=f:\oracle\product/10.2.0
C:\WINDOWS&set ORACLE_SID=+asm
C:\WINDOWS&asmcmd
ASMCMD& ls
ASMCMD& cd test
ASMCMD& ls
redo04.log
redo05.log
redo06.log
temp01.dbf
ASMCMD& cd test
ASMCMD& ls
BACKUPSET/
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
control01.ctl
control02.ctl
ASMCMD& cd datafile
ASMCMD& ls
SYSAUX.257.
SYSTEM.258.
TEST_BIG.262.
UNDOTBS1.259.
USERS.260.
ASMCMD& rm SYSAUX.257.
ASMCMD& ls
SYSTEM.258.
TEST_BIG.262.
UNDOTBS1.259.
USERS.260.
ASMCMD&
4.修改备份的数据文件名(这步也可以不需要,在备份的时候直接备份到需要的位置即可)
从F:\sysaux01.dbf移动至F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DB
5.修改数据库的控制文件,将原来SYSAUX的数据文件由ASM下改名到备份的文件
RMAN& run
2& {set newname for datafile '+TEST/test/datafile/sysaux.257.' to 'F:\oracle\product\oradata\test\sysaux01.dbf';
由于移动了备份的文件的位置(从F:\sysaux01.dbf移动至F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DB),而新的文件没有catalog,所以报错了
executing command: SET NEWNAME
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch command at 06/20/:02
RMAN-20230: datafile copy not found in the recovery catalog
RMAN-06015: error while looking up datafile copy name: F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DBF
6.将移动后的备份数据文件catalog
RMAN& catalog datafilecopy 'F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DBF';
cataloged datafile copy
datafile copy filename=F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DBF recid=14 stamp=
7.重新修改数据文件的位置
RMAN& run
2& {set newname for datafile '+TEST/test/datafile/sysaux.257.' to 'F:\oracle\product\oradata\test\sysaux01.dbf';
executing command: SET NEWNAME
datafile 3 switched to datafile copy
input datafile copy recid=14 stamp= filename=F:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DBF
8.恢复数据文件
RMAN& recover datafile 3;
Starting recover at 20-JUN-08
configuration for DISK channel 2 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 20-JUN-08
9.打开数据库,此时SYSAUX表空间的数据文件已经由ASM下转移为普通文件
RMAN& sql 'alter database open';
sql statement: alter database open
【】【】【】【】
········
《全国专业技术人员计算机应用能力考试标准教程—word&2003中文字处理》严格根据..
定价:¥39.50
优惠价:¥29.60&&本书适合报考全国专业技术人员计算机应用能力考试“中文windows&xp操作系统”科目的..
定价:¥39.50
优惠价:¥29.60&&
············
············
Copyright ©
() All Rights Reserved