g单机文件系统转化为RACASM.docx
- 文档编号:230679
- 上传时间:2022-10-07
- 格式:DOCX
- 页数:9
- 大小:14.10KB
g单机文件系统转化为RACASM.docx
《g单机文件系统转化为RACASM.docx》由会员分享,可在线阅读,更多相关《g单机文件系统转化为RACASM.docx(9页珍藏版)》请在冰豆网上搜索。
10G单机转RAC
转换采用建立一套完整的10.2.0.5的RAC环境,建立和原单机相同的实例名的数据库,方便不需要再修改CRS信息。
RAC安装过程省略。
转换前单机检查
SQL>selectfile_name,sum(bytes)/1024/1024fromdba_data_filesgroupbyfile_name;
SQL>/
FILE_NAMESUM(BYTES)/1024/1024
------------------------------------------------------------
/oracle/app/oradata/orcl/test2.dbf500
/oracle/app/oradata/orcl/system01.dbf480
/oracle/app/oradata/orcl/test3.dbf500
/oracle/app/oradata/orcl/sysaux01.dbf240
/oracle/app/oradata/orcl/test1.dbf500
/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
RMAN>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
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
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
channelORA_DISK_1:
startingpiece1at04-SEP-11
channelORA_DISK_1:
finishedpiece1at04-SEP-11
piecehandle=/oracle/install/bak/df_t760990978_s4_p1tag=TAG20110904T182257
comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
01:
45
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
includingcurrentcontrolfileinbackupset
includingcurrentSPFILEinbackupset
channelORA_DISK_1:
startingpiece1at04-SEP-11
channelORA_DISK_1:
finishedpiece1at04-SEP-11
piecehandle=/oracle/install/bak/df_t760991083_s5_p1tag=TAG20110904T182257
comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
03
Finishedbackupat04-SEP-11
RMAN>
备份文件放在/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磁盘组中:
RMAN>restorecontrolfileto'+date1/orcl/control01.ctl'from'/oracle/install/bak/control03.ctl';
Startingrestoreat05-SEP-11
usingchannelORA_DISK_1
channelORA_DISK_1:
copiedcontrolfilecopy
Finishedrestoreat05-SEP-11
RMAN>restorecontrolfileto'+date1/orcl/control02.ctl'from'/oracle/install/bak/control03.ctl';
Startingrestoreat05-SEP-11
usingchannelORA_DISK_1
channelORA_DISK_1:
copiedcontrolfilecopy
Finishedrestoreat05-SEP-11
RMAN>restorecontrolfileto'+date2/orcl/control03.ctl'from'/oracle/install/bak/control03.ctl';
Startingrestoreat05-SEP-11
usingchannelORA_DISK_1
channelORA_DISK_1:
copiedcontrolfilecopy
Finishedrestoreat05-SEP-11
关闭数据库,修改参数文件中控制文件路径指定到ASM磁盘组中指定位置。
SQL>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='UNDOTBS1'
恢复数据文件
RMAN>run{
setnewnamefordatafile1to'+data1';
setnewnamefordatafile2to'+data1';
setnewnamefordatafile3to'+data1';
setnewnamefordatafile4to'+data1';
setnewnamefordatafile5to'+data1';
setnewnamefordatafile6to'+data1';
setnewnamefordatafile7to'+data1';
setnewnamefordatafile8to'+data1';
setnewnamefordatafile9t
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 单机 文件系统 转化 RACASM