oracle rman备份.docx
- 文档编号:4770783
- 上传时间:2022-12-08
- 格式:DOCX
- 页数:21
- 大小:21.54KB
oracle rman备份.docx
《oracle rman备份.docx》由会员分享,可在线阅读,更多相关《oracle rman备份.docx(21页珍藏版)》请在冰豆网上搜索。
oraclerman备份
一个完整的Oraclerman备份恢复参考示例
时间:
2008-05-2900:
00来源:
作者:
点击:
2889次【字号:
大中小】
一个完整的Oraclerman备份恢复参考示例,阅读一个完整的Oraclerman备份恢复参考示例,完整的Oraclerman备份恢复参考示例:
1、建rman库作为repository$morecreaterman_db1.shsetechoonspoolmakedb1.logcreatedatabasermandatafile
完整的Oraclerman备份恢复参考示例:
1、建rman库作为repository
$morecreaterman_db1.sh
setechoon
spoolmakedb1.log
createdatabaserman
datafile'/export/home/oracle/oradata/rman_data/system.dbf'size50mautoextend
onnext640K
logfile'/export/home/oracle/oradata/rman_data/redo0101.log'SIZE10M,
'/export/home/oracle/oradata/rman_data/redo0201.log'SIZE10M
maxdatafiles30
maxinstances8
maxlogfiles64
charactersetUS7ASCII
nationalcharactersetUS7ASCII
;
disconnect
spooloff
exit
@/export/home/oracle/8.1.6/rdbms/admin/catalog.sql;
REM**********ALTERSYSTEMTABLESPACE*********
ALTERTABLESPACESYSTEM
DEFAULTSTORAGE(INITIAL64KNEXT64KMINEXTENTS1MAXEXTENTSUNLIMITEDPCTINCR
EASE50);
ALTERTABLESPACESYSTEM
MINIMUMEXTENT64K;
REM**********TABLESPACEFORROLLBACK**********
CREATETABLESPACERBSDATAFILE'/export/home/oracle/oradata/rman_data/rbs.dbf's
ize50m
AUTOEXTENDONNEXT512K
MINIMUMEXTENT512K
DEFAULTSTORAGE(INITIAL512KNEXT512KMINEXTENTS10MAXEXTENTSUNLIMITEDPC
TINCREASE0);
REM**********TABLESPACEFORTEMPORARY**********
CREATETABLESPACETEMPDATAFILE'/export/home/oracle/oradata/rman_data/temp.dbf'
size50m
AUTOEXTENDONNEXT64K
MINIMUMEXTENT64K
DEFAULTSTORAGE(INITIAL64KNEXT64KMINEXTENTS1MAXEXTENTSUNLIMITEDPCTINCR
EASE0)TEMPORARY;
REM****Creatingfourrollbacksegments****************
CREATEPUBLICROLLBACKSEGMENTRBS_0TABLESPACERBS
STORAGE(OPTIMAL64000K);
ALTERROLLBACKSEGMENT"RBS_0"ONLINE;
REM****SYSandSYSTEMusers****************
alterusersystemporarytablespaceTEMP;
alterusersystemtemporarytablespaceTEMP;
disconnect
spooloff
exit
$morecreaterman_db3.sh
spoolcrdb3.log
@/export/home/oracle/8.1.6/rdbms/admin/catproc.sql
@/export/home/oracle/8.1.6/rdbms/admin/caths.sql
@/export/home/oracle/8.1.6/rdbms/admin/otrcsvr.sql
connectsystem/manager
@/export/home/oracle/8.1.6/sqlplus/admin/pupbld.sql
disconnect
spooloff
exit
2、建repository存放的表空间和rman用户
$morecreaterman_db4.sh
connectinternal
createtablespacerman_ts
datafile'/export/home/oracle/oradata/rman_data/rman_ts.dbf'
size20Mdefaultstorage(initial100Knext100Kpctincrease0);
createuserrman_hainanidentifiedbyrman_hainan
temporarytablespaceTEMP
defaulttablespacerman_tsquotaunlimitedon
rman_ts;
grantrecovery_catalog_ownertorman_hainan;
grantconnect,resourcetorman_hainan;
3、建catalog,注册目标数据库
$morecreaterman_db5.sh
rmancatalogrman_hainan/rman_hainan@rmanmsglog=rman.log
createcatalog;
exit;
rmantargetsys/oracle@db1
connectcatalogrman_hainan/rman_hainan@rman
registerdatabase;
exit;
4、可以开始做备份了
5、做全备
$morermanshell
./export/home/oracle/.profile
rmanrcvcatrman_hainan/rman_hainan@rmantarget/cmdfile/export/home/oracle/ba
ckup_level0.rcvlog/export/home/oracle/backup.log
$morebackup_level0.rcv
resynccatalog;
run{
allocatechannelt1typedisk;
backup
incrementallevel0
skipinaccessible
taghot_db_bk_level0
filesperset3
format'/export/home/oracle/bk_%s_%p_%t.bk'
(database);
sql'altersystemarchivelogcurrent';
backup
filesperset10
format'/export/home/oracle/a1_%s_%p_%t.ac'
(archivelogalldeleteinput);
backup
format'/export/home/oracle/df_t%t_s%s_p%p.ct'
currentcontrolfile;
}
6、做增备
$morermanshell1
rmanrcvcatrman_hainan/rman_hainan@rmantarget/cmdfilebackup_level1.rcvlog
backup.log
$morebackup_level1.rcv
resynccatalog;
run{
allocatechannelt1typedisk;
backup
incrementallevel1
skipinaccessible
taghot_db_bk_level1
filesperset3
format'bk_%s_%p_%t.bk1'
(database);
sql'altersystemarchivelogcurrent';
backup
filesperset10
format'a1_%s_%p_%t.ac1'
(archivelogalldeleteinput);
backupcurrentcontrolfile;
}
1、删除旧的全备
$rmanrcvcatrman_hainan/rman_hainan@rmantarget/
RecoveryManager:
Release8.1.6.0.0-Production
RMAN-06005:
connectedtotargetdatabase:
TEST(DBID=1692992254)
RMAN-06008:
connectedtorecoverycatalogdatabase
RMAN>listbackupset;
RMAN-03022:
compilingcommand:
list
ListofBackupSets
KeyRecidStampLVSetStampSetCountCompletionTime
-----------------------------------------------------------------------
38145399987408039998740615311-JUN-00
根据key来删除旧的备份。
RMAN>allocatechannelformaintenancetypedisk;
RMAN>changebackupset169delete;----------THISISTHECOMMANDTOREMOVETHEENTRY&OSFILE
做完后可以看到listbackupset和操作系统的文件都没有了。
2、恢复
(1)将数据库启动到nomount状态:
$svrmgrl
OracleServerManagerRelease3.1.6.0.0-Production
Copyright(c)1997,1999,OracleCorporation.AllRightsReserved.
Oracle8iEnterpriseEditionRelease8.1.6.0.0-64bitProduction
WiththePartitioningoption
JServerRelease8.1.6.0.0-Production
SVRMGR>connectinternal
Connected.
SVRMGR>startupnomount;
ORACLEinstancestarted.
TotalSystemGlobalArea339275684bytes
FixedSize94116bytes
VariableSize318685184bytes
DatabaseBuffers16384000bytes
RedoBuffers4112384bytes
SVRMGR>exit
ServerManagercomplete.
(2)恢复控制文件:
$rmanrcvcatrman_hainan/rman_hainan@rmantarget/
RecoveryManager:
Release8.1.6.0.0-Production
RMAN-06006:
connectedtotargetdatabase:
test(notmounted)
RMAN-06008:
connectedtorecoverycatalogdatabase
RMAN>run{
2>allocatechanneld1typedisk;
3>restorecontrolfile;
4>releasechanneld1;
5>}
(3)恢复数据文件
RMAN>run{
2>allocatechanneld1typedisk;
3>sql"alterdatabasemount";
4>restoredatafile1;
5>restoredatafile2;
6>restoredatafile3;
7>restoredatafile4;
8>releasechanneld1;
9>}
(4)恢复日志文件
RMAN>run{
2>setarchivelogdestinationto'/export/home/oracle/admin/test/arch';
3>allocatechanneld1typedisk;
4>restorearchivelogall;
5>releasechanneld1;
6>}
会把所有的日志文件恢复。
(5)根据日志做recover
$svrmgrl
OracleServerManagerRelease3.1.6.0.0-Production
Copyright(c)1997,1999,OracleCorporation.AllRightsReserved.
Oracle8iEnterpriseEditionRelease8.1.6.0.0-64bitProduction
WiththePartitioningoption
JServerRelease8.1.6.0.0-Production
SVRMGR>connectinternal
Connected.
SVRMGR>recoverdatabaseusingbackupcontrolfileuntilcancel;
ORA-00279:
change51054generatedat06/11/200011:
38:
37neededforthread1
ORA-00289:
suggestion:
/export/home/oracle/admin/test/arch/arch_1_3.arc
ORA-00280:
change51054forthread1isinsequence#3
Specifylog:
{=suggested|filename|AUTO|CANCEL}
Logapplied.
ORA-00279:
change51058generatedat06/11/200011:
38:
44neededforthread1
ORA-00289:
suggestion:
/export/home/oracle/admin/test/arch/arch_1_4.arc
ORA-00280:
change51058forthread1isinsequence#4
ORA-00278:
logfile'/export/home/oracle/admin/test/arch/arch_1_3.arc'nolonger
neededforthisrecovery
Specifylog:
{=suggested|filename|AUTO|CANCEL}
Logapplied.
ORA-00279:
change51074generatedat06/11/200011:
40:
20neededforthread1
ORA-00289:
suggestion:
/export/home/oracle/admin/test/arch/arch_1_5.arc
ORA-00280:
change51074forthread1isinsequence#5
ORA-00278:
logfile'/export/home/oracle/admin/test/arch/arch_1_4.arc'nolonger
neededforthisrecovery
Specifylog:
{=suggested|filename|AUTO|CANCEL}
cancel
Mediarecoverycancelled.
SVRMGR>alterdatabaseopenresetlogs;
Statementprocessed.
恢复完成。
SVRMGR>selecttable_namefromuser_tables;
TABLE_NAME
------------------------------
BONUS
DEPT
EMP
SALGRADE
TEST
TEST_ZMY
ZMY
ZMY_DEPT
ZMY_EMP
9rowsselected.
可以检查看到,所有的都恢复了,包括全备份后的事务。
(只要有归档日志,都可以恢复)。
3、恢复后rman数据库的同步
$rmanrcvcatrman_hainan/rman_hainan@rmantarget/
RecoveryManager:
Release8.1.6.0.0-Production
RMAN-06005:
connectedtotargetdatabase:
TEST(DBID=1692992254)
RMAN-06008:
connectedtorecoverycatalogdatabase
RMAN>resetdatabase;
RMAN-03022:
compilingcommand:
reset
RMAN-03023:
executingcommand:
reset
RMAN-08006:
databaseregisteredinrecoverycatalog
RMAN-03023:
executingcommand:
fullresync
RMAN-08029:
snapshotcontrolfilenamesettodefaultvalue:
?
/dbs/snapcf_@.f
RMAN-08002:
startingfullresyncofrecoverycatalog
RMAN-08004:
fullresynccomplete
oraclerman备份命令
2009-2-12 作者:
编辑:
齐瑞瑞 点击进入论坛
关键词:
oracle 备份 命令
RMAN简单使用
目标机A:
createtablespaceRMANdatafile'$ORACLE_HOME/oradata/FILENAME.DBF'size20M;
RMAN简单使用
目标机A:
createtablespaceRMANdatafile'$ORACLE_HOME/oradata/FILENAME.DBF'size20M;
createusernameRMANidentifiedbyRMANdefaulttablespacermantemporarytablespacetempquotaunlimitedonRMAN;
grantrecovery_catalog_ownertorman;
rmancatalogrman/rman
createcatalogtablespace'RMAN';
Rman主机B:
rmantarget/
connectcatalogrman/rman@$A_SID
注册数据库
registerdatabase;
注销数据库
sqlplusrman/rman
select*fromdb;
EXECUTEdbms_rcvcat.unregisterdatabase(db_key,db_id);
///////////非归档模式使用RMAN备份///////////////////////
备份目标数据库:
rmantarget/
connectcatalogrman/rman@$A_SID
定义通道
allocatechannelc1typedisk;
撤消通道
releasechannelc1;
备份整个数据库
run{
allocatechannelc1typedisk;
backupfulltagfull_db_backup
format'/export/home/oracle/oradata/bak_db/db_%d'database
includecurrentcontrolfile;
releasechannelc1;
}
备份表空间
run{
allocatechanneld1typedisk;
backuptagtbs_users_read_only
format'/export/home/oracle/oradata/bak_tab/block_t%t_s%s'(tablespace"BLOCK");
releasechannelc1;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle rman 备份