Restore oracle backup on a different server

Question

Hi,

I am trying to restore oracle backup on a different server with networker 9.2.1.

After configuring the test machine as the original machine, when I created from the console the restoration I get the following error (the test machine is configured as and client and has a group in netwoker):

In the first space of the image is the name of the test server

In the second space is the name of the real server

In the third space is the name of the real server

In the fourth space is the name of the test server

At this time I select 'No' because I'm not sure.

What does this message mean and what should I do?

Thank you,

bingo.1 · Answer

By default, source and destination client must be the same. If you want to recover to another client, you must add such user in the source client's 'remote access' list. Consequently, this is not an error.

Obviously, in this version, NW is able to correct that but he requests your confirnation to correct it.

Masanc2 · Answer

Perfect, I have added the test machine in the properties of the source client as 'remote access' and it goes to the next Windows. It has been a great help to me, Thank you very much,

soffian · Answer

Hi Masanc2, May i know how do you restore oracle backup to new test machine. My configuration Networker server 9.0.1.4 build 669 Networker client 9.0.1.4 build 669

Masanc2 · Answer

Hello,

I am studying the following steps to the original question because this is new to me.

At the moment I am trying to create an auxiliary b.d. in Oracle.

I'm sorry I can't help you, I have not experience.

Obi_Wan_Abud · Answer

Hi Masanc2,

In summary if you want to do this using a networker recovery gui, the only option for you is to use duplicate method, which will create for you a duplicate database.

If you want to recover to another machine with the same oracle SID then you must use oracle RMAN. Before performing the recovery process you must create a client resource for the target machine and you must add the user e.g user@sourcemachine in the 'remote access' field in the client resource property.

here's below sample command to give you an overview. Hope this helps.

#login using the oracle user ( su - )

%rman target /

set DBID ;

startup nomount;

run {

allocate channel CH1 type 'SBT_TAPE';

send 'NSR_ENV=(NSR_SERVER= ,NSR_CLIENT= ,NSR_RECOVER_POOL= )';

allocate channel CH2 type 'SBT_TAPE';

send 'NSR_ENV=(NSR_SERVER= ,NSR_CLIENT= ,NSR_RECOVER_POOL= )';

restore controlfile from autobackup;

alter database mount;

RESTORE DATABASE;

RECOVER DATABASE;

alter database open resetlogs;

RELEASE CHANNEL CH1;

RELEASE CHANNEL CH2;

}

Masanc2 · Answer

Ok, Thanks a lot for your help. Last Friday I restored with duplication as a restoration in case of loss in a new auxliary instance . That was valid for me. I use the networker gui at all times.

Ibrahiemtami · Answer

Hi, Would you please help further with screenshots regarding using the networker gui Regards, Ibra

NetWorker

Restore oracle backup on a different server

Was this post helpful?