RMAN Restore, Recovery

Complete recovery:

rman target / nocatalog

startup mount;

restore database;

recover database;

alter database open;   -- 在歸檔模式下

恢複的之後, 更改的路徑

run {

  set newname for datafile 1 to ‘/<newdir>/system01.dbf’ …

  restore database;

  switch datafile all;

  recover database;

  alter database open; }

tablespace 級别de ：

  sql “alter tablespace users offline immediate”;

  restore tablespace users;

  recover tablespace users;

  sql “alter tablespace users online”; }

使用 rman 重新定位 tablespace 的路徑:

1. 首先确認要轉換路徑的表空間的datafile. select file#, name, bytes from v$datafiles;

2. run {

  set newname for datafile ‘/oradata/u03/users01.dbf’ to ‘/oradata/u04/users01/dbf’ --這句用來指定 restore的路徑

  restore(tablespace users);

  switch datafile 3;  -- update the control file and recovery catalog

  recover tablespace users; 

  sql “alter tablespace tbs1 online”; }

Incomplete Recovery:

1. Mount the database

2. Allocate multiple channels for parallelization.

3. Restore all datafiles.

4. Recover the database by using UNTIL TIME, UNTIL SEQUENCE, or UNTIL SCN.

5. Open the database by using RESETLOGS.

6. Perform a whole database backup.

  allocate channel c1 type disk;

  allocate channel c2 type disk;

  set until time = ‘2000-12-09:14:44:44’;

  alter database open resetlogs; }

這裡要注意一下: NLS_DATE_FORMAT 這個參數所對應的時間格式.

  set until sequence 120 thread 1;

  alter database mount;

  sql “alter database open resetlogs”; }

轉載

恢複的幾種情形

1.在mount 或open 階段完成的災難恢複

非系統表空間，undo表空間，所有的資料檔案

2.在nomount 階段完成的災難恢複