ITeye博客

linux下rman恢复笔记

microjava · 2009-11-06 14:11 · linux · Markdown

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

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。