Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "NBU heterogeneous restore Oracle full backup example analysis", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn the "NBU heterogeneous restore Oracle full backup example analysis" this article.

Prepare heterogeneous Ortacle servers

Add the Hosts record of the relevant server.

Install NBU client agent.

Install the same version of Oracle software.

Create the same administrator account and password.

Create an oracle instance with the same name and the same path as the source Oracle.

Shut down the database (shutdown immedicate).

Delete all files under the database folder.

Get the DBID of the source Oracle and record it (the source Oracle runs the SQL command: Selectdbid from vault database;).

NBU server

Add the Hosts record of the relevant server.

Create an empty file named No.Restrictions under the XXX/db/altnames folder of the NBU installation directory (to allow NBU to do a heterogeneous restore).

Look for the control file that needs to be restored and record the name of the control file (bplist-C source Oracle client-l-t 4-s 6xpr /).

Start restoring recovery control files

The database is in a nomout state (startupnomount).

Log in to rman to run:

DBID of the set dbid= source oracle

Run {

ALLOCATE CHANNEL CH00 TYPE'SBT_TAPE'

SEND 'NB_ORA_SERV=NBU server name, NB_ORA_CLIENT= source oracle server client name'

Restore controlfile from 'control file name'

}

Restore database files

The database is in a mount state (startupmount).

Log in to rman to run

Run {

ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE'

SEND 'NB_ORA_SERV= NBU server name, NB_ORA_CLIENT= H source oracle server client name''

Restore database

}

Restore archive logs (if you only need to restore and play with full backups, do not do so)

Log in to rman to run

Run {

ALLOCATE CHANNEL CH02 TYPE'SBT_TAPE'

SEND 'NB_ORA_SERV= NBU server name, NB_ORA_CLIENT= H source oracle server client name''

ESTORE ARCHIVELOG FROMSEQUENCE serial number thread 1 UNTIL SEQUENCE serial number

RELEASE CHANNEL CH02

}

Log in to SQL to run

Recover database untilcancel

Start the database

Log in to SQL to run

Alter database openresetlogs

The above is all the contents of the article "sample Analysis of NBU heterogeneous restore Oracle full backup". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.