su oracle
------ 备份控制文件---------------
rman target /
记下:DBID=3388079157
查看状态:
show all;
开启/关闭(要备份控制文件,必须打开)
configure controlfile autobackup off/on;
list backupset;
bs
24
delete backupset 24;
backup format '/home/oracle/mybackup/full_%T_%u.bak' database plus archivelog;
list backupset;
-----控制文件丢失--
rm *.ctl;
conn / as sysdba;
shutdown abort;
quit;
rman target /
startup nomount;
restore controlfile from autobackup;
rman target /
alter database mount;
recover database;
alter database open resetlogs;
口令文件:
/oracle/product/10.2.0/db_1/dbs/orapwherming
口令文件丢失后恢复:
orapwd file=orapwherming password=pass1234 entries=5(entries=5表示dba用户可以有5个)
-----
记下的:DBID=3388079157
spfile丢失(换成别的名字:mv spfileermp.ora spfileermp2.ora)
shutdown immediate;
startup nomount;
set dbid 3388079157
restore spfile from autobackup;
找不到则:restore spfile from '/..../#####.bkp';(rman备份路径)
shutdown immediate;
startup;(set dbid 3388079157;startup;)
--Redolog file 丢失
su -u oracle
rm *.log
sqlplus /nolog;
conn /as sysdba;
shutdown immediate;
startup mount;
recover database until cancel;
alter database open resetlogs;
---执行sql
su -u oracle;
sqlplus /nolog;
conn /as sysdba;
select * from dual;
-----datafile丢失
su oracle;
rm tbs01.dbf;
rman target /
report schema;(tbs01.dbf的file是5)
sql "alter database datafile 5 offline";
restore datafile 5;
recover datafile 5;
sql "alter database datafile 5 online";
-------表空间恢复---------------
su oracle;
sqlplus /nolog;
conn /as sysdba;
select owner,table_name from all_tables where tablespace_name='ermp';
ermp role_info
ermp user_info
ermp org_info
ermp user_role
select * from ermp.role_info;
quit;
rm /oracle/oradata/ermp/ermp.dbf
开始恢复:
rman target /
sql "alter tablespace ermp offline";强制:sql "alter tablespace ermp offline immediate";
restore tablespace ermp;
recover tablespace ermp;
sql "alter tablespace ermp online"
quit
------------非catalog方式完全恢复-------------
su oracle;
cd /oracle/oradata/ermp/
rm *;
rman target
conn /as sysdba
shutdown abort;
quit;
rman target /
startup nomount;
restore controlfile from autobackup;
alter database mount;
restore database;
recover database;
不成功则:
su oracle;
sqlplus /nolog
conn /as sysdba
create pfile from spfil
quit;
sqlplus /nolog
conn /as sysdba
shutdown immediate;
startup pfile=/oracle/product/10.2.0/db_1/dbs/initermp.ora mount
alter database open resetlogs;
----------基于时间的恢复------------
run {
set until time "to_date('09/01/02 15:00:00','mm/dd/yy hh24:mi:ss')"
restore database;
recover database;
alter database open resetlogs;
}
----------基于scn的恢复----------
startup mount;
restore database UNTIL SCN 10000;
recover database UNTIL SCN 10000;
alter database open resetlogs;
---------基于日志序列的恢复-------
sqlplus /nolog
conn /as sysdba
查看日志序列 sequence# current:
select * from v$log;
startup mount;
恢复到1:
restore database UNTIL SEQUENCE 100 thread 1;
recover database UNTIL SEQUENCE 100 thread 1;
alter database open resetlogs;
-----命令总结---rman中执行
report schema:
list backup:
crosscheck backup:
delete: delete backupset 23;
---------catalog备份恢复-------
Catalog mode:
sqlplus /nolog
conn / as sysdba
--创建Catalog所用表空间
SQL>create tablespace rman_ts datafile '/oracle/rman.dbf' size 20 M;
--创建rman用户并授权
SQL>create user rman identified by rman default
tablespace rman_ts quota unlimited on rman_ts;
SQL>grant recovery_catalog_owner to rman;
grant connect to rman;
--创建恢复目录
su oracle;
rman catalog rman/rman
RMAN>create catalog tablespace rman_ts;
RMAN>register database;
connect target /
--
SQL>select * from dba_sys_privs where grantee='CONNECT';
SQL>select * from dba_sys_privs where grantee='RESOURCE';
SQL>select * from dba_sys_privs where grantee='RECOVERY_CATALOG_OWNER';
----开始备份----
su oracle;
rman target / catalog rman/rman
分享到:
相关推荐
NULL 博文链接:https://microjava.iteye.com/blog/510054
Linux下Oracle9i RMAN备份及恢复步骤,一个完整的备份与恢复步骤.
rman恢复管理器学习笔记,欢迎下载学习。笔记包含理论知识和常用恢复管理命令。
《[三思笔记]一步一步学rman(09)-实战rman恢复(1)丢失控制文件的恢复.doc》 《[三思笔记]一步一步学rman(10)-实战rman恢复(2)恢复到异机.doc》 《[三思笔记]一步一步学rman(11)-rman笔记之综述.doc》
linux 平台下的rman全备份和增量备份
Linux系统下的RMAN备份与恢复.pdf
备份策略 每周日 做 Level 0 级备份 每周一,四 做 Level 1 级备份 每周二,三,五,六 做 Level 2 级备份 ……
很好的学习RMAN恢复和备份的资料,请大家一定要珍惜并好好学习
rman学习笔记.txt rman学习笔记.txt rman学习笔记.txt
Centos7.6下Oracle开启归档日志和Rman恢复.docx
如何使用RMAN恢复数据库的表,超实用哦!
原创实战Oracle RAC rman恢复
[三思笔记]一步一步学rman 一、进入rman 二、rman命令知多少 三、rman备份演练初级篇 四、rman备份演练进阶篇 五、rman外传-基础资料篇1 六、实战rman备份 七、rman外传-基础资料篇2 八、演练rman恢复 九、实战rman...
第一篇 进入RMAN ...第11篇 RMAN笔记之综述 Duplicate复制数据库之基本概述 Duplicate复制数据库之创建辅助实例 Duplicate复制数据库之不同环境下的复制流程 Duplicate复制数据库之实战 Duplicate复制数据库之附录
ORACLE RMAN 一步一步学习笔记,初级入门教程
rman(三思笔记)
读书笔记之 RMAN 备份命令,涉及,数据库备份,文件备份,表空间备份,控制文件备份,初始化参数备份,增量备份(差异和累积),命令总列,删除总命令列,
采用rman备份的oracle数据库从Windows操作系统的恢复到Linux操作系统方法
Linux 离线 rman 手册,对于无法使用 rman 命令的 windows 环境,可以直接阅读 linux 下相关命令的介绍。
DAVE Oracle RMAN 学习笔记