rac转单机方案.docx
- 文档编号:5822835
- 上传时间:2023-01-01
- 格式:DOCX
- 页数:17
- 大小:694.55KB
rac转单机方案.docx
《rac转单机方案.docx》由会员分享,可在线阅读,更多相关《rac转单机方案.docx(17页珍藏版)》请在冰豆网上搜索。
rac转单机方案
●创建与rac主机相同的目录
如/backup/rmanbak/level0/20120209010001/4
都是在压缩包所在的目录下tar-cvforacle0208.taroracletar-xvforacle0113.tar
●传输rac上的备份集到单机上
节点2上的备份包含数据文件及归档的备份集
scpdblv0_731_1_774752412root@10.0.2.16:
/backup/rmanbak/level0/20120209010001/4
scpdblv0_732_1_774752412root@10.0.2.16:
/backup/rmanbak/level0/20120209010001/4
scpdblv0_733_1_774755639root@10.0.2.16:
/backup/rmanbak/level0/20120209010001/4
过程如下:
文件大致需要传输6分钟
节点1上传输控制文件的备份在(注意不是节点2上的控制文件的备份)
测试机上接收到的备份集
注意更改这些文件的属性chown-Roracle:
dba*
●测试机上创建pfile及相关目录
*.audit_file_dest='/app/oracle/admin/orcl/adump'
*.background_dump_dest='/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oradata/orcl/controlfile1.ctl','/oradata/orcl/controlfile2.ctl','/oradata/orcl/controlfile3.ctl'
*.core_dump_dest='/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.dispatchers='(PROTOCOL=TCP)(SERVICE=ORCLDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/archive/orcl'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=1000
*.pga_aggregate_target=2205838336
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1655
*.sga_target=5617515008
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='/app/oracle/admin/orcl/udump'
●测试机上启动实例orcl,并开始恢复数据文件
修改profile改正ORACLE_SID=orcl;exportORACLE_SID
使ORACLE_SID=orcl进入到该orcl的实例,以pfile启动的
进入到rman中
注意应该是
restorecontrolfilefrom'/backup/rmanbak/level0/20120209010001/4/controlfile_c-1129995432-20120209-01';
使其进入mount状态
查看数据文件
一些命令的查看设置exportNLS_DATE_FORMAT='yyyy-mm-ddhh24:
mi:
ss'
listbackupsummary;
RMAN>listbackupofarchivelogallsummary;
RMAN>listbackupofarchivelogall;注意只有516和518备份集中有2月9日备份的归档
注意恢复的时候可以用RMAN>restoredatabasepreviewsummary;这个命令的速度很快!
Restore过程,为了加快速度,所以使用了4个通道。
本次开始的时间是11:
37分。
耗时约2小时
run{
allocatechannelc1devicetypedisk;
allocatechannelc2devicetypedisk;
allocatechannelc3devicetypedisk;
allocatechannelc4devicetypedisk;
setnewnamefordatafile1to'/oradata/orcl/system01.dbf';
setnewnamefordatafile2to'/oradata/orcl/user02.dbf';
setnewnamefordatafile3to'/oradata/orcl/sysaux01.dbf';
setnewnamefordatafile4to'/oradata/orcl/users01.dbf';
setnewnamefordatafile5to'/oradata/orcl/geostk_detail01.dbf';
setnewnamefordatafile6to'/oradata/orcl/geo200801.dbf';
setnewnamefordatafile7to'/oradata/orcl/databxstkmdtl02.dbf';
setnewnamefordatafile8to'/oradata/orcl/geo2008index03.dbf';
setnewnamefordatafile9to'/oradata/orcl/geo200805.dbf';
setnewnamefordatafile10to'/oradata/orcl/databxsp01.dbf';
setnewnamefordatafile11to'/oradata/orcl/databxbatch01.dbf';
setnewnamefordatafile12to'/oradata/orcl/databxrob01.dbf';
setnewnamefordatafile13to'/oradata/orcl/databxstkdtl01.dbf';
setnewnamefordatafile14to'/oradata/orcl/databxaccdtl01.dbf';
setnewnamefordatafile15to'/oradata/orcl/databxstkmdtl01.dbf';
setnewnamefordatafile16to'/oradata/orcl/bxbb01.dbf';
setnewnamefordatafile17to'/oradata/orcl/bxbb02.dbf';
setnewnamefordatafile18to'/oradata/orcl/geo200802.dbf';
setnewnamefordatafile19to'/oradata/orcl/geo200803.dbf';
setnewnamefordatafile20to'/oradata/orcl/geo2008index01.dbf';
setnewnamefordatafile21to'/oradata/orcl/geo2008index02.dbf';
setnewnamefordatafile22to'/oradata/orcl/undotbs02.dbf';
setnewnamefordatafile24to'/oradata/orcl/geo200804.dbf';
setnewnamefordatafile25to'/oradata/orcl/benetz_todo01.dbf';
setnewnamefordatafile29to'/oradata/orcl/undotbs1.dbf';
setnewnamefordatafile30to'/oradata/orcl/undotbs2.dbf';
restoredatabase;
switchdatafileall;
releasechannelc1;
releasechannelc2;
releasechannelc3;
releasechannelc4;}
关于归档
在listbackupofarchivelogall;中可以看到
BSKey518中有2月9日备份的归档----这是1机的归档备份
11430930279869172012-02-0901:
24:
13930280967812012-02-0902:
48:
24
11431930280967812012-02-0902:
48:
24930280971472012-02-0902:
48:
48
BSKey516中有2月9日备份的归档----这是2机的归档备份
2744930280967832012-02-0902:
47:
01930280971082012-02-0902:
47:
23
根据上面的可以看到(1,1431,93028097147);(2,744,93028097108)所以选择2恢复
RMAN>run{
setuntilsequence745thread2;
recoverdatabase;
}
在SQL>selectTHREAD#,SEQUENCE#,NEXT_CHANGE#,namefromv$archived_log中查到
为了完全恢复,则不使用上面的until了。
看节点1下的归档
为了最大限度的恢复scp1_143*.dbfroot@10.0.2.16:
/archive/orcl
scp1_144*.dbfroot@10.0.2.16:
/archive/orcl将2.9日备份时间后的所有归档都考过了
恢复完后,我建议先备份恢复出来的数据文件夹
然后用sqlplus的recover进行恢复
此时不能打开的!
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo06.log'to'/oradata/chunjierac/redo06.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo07.log'to'/oradata/chunjierac/redo07.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo01.log'to'/oradata/chunjierac/redo01.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo02.log'to'/oradata/chunjierac/redo02.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo03.log'to'/oradata/chunjierac/redo03.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo04.log'to'/oradata/chunjierac/redo04.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo05.log'to'/oradata/chunjierac/redo05.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo8.log'to'/oradata/chunjierac/redo8.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo9.log'to'/oradata/chunjierac/redo9.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo10.log'to'/oradata/chunjierac/redo10.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo11.log'to'/oradata/chunjierac/redo11.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo12.log'to'/oradata/chunjierac/redo12.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo13.log'to'/oradata/chunjierac/redo13.log';
alterdatabaserenamefile'+DG_DATA/orcl/onlinelog/redo14.log'to'/oradata/chunjierac/redo14.log';
查看下
SELECTa.group#,a.member,b.bytesFROMv$logfilea,v$logbWHEREa.group#=b.group#;
后续操作
SQL>selectTHREAD#,STATUS,ENABLEDfromv$thread;
SQL>alterdatabasedisablethread2;
SQL>selectgroup#fromv$logwhereTHREAD#=2;
使用SQL>alterdatabasedroplogfilegroup****或者SQL>alterdatabaseclearunarchivedlogfilegroup9;
SQL>selectgroup#,memberfromv$logfile;
对undo的处理:
它的redo比较特别,一般的都是UNDOTBS2和UNDOTBS1
SQL>droptablespaceUNDOTBS2includingcontentsanddatafiles;
SQL>selecttablespace_namefromdba_tablespaceswherecontents='UNDO';
对temp的处理:
SQL>selectnamefromv$tempfile;
NAME
--------------------------------------------------------------------------------
+DG_DATA/orcl/tempfile/temp02.dbf
SQL>selecttablespace_namefromdba_tablespaceswherecontents='TEMPORARY';
TABLESPACE_NAME
------------------------------
TEMP
SQL>createtemporarytablespaceTEMP1tempfile'/oradata/****/temp01.dbf'size100Mautoextendoff;
Tablespacecreated.
SQL>alterdatabasedefaulttemporarytablespaceTEMP1;
Databasealtered.
SQL>droptablespaceTEMPincludingcontentsanddatafiles;
Tablespacedropped.
SQL>selectnamefromv$tempfile;
NAME
--------------------------------------------------------------------------------
/oradata/chunjierac/temp01.dbf
监听配置
orcl=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dg02)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=orcl)
)
)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- rac 单机 方案