oracle11g rman实例,oracle11g rman备份与恢复详细实例

登录

sqlplus sys/oracle as sysdba

查询归档模式

archvie log list

修改归档模式

shutdown immediate

startup mount

alter database archivelog

alter database open

archive log list;或者select log_mode from v$database;

登陆raman 恢复管理器

rman target /

orcl dbid=1313107278

备份

run

{

sql 'alter system archive log current'; --强制归档

backup database format 'd:\backup\dbfull_%d_%s_%U.bak' ;--备份全库

backup current controlfile format 'd:\backup\ctl_%d_%U.bak';--备份控制文件

backup archivelog all format 'd:\backup\arc_%U.bak';--备份归档日志

}

恢复

1 sqlplus sys/oracle as sysdba

2 shutdown immediate;

3 删除所有的数据文件

4 rman target /

5 startup nomount

set dbid=1377317512

6 exit

--7 rman target /

8

restore controlfile from 'd:\rman\CTL_ORCL_20141031_746';

9

alter database mount;

///sql 'alter database mount';

10 如果安装路径不一样则跳过10去实行20、21 步 再执行11步后面的

restore database;

11 exit

12 复制归档日志到 D:\oracle\product\10.2.0\db_1\flash_recovery_area\ORCL\ARCHIVELOG

13 sqlplus / as sysdba

-- sconnect / as sysdba

14 recover database using backup controlfile until cancel;

15

使用resetlogs方式打开数据库：

SQL> alter database open resetlogs;

如果出现 '没有过旧的备份中还原'之类错误 跳回14步 操作后 ，用在线日志恢复， 指定文件 'E:\rman\REDO03.LOG'

16、如果导航台登录不行添加临时表空间

alter tablespace temp add tempfile ' D:\oracle\product\10.2.0\oradata\orcl\TEMP02.DBF' size 40m ;

select dest_name,destination,status from v$archive_dest;

select 'set newname for datafile '||chr(39)||to_char(name)||chr(39)||' to '||Chr(39)||'D:\app\Administrator\oradata\orcl\'||substr(name,instr(Name,'\',-1)+1)||chr(39)||';' from v$datafile;

select 'alter database rename file '||chr(39)||name||chr(39)||' to '||Chr(39)||'D:\app\Administrator\oradata\orcl\'||substr(name,instr(Name,'\',-1)+1)||chr(39)||';' aa from v$tempfile

Union All

select 'alter database rename file '||chr(39)||MEMBER||chr(39)||' to '||Chr(39)||'D:\app\Administrator\oradata\orcl\'||substr(MEMBER,instr(MEMBER,'\',-1)+1)||chr(39)||';' aa from v$Logfile

20、

run{

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF' to 'D:\app\Administrator\oradata\orcl\SYSTEM01.DBF';

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF' to 'D:\app\Administrator\oradata\orcl\SYSAUX01.DBF';

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF' to 'D:\app\Administrator\oradata\orcl\UNDOTBS01.DBF';

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\USERS01.DBF' to 'D:\app\Administrator\oradata\orcl\USERS01.DBF';

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF' to 'D:\app\Administrator\oradata\orcl\EXAMPLE01.DBF';

set newname for datafile 'E:\ORACLE\ORADATA\ORCL\ZLTOOLSTBS.DBF' to