This post is more than 5 years old
2K Posts
0
4547
Oracle Recoveries
I have worked on Oracle module, its linking and backup & recovery scripts but one thing I have not worked on is Recovering an Oracle database on a different server.
Does anyone have a procedure known for this? I am using NW 7.2, NMO 4.2, Oracle 9.2 on Linux.
I am using the recovery script -
connect target sys/sys@onmdb;
connect catalog rmannew/rman786@revcat;
run {
allocate channel t0 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t5 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t6 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t7 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
restore database;
release channel t0;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
release channel t7;
}
In the script, standbyonmamr is the client whose database needs to be recovered. I don't want to recover control files if it is possible to avoid that.
It goes to the tape, picks up the correct tape and ends up with the error -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/21/2007 11:31:12
ORA-19507: failed to retrieve sequential file, handle="0tiadac2_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
The function nsr_bind_recov_mm() failed with the error: Unknown host (1:5:0)
Please suggest
Does anyone have a procedure known for this? I am using NW 7.2, NMO 4.2, Oracle 9.2 on Linux.
I am using the recovery script -
connect target sys/sys@onmdb;
connect catalog rmannew/rman786@revcat;
run {
allocate channel t0 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t3 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t4 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t5 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t6 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
allocate channel t7 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=ebsbkp,NSR_CLIENT=standbyonmamr,NSR_DATA_VOLUME_POOL=Database Sunday)';
restore database;
release channel t0;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
release channel t5;
release channel t6;
release channel t7;
}
In the script, standbyonmamr is the client whose database needs to be recovered. I don't want to recover control files if it is possible to avoid that.
It goes to the tape, picks up the correct tape and ends up with the error -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/21/2007 11:31:12
ORA-19507: failed to retrieve sequential file, handle="0tiadac2_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
The function nsr_bind_recov_mm() failed with the error: Unknown host (1:5:0)
Please suggest
ble1
2 Intern
2 Intern
•
14.3K Posts
0
March 6th, 2007 07:00
ble1
2 Intern
2 Intern
•
14.3K Posts
1
February 22nd, 2007 03:00
ble1
2 Intern
2 Intern
•
14.3K Posts
0
February 28th, 2007 06:00
amediratta
2K Posts
0
February 28th, 2007 06:00
We are able to recover a File System backup using nwrecover on the same server.
amediratta
2K Posts
0
February 28th, 2007 07:00
standbyonmamr is the client whose database is to be restored on this client named abc.
recvcat is the new recovery catalog with is a copy of the original recovery catalog. We do not want to use the original catalog as while restoring that would get updated.
ble1
2 Intern
2 Intern
•
14.3K Posts
0
February 28th, 2007 11:00
amediratta
2K Posts
0
March 4th, 2007 00:00
Actually, we are testing recovering the online production database on a test server.
ble1
2 Intern
2 Intern
•
14.3K Posts
1
March 4th, 2007 10:00
amediratta
2K Posts
0
March 6th, 2007 07:00
Moving ahead with point in time recovery, I just wanted to find out if the time when NW updates is index is same as the time at which RMAN updates its catalog.
amediratta
2K Posts
0
March 6th, 2007 07:00
androm1
17 Posts
0
June 22nd, 2007 03:00
we have the same problem .
To solve the problem is to recover RMAN from a different catalogue or to search for a network problem (DNS incorrect configuration, switch etc)
Thanks for any suggestions .
Andrea
amediratta
2K Posts
0
June 22nd, 2007 22:00
androm1
17 Posts
0
June 25th, 2007 00:00
thanks very much for your answer.
Please, do you know what means the error : "Unknown host (1:5:0)"
Thanks again
Regards,
Andrea
ble1
2 Intern
2 Intern
•
14.3K Posts
0
June 25th, 2007 00:00
mr_robot
30 Posts
0
April 1st, 2020 06:00
How do you select the correct timestamp for a Point in Time recovery, such that it only uses a particular saveset.
For instance, the datafile Level 0 backup shows its save time as 9:00pm. But when I select that as the timestamp for recovery, it looks for savesets of earlier dates.
When I select a timestamp after the backup has completed, e.g 10pm , it'll restore but then look for an archive log in the follwoing day's backup saveset.
I want to be able to pick a timestamp in which the recovery only uses that particular saveset, without depending on backups done on other days.
Which timestamp should I use?