无法将oracle database恢复到另一台伺服器上

bowmanleong

小弟在幫客戶做測試將Oracle RAC上的DB恢復到一台VM的oracle DB上....
oracle RAC上的SPFILE已经成功汇入到VM的oracle DB上..但每次尝试跑恢复的工作时
下面是用的命令和失败报错:

RMAN> set dbid=1753225269

executing command: SET DBID

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE 'SBT_TAPE';
restore controlfile from autobackup MAXSEQ 5 MAXDAYS 9;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on T1 channel at 01/28/2014 17:32:20
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE DISK;
restore controlfile from autobackup MAXSEQ 5 MAXDAYS 9;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: T1
channel T1: sid=871 devtype=DISK

Starting restore at 28-JAN-14

channel T1: looking for autobackup on day: 20140128
channel T1: looking for autobackup on day: 20140127
channel T1: looking for autobackup on day: 20140126
channel T1: looking for autobackup on day: 20140125
channel T1: looking for autobackup on day: 20140124
channel T1: looking for autobackup on day: 20140123
channel T1: looking for autobackup on day: 20140122
channel T1: looking for autobackup on day: 20140121
channel T1: looking for autobackup on day: 20140120
channel T1: no autobackup in 9 days found
released channel: T1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/28/2014 17:32:37
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> run {
set controlfile autobackup format for device type DISK to '%F';
ALLOCATE CHANNEL T1 DEVICE TYPE DISK;
restore controlfile;
}2> 3> 4> 5>

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: T1
channel T1: sid=871 devtype=DISK

Starting restore at 28-JAN-14

released channel: T1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/28/2014 17:33:02
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

RMAN>

cigar_love

没有做oracle_link。。。。。

bowmanleong

cigar_love 发表于 2014-01-29 16:10
没有做oracle_link。。。。。

謝謝,完全正確....之後做了一次oracle_link,再跑rman命令時,RMAN還是報錯...不過很奇怪的是,MBU Activity Monitor上面看到restore是成功的

RMAN> run {
set controlfile autobackup format for device type 'SBT_TAPE' to '%F';
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=vasbackup, NB_ORA_CLIENT=mpdb-b-vasclient';
restore controlfile from autobackup;
}

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

allocated channel: CH00
channel CH00: sid=873 devtype=SBT_TAPE
channel CH00: Veritas NetBackup for Oracle - Release 7.5 (2012020801)

sent command to channel: CH00

Starting restore at 29-JAN-14

channel CH00: looking for autobackup on day: 20140129
channel CH00: autobackup found: c-1753225269-20140129-02
released channel: CH00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/29/2014 16:01:02
ORA-19870: error reading backup piece c-1753225269-20140129-02
ORA-19608: c-1753225269-20140129-02 is not a backup piece

:::::::::::::::::::::::::::::::下面是NBU的job details::::::::::::::::::::::::::::::::::::::::::::::::
01/29/2014 16:02:33 - begin Restore
01/29/2014 16:02:33 - number of images required: 1
01/29/2014 16:02:33 - media needed: W4O1L4
01/29/2014 16:02:34 - restoring from image mpdb-b-vasclient_1390932918
01/29/2014 16:02:35 - Info bpbrm (pid=30794) itcdbtest is the host to restore to
01/29/2014 16:02:35 - Info bpbrm (pid=30794) telling media manager to start restore on client
01/29/2014 16:02:35 - Info bpbrm (pid=30794) spawning a brm child process
01/29/2014 16:02:35 - Info bpbrm (pid=30794) child pid: 30805
01/29/2014 16:02:35 - Info bpbrm (pid=30794) listening for client connection
01/29/2014 16:02:36 - Info bptm (pid=30796) Waiting for mount of media id W4O1L4 (copy 1) on server vasbackup.
01/29/2014 16:02:36 - started process bptm (pid=30796)
01/29/2014 16:02:36 - mounting W4O1L4
01/29/2014 16:02:36 - requesting resource W4O1L4
01/29/2014 16:02:36 - granted resource  W4O1L4
01/29/2014 16:02:36 - granted resource  HP.ULTRIUM4-SCSI.000
01/29/2014 16:02:37 - Info bptm (pid=30796) INF - Waiting for mount of media id W4O1L4 on server vasbackup for reading.
01/29/2014 16:02:37 - Info bpbrm (pid=30794) accepted connection from client
01/29/2014 16:02:37 - Info tar (pid=5687) Restore started.
01/29/2014 16:03:37 - mounted W4O1L4; mount time: 0:01:01
01/29/2014 16:03:37 - Info bptm (pid=30796) W4O1L4
01/29/2014 16:03:37 - Info bptm (pid=30796) INF - Waiting for positioning of media id W4O1L4 on server vasbackup for reading.
01/29/2014 16:03:37 - positioning W4O1L4 to file 146
01/29/2014 16:06:32 - positioned W4O1L4; position time: 0:02:55
01/29/2014 16:06:32 - begin reading
01/29/2014 16:06:34 - Info tar (pid=5687) done. status: 0: the requested operation was successfully completed
01/29/2014 16:06:34 - Info bpbrm (pid=30794) sending message to media manager: STOP RESTORE mpdb-b-vasclient_1390932918 EXIT=0
01/29/2014 16:06:34 - end reading; read time: 0:00:02
01/29/2014 16:06:35 - restored from image mpdb-b-vasclient_1390932918; restore time: 0:04:01
01/29/2014 16:06:35 - end Restore; elapsed time 0:04:02
the requested operation was successfully completed  (0)

w3wu

不要用“from autobackup”，直接写nbu备份的piece名。

bowmanleong

w3wu 发表于 2014-02-07 14:49
不要用“from autobackup”，直接写nbu备份的piece名。

试过了....一样的报错
前两天在oracle support上开了服务请求, 服务人员说因为我RAC的环境是SPARC,所以
前兩天在oracle support上開了服務請求, 服務人員說因為我RAC的環境是SPARC,所以另一台用来测试的机械也要SPARC的
另外DB的版本也最好是一样....RAC是oracle 10.2.0.4, 测试的机械是10.2.0.1

clarcli

LZ，controlfile autobackup只是针对磁盘，NB_ORA_CLIENT是RAC主机的名称；
另外，使用bplist可以更好的恢复出控制文件。