How to restore oracle on different client?

tomash65 · ‎03-15-2023

How to restore oracle backup on different client?

backup was created on tape on Netbackup server A, client B, media server B

When i want restore from server A, to client C, media server C

1. not possible force media server C and media server B does not exists.

2. for client C not possible found any backups, bcs all backups are under B (joined with B), nothing under C

How to solve?

ORA_NB_SERVER=A, ORA_NB_CLIENT=C did not find any backup, bcs all backup are binded with B

After start, NB console is showing as media server B - another problem. Whats happen if B does not exits.

/usr/openv/netbackup/bin/bplist -C C -l -b -t 4 -R / returns nothing (maybe export - import?, how? )

PS: and in some is No.Restrictinos and No.restrictions - which is right? On unix, they are really 2 files ;)

Tomash

Michal_Mikulik1 · ‎03-15-2023

Hello,

why you are searching client C backups, when the backup was created with client B?

FORCE_RESTORE_MEDIA_SERVER = B C should also work, but a root cause is a wrong client.

It is No.Restrictions, neither No.Restrictinos nor No.restrictions.

Regards

M.

Nicolai · ‎03-15-2023

Agree with Michal

Also if bplist doesn't return anything, it's because you are asking the wrong question :)

On the master server as root, or on the client where the backup was made, as root or the ora{SID} user account :

/usr/openv/netbackup/bin/bplist -C B -l -b -t 4 -R /

What type of oracle backup are we talking about ?. Usually Oracle restore is a task for the DBA, not NBU admin.

You should not use No.Restrictions, it allows EVERYBODY to restore from ANYWHERE. Use alt names instead :

If media is available, other media servers will pick up the restore.

Alexis_Jeldrez · ‎03-15-2023

I suggest that before complicating things with Oracle, try restoring a regular Standard-policy backup from B, into C.

That way you can first confirm that you have the appropiate permissions and certificates.

VOX