Oracle RMAN 恢复数据库到不同主机（二）

我们在recover database时报一个错误：

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 149 and starting SCN of 3507749

这里是提醒恢复到一个未知的scn号。我们在备份时只有148号归档，149号还是online redo，所以没有copy过来，如果我们不指定recover的结束时间，最后就会提示我们上面的信息：RMAN-06054. 所以在alter database mount之后，通过set until scn或者set until time命令设置恢复到的scn号或时间，就可以避免这个错误。如：

RMAN> run{
      set until sequence 149;
      recover database;
      }

executing command: SET until clause

Starting recover at 2016-05-12 23:27:34
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 2016-05-12 23:27:34

L、恢复完成之后，还有一个十分重要的工作要做，那就是恢复redo log files.如果源库的目录结构与新库的目录结构相同的话，在open resetlogs 时，会重新创建online redo log。但是现在redo log file文件的位置变了，open resetlogs时报如下错误：

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 05/12/2016 23:37:46
ORA-00344: unable to re-create online log '/u01/app/oracle/oradata/scp/redo01.log'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1

由于源库和目标库的路径不相同，oracle试图在原来旧的位置去创建redo log file，但是却发现目标库上不存在这个路径了.解决方法仍然是将旧文件的路径重置为新的路径,但是我们怎么知道源库redo log file文件的位置呢？因为数据库已经mount上了，直接执行查询：

RMAN> select group#,type,member from v$logfile;

group#   type        MEMBER                                                                          
--------------------------------------------------------------------------------
  3    online       /u01/app/oracle/oradata/scp/redo03.log
  2    online       /u01/app/oracle/oradata/scp/redo02.log
  1    online       /u01/app/oracle/oradata/scp/redo01.log

接下来我们将这些redo log file指定到新的文件位置：

RMAN>  run{
    ALTER DATABASE RENAME file '/u01/app/oracle/oradata/scp/redo01.log' TO '/home/OracleData/scp/redo01.log';
    ALTER DATABASE RENAME file '/u01/app/oracle/oradata/scp/redo02.log' TO '/home/OracleData/scp/redo02.log';
    ALTER DATABASE RENAME file '/u01/app/oracle/oradata/scp/redo03.log' TO '/home/OracleData/scp/redo03.log';
    }

Statement processed
Statement processed
Statement processed

这个时候我们以resetlogs方式打开数据库，oracle报ora-00392的错误，

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 05/13/2016 00:07:37
ORA-00392: log 2 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 2 thread 1: '/home/OracleData/scp/redo02.log'

我们这个时候来查询一下redo log file的状态：

RMAN>  select group#,sequence#,bytes,members,status from v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS          
---------- ---------- ---------- ---------- ----------------
         1          0   52428800          1 CLEARING        
         3          0   52428800          1 CLEARING        
         2          0   52428800          1 CLEARING_CURRENT

以下是oracle的官方文档：

（1）CLEARING ---- Log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement.After the log is cleared, the status changes to UNUSED.

（2）CLEARING_CURRENT ----Current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.

解决办法：

RMAN> alter database clear logfile group 2;

Statement processed

RMAN>  select group#,sequence#,bytes,members,status from v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS          
---------- ---------- ---------- ---------- ----------------
         1          0   52428800          1 CLEARING        
         3          0   52428800          1 CLEARING        
         2          0   52428800          1 CURRENT

M、最后用open resetlogs方式打开数据库，并执行一些日志切换。

RMAN> alter database open resetlogs;

Statement processed

RMAN> alter system switch logfile;

Statement processed

RMAN> alter system switch logfile;

Statement processed

RMAN>  select group#,sequence#,bytes,members,status from v$log;

    GROUP#  SEQUENCE#      BYTES    MEMBERS STATUS          
---------- ---------- ---------- ---------- ----------------
         1          1   52428800          1 ACTIVE          
         2          2   52428800          1 ACTIVE          
         3          3   52428800          1 CURRENT

N、这还没有完，我们需要创建spfile文件、临时表空间和密码文件：

RMAN> alter tablespace temp add tempfile '/home/OracleData/scp/temp01.dbf' size 29m reuse autoextend on next 640k maxsize 32767m;

Statement processed

RMAN> create spfile from pfile;

RMAN> host;

[oracle@scpdb rmanbak]$ orapwd file='$ORACLE_HOME/dbs/orapwscp'  password='abc123!@#'  entries=3

关于密码文件，要注意文件名格式  orapw$ORACLE_SID  (注意不需要后缀名),具体请参照Oracle官方文档：
https://docs.oracle.com/cd/B28359_01/server.111/b28310/dba007.htm

本文转自:http://www.cnblogs.com/wqswjx/p/5485817.html