g单机文件系统转化为RACASM.docx
- 文档编号:1214177
- 上传时间:2023-04-30
- 格式: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';
setnewnamefordatafile9to'+data1';
setnewnamefordatafile10to'+data1';
setnewnamefordatafile11to'+data1';
restoredatabase;
switchdatafileall;
}
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
executingcommand:
SETNEWNAME
Startingrestoreat07-SEP-11
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=145instance=orcl1devtype=DISK
channelORA_DISK_1:
startingdatafilebackupsetrestore
channelORA_DISK_1:
specifyingdatafile(s)torestorefrombackupset
restoringdatafile00001to+DATA1
restoringdatafile00002to+DATA1
restoringdatafile00003to+DATA1
restoringdatafile00004to+DATA1
restoringdatafile00005to+DATA1
restoringdatafile00006to+DATA1
restoringdatafile00007to+DATA1
restoringdatafile00008to+DATA1
restoringdatafile00009to+DATA1
restoringdatafile00010to+DATA1
restoringdatafile00011to+DATA1
channelORA_DISK_1:
readingfrombackuppiece/oracle/soft/bak/df_t761145085_s2_p1
channelORA_DISK_1:
restoredbackuppiece1
piecehandle=/oracle/soft/bak/df_t761145085_s2_p1tag=TAG20110906T131125
channelORA_DISK_1:
restorecomplete,elapsedtime:
00:
04:
08
Finishedrestoreat07-SEP-11
datafile1switchedtodatafilecopy
inputdatafilecopyrecid=12stamp=761236767filename=+DATA1/orcl/datafile/system.266.761236525
datafile2switchedtodatafilecopy
inputdatafilecopyrecid=13stamp=761236767filename=+DATA1/orcl/datafile/undotbs1.263.761236523
datafile3switchedtodatafilecopy
inputdatafilecopyrecid=14stamp=761236767filename=+DATA1/orcl/datafile/cwmlite.259.761236531
datafile4switchedtodatafilecopy
inputdatafilecopyrecid=15stamp=761236767filename=+DATA1/orcl/datafile/drsys.258.761236537
datafile5switchedtodatafilecopy
inputdatafilecopyrecid=16stamp=761236767filename=+DATA1/orcl/datafile/example.265.761236527
datafile6switchedtodatafilecopy
inputdatafilecopyrecid=17stamp=761236767filename=+DATA1/orcl/datafile/indx.261.761236529
datafile7switchedtodatafilecopy
inputdatafilecopyrecid=18stamp=761236768filename=+DATA1/orcl/datafile/odm.257.761236537
datafile8switchedtodatafilecopy
inputdatafilecopyrecid=19stamp=761236768filename=+DATA1/orcl/datafile/tools.256.761236539
datafile9switchedtodatafilecopy
inputdatafilecopyrecid=20stamp=761236768filename=+DATA1/orcl/datafile/users.264.761236529
datafile10switchedtodatafilecopy
inputdatafilecopyrecid=21stamp=761236768filename=+DATA1/orcl/datafile/xdb.262.761236529
datafile11switchedtodatafilecopy
inputdatafilecopyrecid=22stamp=761236768filename=+DATA1/orcl/datafile/sysaux.267.761236521
SQL>selectnamefromv$datafile;
NAME
--------------------------------------------------------------------------------
+DATA1/orcl/datafile/system.266.761236525
+DATA1/orcl/datafile/undotbs1.263.761236523
+DATA1/orcl/datafile/cwmlite.259.761236531
+DATA1/orcl/datafile/drsys.258.761236537
+DATA1/orcl/datafile/example.265.761236527
+DATA1/orcl/datafile/indx.261.761236529
+DATA1/orcl/datafile/odm.257.761236537
+DATA1/orcl/datafile/tools.256.761236539
+DATA1/orcl/datafile/users.264.761236529
+DATA1/orcl/datafile/xdb.262.761236529
+DATA1/orcl/datafile/sysaux.267.761236521
11rowsselected.
修改对应日志文件路径:
SQL>selectmemberfromv$logfile;
MEMBER
--------------------------------------------------------------------------------
/oradata/orcl/redo03.log
/oradata/orcl/redo02.log
/oradata/orcl/redo01.log
SQL>alterdatabaserenamefile'/oradata/orcl/redo02.log'to'/oracle/soft/bak/redo02.log';
Databasealtered.
SQL>alterdatabaserenamefile'/oradata/orcl/redo01.log'to'/oracle/soft/bak/redo01.log';
Databasealtered.
SQL>alterdatabaserenamefile'/oradata/orcl/redo03.log'to'/oracle/soft/bak/redo03.log';
Databasealtered.
SQL>
SQL>selectgroup#,thread#,statusfromv$log;
SQL>selectgroup#,thread#,statusfromv$log;
GROUP#THREAD#STATUS
------------------------------------
11CURRENT
31INACTIVE
21INACTIVE
SQL>selectmemberfromv$logfile;
MEMBER
--------------------------------------------------------------------------------
/oracle/soft/bak/redo03.log
/oracle/soft/bak/redo02.log
/oracle/soft/bak/redo01.log
在一节点上打开数据库:
SQL>alterdatabaseopen;
alterdatabaseopen
*
ERRORatline1:
ORA-01113:
file1needsmediarecoveryifitwasrestoredfrombackup,orEND
BACKUPifitwasnot
ORA-01110:
datafile1:
'+DATA1/orcl/datafile/system.264.761246653'
SQL>recoverdatabase;
Mediarecoverycomplete.
SQL>alterdatabaseopen;
Databasealtered.
SQL>重建一节点日志并添加二节点日志文件组
添加一节点日志,并删除原日志
SQL>
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 单机 文件系统 转化 RACASM