登錄

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

總結

以上是生活随笔為你收集整理的oracle11g rman实例,oracle11g rman备份与恢复详细实例的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。