g单机文件系统转化为RACASM文档格式.docx
《g单机文件系统转化为RACASM文档格式.docx》由会员分享，可在线阅读，更多相关《g单机文件系统转化为RACASM文档格式.docx（9页珍藏版）》请在冰豆网上搜索。
/oracle/app/oradata/orcl/undotbs01.dbf25
/oracle/app/oradata/orcl/users01.dbf5
备份全库：
[oracle@linux-4~]$rmantarget/
RecoveryManager:
Release10.2.0.1.0-ProductiononSunSep418:
22:
132011
Copyright（c）1982,2005,Oracle.Allrightsreserved.
connectedtotargetdatabase:
ORCL（DBID=1288768796）
RMAN>
listbackup;
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
backupformat'
/oracle/install/bak/df_t%t_s%s_p%p'
database;
Startingbackupat04-SEP-11
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=135devtype=DISK
startingfulldatafilebackupset
specifyingdatafile（s）inbackupset
inputdatafilefno=00005name=/oracle/app/oradata/orcl/test1.dbf
inputdatafilefno=00006name=/oracle/app/oradata/orcl/test2.dbf
inputdatafilefno=00007name=/oracle/app/oradata/orcl/test3.dbf
inputdatafilefno=00001name=/oracle/app/oradata/orcl/system01.dbf
inputdatafilefno=00003name=/oracle/app/oradata/orcl/sysaux01.dbf
inputdatafilefno=00002name=/oracle/app/oradata/orcl/undotbs01.dbf
inputdatafilefno=00004name=/oracle/app/oradata/orcl/users01.dbf
startingpiece1at04-SEP-11
finishedpiece1at04-SEP-11
piecehandle=/oracle/install/bak/df_t760990978_s4_p1tag=TAG20110904T182257
comment=NONE
backupsetcomplete,elapsedtime:
00:
01:
45
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
piecehandle=/oracle/install/bak/df_t760991083_s5_p1tag=TAG20110904T182257
00:
03
Finishedbackupat04-SEP-11
备份文件放在/oracle/install/bak并且拷贝所有的参数文件，控制文件和日志文件到/oracle/install/bak。
修改参数文件内容，指定控制文件位置
orcl.__db_cache_size=142606336
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=62914560
orcl.__streams_pool_size=0
*.audit_file_dest='
/oracle/app/admin/orcl/adump'
*.background_dump_dest='
/oracle/app/admin/orcl/bdump'
*.compatible='
10.2.0.1.0'
*.control_files='
+date2/abc/con.ctl'
*.core_dump_dest='
/oracle/app/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain='
'
*.db_file_multiblock_read_count=16
*.db_name='
orcl'
*.dispatchers='
（PROTOCOL=TCP）（SERVICE=orclXDB）'
*.job_queue_processes=10
*.log_archive_dest_1='
location=/oracle/arch'
*.open_cursors=300
*.pga_aggregate_target=71303168
*.processes=150
*.remote_login_passwordfile='
EXCLUSIVE'
*.sga_target=216006656
*.undo_management='
AUTO'
*.undo_tablespace='
UNDOTBS1'
*.user_dump_dest='
/oracle/app/admin/orcl/udump'
利用备份的控制文件恢复控制文件到ASM磁盘组中：
restorecontrolfileto'
+date1/orcl/control01.ctl'
from'
/oracle/install/bak/control03.ctl'
;
Startingrestoreat05-SEP-11
usingchannelORA_DISK_1
copiedcontrolfilecopy
Finishedrestoreat05-SEP-11
+date1/orcl/control02.ctl'
+date2/orcl/control03.ctl'
关闭数据库，修改参数文件中控制文件路径指定到ASM磁盘组中指定位置。
createSPFILE='
+DATE2/orcl/spfileorcl.ora'
frompfile='
/oracle/install/bak/initorcl.ora'
修改参数文件
加入参数：
*.cluster_database_instances=2
*.cluster_database=true
*.db_create_file_dest='
+DATE2'
orcl2.instance_number=2
orcl1.instance_number=1
orcl2.thread=2
orcl1.thread=1
orcl2.undo_tablespace='
UNDOTBS2'
orcl1.undo_tablespace='
恢复数据文件
run{
setnewnamefordatafile1to'
+data1'
setnewnamefordatafile2to'
setnewnamefordatafile3to'
setnewnamefordatafile4to'
setnewnamefordatafile5to'
setnewnamefordatafile6to'
setnewnamefordatafile7to'
setnewnamefordatafile8to'
setnewnamefordatafile9t
升级会员 