Community in read only mode June 18 & 19
This community will be set in READ ONLY mode for a while on Tuesday June 18 into Wednesday June 19 while we import content and users from our Micro Focus Forums community site. MORE INFORMATION
Highlighted
Camillis Valued Contributor.
Valued Contributor.
475 views

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

 

0 Likes
1 Reply
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: Restore do controlfile via CLI e depois prosseguir via GUI.

Hello Camillis,

Do you have a specific problem with this procedure or was this just to share it with the community?

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.