original location 能是異主機恢復麽？

所以如果有機會讓您那邊的DBA在異主機直接使用RMAN做恢復操作。

建議你看https://support.emc.com/docu48238_Avamar-7.0-for-Oracle-User-Guide.pdf?language=en_US 第93頁

看來偶把問題想複雜了，您的異地虛擬機也是連接到同一個storage麽？我不知道您虛擬機clone是不是連存儲結構也一起clone了，回家之後幫您找找吧

論壇裏也有很多大牛的呀，都去玩 tank of world 了麽？

Hi lei:

我是用虛擬機器Clone，所以這個測試機器是與正式機器的環境一模一樣的。

Hi lei:

用RMAN這點我就不懂了?我是用Avamar備份，並且備份的檔案都在avamar裡，

要如何用test主機用RMAN恢復呢?

frist，您的test server需要安裝oracle程式最好有相同的file system directory structure，如果沒有在rman裏估計要改變datafile的路徑。建議您還是找一找avamar的guide關於Oracle恢復的這部分的内容。我晚上在家裏找找看相關的資料再upload到這裡。

hi:

我參照了說明執行，但剛開始沒幾秒，就出現了以下錯誤了!抱歉因為不能有html格式.

我用貼的看看:

Summary

Session Information

• Avamar Server: "Avamar01"

Log Files

Log #1:/usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.cmd
Log #2:/usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-avtar.log0
Log #3:avoracle log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64] (1 errors)
Log #4:/usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.log
Log #5:avtar log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64]
Log #6:MOD-1389949883020 log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64]

Errors and Exceptions

2014-01-17 17:17:55 avoracle Error <7934>: Restore of 11g/topprod/CONTROLFILE.topprod.c-2049183205-20131231-05 aborted due to rman terminated abnormally - check the logs (Log #3)

*********** /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.cmd ***********

Log #1: /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.cmd

@@RMAN-topprod-27615-cred1.rmanset dbid=2049183205;set controlfile autobackup format for device type sbt to 'CONTROLFILE.topprod.%F';run {allocate channel c0 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so" format '%d_%U';send channel 'c0' '"--libport=47815" "--cacheprefix=topprod_c0" "--sysdir=/usr/local/avamar/etc" "--bindir=/usr/local/avamar/bin" "--vardir=/usr/local/avamar/var" "--logfile=/usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-avtar.log0" "--ctlcallport=9488"';restore controlfile from autobackup MAXSEQ=5 until time = "TO_DATE('20131231','YYYYMMDD')";startup mount;}list backup; *********** /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-avtar.log0 ***********

Log #2: /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-avtar.log0

--- *********** /usr/local/avamar/var/MOD-1389949883020-1002-Oracle.log ***********

Log #3:  avoracle log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64]

2014-01-17 17:16:53 avoracle Info <5008>: Logging to /usr/local/avamar/var/MOD-1389949883020-1002-Oracle.log2014-01-17 17:16:53 avoracle Info <6673>: CTL listening on port 94882014-01-17 17:16:53 avoracle Info <10684>: Setting ctl message version to 3 (from 1)2014-01-17 17:16:53 avoracle Info <16136>: Setting ctl max message size to 2684354562014-01-17 17:16:53 avoracle Info <7084>: target[0]=11g/2014-01-17 17:16:53 avoracle Info <6686>: Process 27618 (/usr/local/avamar/bin/avtar) for workorder MOD-1389949883020#browse_avtar started2014-01-17 17:16:53 avoracle Info <10684>: Setting ctl message version to 3 (from 1)2014-01-17 17:16:53 avoracle Info <16136>: Setting ctl max message size to 2684354562014-01-17 17:17:54 avoracle Info <6688>: Process 27618 (/usr/local/avamar/bin/avtar) finished (code 0: success)2014-01-17 17:17:54 avoracle Info <7932>: Processing 11g/topprod/CONTROLFILE.topprod.c-2049183205-20131231-052014-01-17 17:17:54 avoracle Info <7393>: Parsed the target SID: topprod2014-01-17 17:17:54 avoracle Info <7384>: Getting the oracle_home for topprod2014-01-17 17:17:54 avoracle Info <7390>: Found Service Name (SID): topprod ORACLE_HOME: /u2/oracle/product/11.2.0/dbhome_12014-01-17 17:17:54 avoracle Info <7276>: runflags.orahome=/u2/oracle/product/11.2.0/dbhome_12014-01-17 17:17:54 avoracle Info <14190>: sqlplus cmd:/u2/oracle/product/11.2.0/dbhome_1/bin/sqlplus var:/usr/local/avamar/var2014-01-17 17:17:54 avoracle Info <7783>: Setting spawn user/group ( ) 2014-01-17 17:17:54 avoracle Info <7953>: Username set to "oracle"2014-01-17 17:17:54 avoracle Info <7949>: Unable to find Oracle Instance2014-01-17 17:17:54 avoracle Info <7956>: MML set to libobk_avamar64.so2014-01-17 17:17:54 avoracle Info <7950>: No codepage specified2014-01-17 17:17:54 avoracle Info <7286>: server = topprod dbid = 2049183205 restore_date = 20131231 seq = 52014-01-17 17:17:54 avoracle Info <7455>: Writing Oracle credentials to "/usr/local/avamar/var/RMAN-topprod-27615-cred1.rman"2014-01-17 17:17:54 avoracle Info <7289>: RMAN=/u2/oracle/product/11.2.0/dbhome_1/bin/rman2014-01-17 17:17:54 avoracle Info <7783>: Setting spawn user/group ( ) 2014-01-17 17:17:54 avoracle Info <7782>: User 'oracle' is uid=504, gid=5022014-01-17 17:17:55 avoracle Info <7456>: Deleted Oracle Credentials /usr/local/avamar/var/RMAN-topprod-27615-cred1.rman

2014-01-17 17:17:55 avoracle Error <7934>: Restore of 11g/topprod/CONTROLFILE.topprod.c-2049183205-20131231-05 aborted due to rman terminated abnormally - check the logs2014-01-17 17:17:55 avoracle Info <7271>: Final summary generated subwork 1, cancelled/aborted 1, snapview 0, exitcode 157

END avoracle log 2014-01-17 17:18:00 CST  (0 warnings, 1 error, 0 fatal errors)

*********** /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.log ***********

Log #4: /usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-rman1.log

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 17 17:17:54 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.RMAN> @@RMAN-topprod-27615-cred1.rman2> connect target *;3> **end-of-file**4> set dbid=2049183205;5> set controlfile autobackup format for device type sbt to 'CONTROLFILE.topprod.%F';6> run {7> allocate channel c0 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so" format '%d_%U';8> send channel 'c0' '"--libport=47815" "--cacheprefix=topprod_c0" "--sysdir=/usr/local/avamar/etc" "--bindir=/usr/local/avamar/bin" "--vardir=/usr/local/avamar/var" "--logfile=/usr/local/avamar/var/MOD-1389949883020-1002-Oracle-topprod-avtar.log0" "--ctlcallport=9488"';9> restore controlfile from autobackup MAXSEQ=5 until time = "TO_DATE('20131231','YYYYMMDD')";10> startup mount;11> }12> list backup;13> RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================ORA-21561: OID generation failedRecovery Manager complete. *********** /usr/local/avamar/var/MOD-1389949883020#browse_avtar-1002-Oracle.log ***********

Log #5:  avtar log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64]

2014-01-17 17:16:53 avtar Info <5008>: Logging to /usr/local/avamar/var/MOD-1389949883020#browse_avtar-1002-Oracle.log2014-01-17 17:16:53 avtar Info <5551>: Command Line: /usr/local/avamar/bin/avtar.bin --vardir=/usr/local/avamar/var --bindir=/usr/local/avamar/bin --sysdir=/usr/local/avamar/etc --internal --sysdir=/usr/local/avamar/etc --bindir=/usr/local/avamar/bin --vardir=/usr/local/avamar/var --ctlcallport=9488 --ctlinterface=1002-Oracle-MOD-1389949883020#browse_avtar --logfile=/usr/local/avamar/var/MOD-1389949883020#browse_avtar-1002-Oracle.log2014-01-17 17:16:53 avtar Info <7977>: Starting at 2014-01-17 17:16:53 CST [avtar Dec 10 2012 18:17:20 6.1.101-87 Linux-x86_64]2014-01-17 17:16:53 avtar Info <10684>: Setting ctl message version to 3 (from 1)2014-01-17 17:16:53 avtar Info <16136>: Setting ctl max message size to 2684354562014-01-17 17:16:53 avtar Info <6648>: Successfully connected to 127.0.0.1:9488 with proprietary encryption2014-01-17 17:16:53 avtar Info <6786>: Workorder information received and parsed via CTL:                                                                                               2014-01-17 17:16:53 avtar Info <6649>: Waiting on perform_command_queue dequeue2014-01-17 17:16:53

avtar Info <8474>: - Log file path: /usr/local/avamar/var/MOD-1389949883020#browse_avtar-1002-Oracle.log

2014-01-17 17:16:53 avtar Info <6555>: Initializing connection (Avamar Deduplication Engine v2.0.0)2014-01-17 17:16:53 avtar Info <5552>: Connecting to Avamar Server (Avamar01)2014-01-17 17:16:53 avtar Info <5554>: Connecting to one node in each datacenter2014-01-17 17:16:53

avtar Info <5993>: - Connect: Connected to 172.16.1.88:27000, Priv=0, TCP

2014-01-17 17:16:53

avtar Info <5993>: - Datacenter 0 has 1 nodes: Connected to 172.16.1.88:27000, Priv=0, TCP

2014-01-17 17:16:53 avtar Info <5581>: Logging in on connection 0 with Session Ticket2014-01-17 17:16:53 avtar Info <5582>: Avamar Server login successful2014-01-17 17:16:53

avtar Info <5018>: - Session ID: 0

2014-01-17 17:16:53 avtar Info <5550>: Successfully logged into Avamar Server [6.1.1-87]2014-01-17 17:16:54 avtar Info <6649>: Waiting on perform_command_queue dequeue2014-01-17 17:16:54 avtar Info <8758>: Cancelled - exiting...2014-01-17 17:16:54 avtar Info <0000>: Starting graceful (staged) termination, MCS cancel (final stage)2014-01-17 17:17:54 avtar Info <8468>: Sending wrapup message to parent2014-01-17 17:17:54 avtar Info <5314>: Command completed (exit code 0: success)

END avtar log 2014-01-17 17:17:54 CST  (0 warnings, 0 errors, 0 fatal errors)

*********** /usr/local/avamar/var/MOD-1389949883020-1002-Oracle.alg ***********

Log #6:  MOD-1389949883020 log 2014-01-17 17:16:53 CST  [6.1.101-87 Linux-x86_64]

2014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] Workorder : MOD-13899498830202014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] Plugin ID : 1002-Oracle2014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] bindir    : /usr/local/avamar/bin2014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] vardir    : /usr/local/avamar/var2014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] Initiator : 2014-01-17 17:16:53 MOD-1389949883020 Info <0000>: [agent_ctl_sup] Order      :                                                                                                  

你选择的应该是没问题的。你选择的这项应该是将数据恢复到另一台客户端，且数据恢复的位置和源客户端的位置保持一致，应该是这个意思。

您確定您做的是異地機器恢復麽？我不知道Avamar可不可以直接直接從命令行做RMAN恢復作業。

如果可以那麽最好還是與您那邊的DBA合作做一次測試。                                                             

ORA-21561: OID generation

google了好幾個都說是 机器的hostname没有写进/etc/hosts文件

ERROR:

ORA-21561: OID generation failed

使用sqlplus登录是发现一则这个问题

研究了半天。原因是 机器名在/etc/hosts 中没有相匹配的条目

我这里的hosts是通过别的机器scp进来的，添加了一行 adg解析的就可以了

如果你是修改了/etc/sysconfig/network中的机器名。并且hosts中也添加了相关条目 还是进不去。

则应该再使用 hostname 修改后机器名    进行申明

Good luck

順便問一句，您有玩 暗黑破壞神III 麽？加 liulei_it 一起追尋榮耀吧 捏法雷姆

Hi lei:

感謝您提供的線索，但我的Client端的hosts文件已有加上Avamar主機的hostname了。

PS:sorry~我沒有在玩遊戲的~

我覺得您可能誤解啦，/etc/hosts裏不僅有到備份設備的解析還有與Oracle的tnsnames.ora相關的解析呢。

Hi lei:

抱歉對這個還真的不瞭解，請教那麼 /etc/hosts 裡該怎麼設定呢?

以下是我目前的設定，Oracle 的測試主機hosts，avamar主機名稱為 avamar01

Hi Mobe

这个是个ORACLE的错误，请在/etc/hosts中加入target DB的条目，不是avamar server的条目

eg:

127.0.0.1 loopback localhost # loopback (lo0) name/address
10.210.9.111 dbhost.sample.com

Hi

我已在 etc/hosts 加入了Client本身的ip 仍然出現錯誤!!