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

This article mainly introduces "NBU off-machine restore oracle problem analysis". In the daily operation, I believe that many people have doubts on the problem analysis of NBU off-machine restore oracle problem. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "NBU off-machine restore oracle problem analysis"! Next, please follow the editor to study!

Today, when I was performing a nbu recovery oracle problem, I found that there was always a problem.

The recovery script is fine.

RMAN > run

{

Allocate channel C1 type 'sbt_tape'

Send 'NB_ORA_CLIENT=mytest1'

Restore controlfile from'/ cntrl_6255_1_880381344'

Release channel c1

}

Using target database control file instead of recovery catalog

Allocated channel: c1

Channel c1: SID=59 device type=SBT_TAPE

Channel C1: Veritas NetBackup for Oracle-Release 7.6 (2013111313)

Sent command to channel: c1

Starting restore at 22-MAY-15

Channel c1: restoring control file

Released channel: c1

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of restore command at 05/22/2015 14:45:16

ORA-19870: error while restoring backup piece / cntrl_6255_1_880381344

ORA-19507: failed to retrieve sequential file, handle= "/ cntrl_6255_1_880381344", parms= ""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

Backup file not found in NetBackup catalog

However, you can also see it from the nbu backup server through bplist, but this error is reported. After analysis, it may be the user's problem. The original user at the time of backup was oracle, but now the recovery environment is oratest. Therefore, create a new oracle user, grant rights to the oracle user, and then resume reporting the following error:

RMAN > run

{

Allocate channel C1 type 'sbt_tape'

Send 'NB_ORA_CLIENT=mytest1'

Restore controlfile from'/ cntrl_6255_1_880381344'

Release channel c1

}

Using target database control file instead of recovery catalog

Allocated channel: c1

Channel c1: SID=59 device type=SBT_TAPE

Channel C1: Veritas NetBackup for Oracle-Release 7.6 (2013111313)

Sent command to channel: c1

Starting restore at 25-MAY-15

Released channel: c1

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of restore command at 05/25/2015 17:23:18

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Later, after consulting the nbu engineer, I got the answer!

The reason is:

1. The owner of ORACLE_HOME should be the same as the original environment. That is to say, if there are oracle users in the original environment, the new environment must also be oracle.

2. When using the oracle_link link, it must be executed with the same user as the original environment

2. When restoring, the execution user used must be the same user as the original environment.

At this point, the study on "NBU off-machine restore oracle problem analysis" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.