Example Analysis of NBU heterogeneous restore Oracle full backup
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!
