Restore do controlfile via CLI e depois prosseguir via GUI.

Restore do controlfile via CLI e depois prosseguir via GUI.

Segue um exemplo:


Backup de servidor A (2009/10/23-3)
Backup de servidor B (2009/10/27-2)

Restore do backup 2009/10/27-2 para o servidor A
Logon em servidor A

[root] export OB2BARHOSTNAME=servidor B
[root] export OB2APPNAME=DATA
[root] cd /opt/omni/lbin
[root] ./ob2rman.pl -restore_controlfile -session 2009/10/27-2
[Normal] From: ob2rman@servidor A "DATA" Time: 10/27/09 12:53:45
Starting restore of target database.

Net service name: DATA.
Instance status: STARTED.
Instance name: DATA.
Database DBID = .
Database control file type: .
Database log mode: .

[Normal] From: ob2rman@servidor A "DATA" Time: 10/27/09 12:54:14
Starting restore of Data Protector managed control file backup.

[Normal] From: ob2rman@servidor A "DATA" Time: 10/27/09 12:55:52
Restore of Data Protector managed control file backup completed.
Location: /var/opt/omni/tmp/ctrl_DATA.dbf.

[Normal] From: ob2rman@servidor A "DATA" Time: 10/27/09 12:55:56
Restore of target database completed.

[root@cscpoan] chown orat29:dba /var/opt/omni/tmp/ctrl_DATA.dbf

[root@cscpoan] su - orat29

[DATA] > rman TARGET sys/dplab@DATA

RMAN>
run {
allocate channel d type disk;
replicate controlfile from '/var/opt/omni/tmp/ctrl_DATA.dbf';
release channel d;
}

allocated channel: d
channel d: sid=156 devtype=DISK

replicating control file
input filename=/var/opt/omni/tmp/ctrl_DATA.dbf
output filename=/opt/oracle/product/10.2.0/db_1/oradata/DATA/control01.ctl
output filename=/opt/oracle/product/10.2.0/db_1/oradata/DATA/control02.ctl
output filename=/opt/oracle/product/10.2.0/db_1/oradata/DATA/control03.ctl

released channel: d

RMAN> quit

Recovery Manager complete.
[DATA] > sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 27 09:03:20 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter database mount
2 ;

Database altered.

SQL>quit

Restore do Database via GUI