This is a multipart message in MIME format.
--=_alternative 004D8F1E80256CCA_=
Content-Type: text/plain; charset="us-ascii"
I'm having trouble getting an Oracle Rman restire to another machine to
work.
in out env,
"tiger" is the source machine, where the database is backed up.
"lion" is the destination machine, where the database is to be restored
to.
"monkey" is the netbackup master server.
this is the rman error I get.
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel c1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve
sequential file, handle="HANK_I0_10eed2ok_1_1_484870932", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Failed to process backup file.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
here's the top of my rman script
run {
allocate auxiliary channel c1 type 'SBT_TAPE'
parms'ENV=(NB_ORA_CLIENT=uks001p)';
send 'NB_ORA_CLASS=uks001p-oracle';
.
.
.
.
set newname for datafile 330 to '/u13/oracle/dev2data/mscd02.dbf';
set newname for datafile 331 to '/u16/oracle/dev2data/ontd02.dbf';
# Issue the duplicate command
duplicate target database to DEV2
logfile
GROUP 1 (
'/u09/oracle/dev2data/log001b.dbf',
'/u13/oracle/dev2data/log001a.dbf'
) SIZE 100M
}
In the log file under /usr/openv/netbackup/logs/dbclient,this is the log I
get out.
11:57:00.098 [9685] <4> dbc_InitializeDBClient: --- SESSION INITIATED ---
11:57:00.098 [9685] <4> sbtinit: entering.
11:57:00.099 [9685] <4> getOracleVersion: entering getOracleVersion.
11:57:00.099 [9685] <4> getOracleVersion: ORACLE_HOME=
</u17/oracle/dev2ora/8.1.7>
11:57:00.099 [9685] <4> getOracleVersion: checking for
</u17/oracle/dev2ora/8.1.7/bin/rman>
11:57:00.099 [9685] <4> dbc_GetServerClientConfig: entering
dbc_GetServerClientConfig.
11:57:00.099 [9685] <4> dbc_GetServerClientConfig: ServerName: <monkey>,
ClientName: <lion>
11:57:00.105 [9685] <4> get_schedule: entering get_schedule.
11:57:00.105 [9685] <4> get_pc_schedule: entering get_pc_schedule.
11:57:00.105 [9685] <4> get_alt_client: entering get_alt_client.
11:57:00.105 [9685] <4> get_alt_client: NB_ORA_CLIENT = <tiger> found in
environment
11:57:00.105 [9685] <4> get_class: entering get_class.
11:57:00.106 [9685] <4> dbc_GetClassNameFromConfig: user's backup policy=
<lion-oracle>
11:57:00.106 [9685] <4> get_class: Policy <lion-oracle> found in
configuration
11:57:00.106 [9685] <4> get_alt_server: entering get_alt_server.
11:57:00.106 [9685] <4> sbtinit: VERITAS NetBackup for Oracle - Release
4.5GA (00000000)
System name: HP-UX
Node name: lion
Release: B.11.00
Version: U
Machine: 9000/800
User name: oradev2
Group name: dba
Client Host: lion
11:57:00.106 [9685] <4> sbtinit: support for Proxy Copy enabled
11:57:00.106 [9685] <4> sbtinit2: entering sbtinit2.
11:57:01.280 [9685] <4> sbtcommand: entering sbtcommand.
11:57:01.281 [9685] <4> sbtcommand: command
string=<NB_ORA_CLASS=tiger-oracle>
11:57:01.281 [9685] <4> sbtcommand: Policy <tiger-oracle> will be used for
this API session.
12:02:19.846 [9685] <4> sbtrestore: entering sbtrestore.
12:02:19.853 [9685] <4> find_backup_image: entering find_backup_image
12:02:19.853 [9685] <4> get_bfs_date_range: entering get_bfs_date_range.
12:02:19.860 [9685] <4> get_bfs_date_range: RMAN file name =
HANK_I0_10eed2ok_1_1_484870932
12:02:19.860 [9685] <4> get_bfs_date_range:
bfs_time=484870932,start_time=257126400,end_time=485697739
12:02:19.860 [9685] <4> get_bfs_date_range: yr=15, p=482112000, s=2758932,
m=1
12:02:19.860 [9685] <4> get_bfs_date_range: adjust secs this year = 0
12:02:19.860 [9685] <4> get_bfs_date_range: after adjusted for prev years
= 2419200
12:02:19.875 [9685] <4> get_bfs_date_range: after adjusted for leap years
= 2332800
12:02:19.875 [9685] <4> get_bfs_date_range: final bfs_time = 1044159732
12:02:19.875 [9685] <4> get_bfs_date_range: Start range check:
bfs_time=1044159732, start=819936000, end=1045051339
12:02:19.875 [9685] <4> get_bfs_date_range: Start Time = 02/01/03 04:22:12
12:02:19.875 [9685] <4> get_bfs_date_range: End Time = 02/03/03 04:22:12
12:02:19.875 [9685] <4> dbc_GetMediaListByName: entering
dbc_GetMediaListByName.
12:02:19.875 [9685] <4> getOwnerName: entering getOwnerName.
12:02:19.882 [9685] <4> BuildBprdRequest: entering BuildBprdRequest.
12:02:19.882 [9685] <4> BuildBprdRequest: request_string=<4.5GA tiger lion
*NULL* 4 1044073332 1044246132 /HANK_I0_10eed2ok_1_1_484870932>
12:02:19.882 [9685] <4> dbc_GetMediaListByName: Request String = <4.5GA
tiger lion *NULL* 4 1044073332 1044246132 /HANK_I0_10eed2ok_1_1_484870932>
12:02:20.066 [9685] <2> bind_on_port_addr: bound to port 50876
12:02:20.067 [9685] <2> logconnections: BPRD CONNECT FROM
10.172.74.36.50876 TO 10.172.75.34.13720
12:02:20.068 [9685] <2> bprd_connect: Cannot authenticate server monkey:
18
12:02:20.068 [9685] <16> dbc_GetMediaListByName: Can't connect to host
monkey: authentication failed (160)
12:02:20.068 [9685] <16> find_backup_image: GetMediaListByName() failed
12:02:20.068 [9685] <4> error_setup: entering error_setup.
12:02:20.068 [9685] <16> sbtrestore: Failed to process backup file.
12:02:20.068 [9685] <4> sbterror: entering: errcode=7501,
errtxt=sbtrestore: Failed to process backup file..
12:02:20.960 [9685] <4> sbtend: entering sbtend.
12:02:20.961 [9685] <4> sbtend: --- END of SESSION ---
It seems to me to be a problem with clients being authorised to the master
server or to the source machine - but I dont know how to rectify this.
Any help would be appreciated.
###############
# Rob Bailey #
###############
This e-mail is confidential and may contain legally privileged information. If
you are not the intended recipient, you should not copy, distribute, disclose
or use the information it contains. Please e-mail the sender immediately and
delete this message from your system. E-mails are susceptible to corruption,
interception and unauthorised amendment; we do not accept liability for any
such changes, or for their consequences. You should be aware that Lafarge may
monitor your emails and their content.
--=_alternative 004D8F1E80256CCA_=
Content-Type: text/html; charset="us-ascii"
<br><font size=2 face="Courier New">I'm having trouble getting an Oracle Rman
restire to another machine to work.</font>
<br>
<br><font size=2 face="Courier New">in out env, </font>
<br><font size=2 face="Courier New">"tiger" is the source machine,
where the database is backed up.</font>
<br><font size=2 face="Courier New">"lion" is the destination
machine, where the database is to be restored to.</font>
<br><font size=2 face="Courier New">"monkey" is the netbackup master
server.</font>
<br>
<br>
<br><font size=2 face="Courier New">this is the rman error I get.</font>
<br>
<br>
<br>
<br><font size=2 face="Courier New">RMAN-03026: error recovery releasing
channel resources</font>
<br><font size=2 face="Courier New">RMAN-08031: released channel: c1</font>
<br><font size=2 face="Courier New">RMAN-00571:
===========================================================</font>
<br><font size=2 face="Courier New">RMAN-00569: =============== ERROR MESSAGE
STACK FOLLOWS ===============</font>
<br><font size=2 face="Courier New">RMAN-00571:
===========================================================</font>
<br><font size=2 face="Courier New">RMAN-03002: failure during compilation of
command</font>
<br><font size=2 face="Courier New">RMAN-03013: command type: Duplicate
Db</font>
<br><font size=2 face="Courier New">RMAN-03015: error occurred in stored script
Memory Script</font>
<br><font size=2 face="Courier New">RMAN-03002: failure during compilation of
command</font>
<br><font size=2 face="Courier New">RMAN-03013: command type: restore</font>
<br><font size=2 face="Courier New">RMAN-03007: retryable error occurred during
execution of command: IRESTORE</font>
<br><font size=2 face="Courier New">RMAN-07004: unhandled exception during
command execution on channel c1</font>
<br><font size=2 face="Courier New">RMAN-10035: exception raised in RPC:
ORA-19507: failed to retrieve sequential file,
handle="HANK_I0_10eed2ok_1_1_484870932", parms=""</font>
<br><font size=2 face="Courier New">ORA-27029: skgfrtrv: sbtrestore returned
error</font>
<br><font size=2 face="Courier New">ORA-19511: sbtrestore: Failed to process
backup file.</font>
<br><font size=2 face="Courier New">RMAN-10031: ORA-19624 occurred during call
to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE</font>
<br>
<br>
<br><font size=2 face="Courier New">here's the top of my rman script</font>
<br>
<br>
<br><font size=2 face="Courier New">run {</font>
<br><font size=2 face="Courier New">allocate auxiliary channel c1 type
'SBT_TAPE' parms'ENV=(NB_ORA_CLIENT=uks001p)';</font>
<br><font size=2 face="Courier New">send 'NB_ORA_CLASS=uks001p-oracle';</font>
<br><font size=2 face="Courier New">.</font>
<br><font size=2 face="Courier New">.</font>
<br><font size=2 face="Courier New">.</font>
<br><font size=2 face="Courier New">.</font>
<br>
<br>
<br><font size=2 face="Courier New">set newname for datafile 330 to
'/u13/oracle/dev2data/mscd02.dbf';</font>
<br><font size=2 face="Courier New">set newname for datafile 331 to
'/u16/oracle/dev2data/ontd02.dbf';</font>
<br><font size=2 face="Courier New"># Issue the duplicate command</font>
<br><font size=2 face="Courier New">duplicate target database to DEV2</font>
<br><font size=2 face="Courier New">logfile</font>
<br><font size=2 face="Courier New"> GROUP 1 (</font>
<br><font size=2 face="Courier New">
'/u09/oracle/dev2data/log001b.dbf',</font>
<br><font size=2 face="Courier New">
'/u13/oracle/dev2data/log001a.dbf'</font>
<br><font size=2 face="Courier New"> ) SIZE 100M </font>
<br>
<br><font size=2 face="Courier New">}</font>
<br>
<br>
<br><font size=2 face="Courier New">In the log file under
/usr/openv/netbackup/logs/dbclient,this is the log I get out.</font>
<br>
<br><font size=2 face="Courier New">11:57:00.098 [9685] <4>
dbc_InitializeDBClient: --- SESSION INITIATED --- </font>
<br><font size=2 face="Courier New">11:57:00.098 [9685] <4> sbtinit:
entering.</font>
<br><font size=2 face="Courier New">11:57:00.099 [9685] <4>
getOracleVersion: entering getOracleVersion.</font>
<br><font size=2 face="Courier New">11:57:00.099 [9685] <4>
getOracleVersion: ORACLE_HOME= </u17/oracle/dev2ora/8.1.7></font>
<br><font size=2 face="Courier New">11:57:00.099 [9685] <4>
getOracleVersion: checking for </u17/oracle/dev2ora/8.1.7/bin/rman></font>
<br><font size=2 face="Courier New">11:57:00.099 [9685] <4>
dbc_GetServerClientConfig: entering dbc_GetServerClientConfig.</font>
<br><font size=2 face="Courier New">11:57:00.099 [9685] <4>
dbc_GetServerClientConfig: ServerName: <monkey>, ClientName:
<lion></font>
<br><font size=2 face="Courier New">11:57:00.105 [9685] <4> get_schedule:
entering get_schedule.</font>
<br><font size=2 face="Courier New">11:57:00.105 [9685] <4>
get_pc_schedule: entering get_pc_schedule.</font>
<br><font size=2 face="Courier New">11:57:00.105 [9685] <4>
get_alt_client: entering get_alt_client.</font>
<br><font size=2 face="Courier New">11:57:00.105 [9685] <4>
get_alt_client: NB_ORA_CLIENT = <tiger> found in environment</font>
<br><font size=2 face="Courier New">11:57:00.105 [9685] <4> get_class:
entering get_class.</font>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4>
dbc_GetClassNameFromConfig: user's backup policy= <lion-oracle></font>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4> get_class:
Policy <lion-oracle> found in configuration</font>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4>
get_alt_server: entering get_alt_server.</font>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4> sbtinit:
VERITAS NetBackup for Oracle - Release 4.5GA (00000000)</font>
<br><font size=2 face="Courier New"> System name:
HP-UX</font>
<br><font size=2 face="Courier New"> Node name:
lion</font>
<br><font size=2 face="Courier New"> Release:
B.11.00</font>
<br><font size=2 face="Courier New"> Version:
U</font>
<br><font size=2 face="Courier New"> Machine:
9000/800</font>
<br><font size=2 face="Courier New"> User name:
oradev2</font>
<br><font size=2 face="Courier New"> Group name:
dba</font>
<br><font size=2 face="Courier New"> Client Host:
lion</font>
<br>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4> sbtinit:
support for Proxy Copy enabled</font>
<br><font size=2 face="Courier New">11:57:00.106 [9685] <4> sbtinit2:
entering sbtinit2.</font>
<br><font size=2 face="Courier New">11:57:01.280 [9685] <4> sbtcommand:
entering sbtcommand.</font>
<br><font size=2 face="Courier New">11:57:01.281 [9685] <4> sbtcommand:
command string=<NB_ORA_CLASS=tiger-oracle></font>
<br><font size=2 face="Courier New">11:57:01.281 [9685] <4> sbtcommand:
Policy <tiger-oracle> will be used for this API session.</font>
<br><font size=2 face="Courier New">12:02:19.846 [9685] <4> sbtrestore:
entering sbtrestore.</font>
<br><font size=2 face="Courier New">12:02:19.853 [9685] <4>
find_backup_image: entering find_backup_image</font>
<br><font size=2 face="Courier New">12:02:19.853 [9685] <4>
get_bfs_date_range: entering get_bfs_date_range.</font>
<br><font size=2 face="Courier New">12:02:19.860 [9685] <4>
get_bfs_date_range: RMAN file name = HANK_I0_10eed2ok_1_1_484870932</font>
<br><font size=2 face="Courier New">12:02:19.860 [9685] <4>
get_bfs_date_range:
bfs_time=484870932,start_time=257126400,end_time=485697739</font>
<br><font size=2 face="Courier New">12:02:19.860 [9685] <4>
get_bfs_date_range: yr=15, p=482112000, s=2758932, m=1</font>
<br><font size=2 face="Courier New">12:02:19.860 [9685] <4>
get_bfs_date_range: adjust secs this year = 0</font>
<br><font size=2 face="Courier New">12:02:19.860 [9685] <4>
get_bfs_date_range: after adjusted for prev years = 2419200</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
get_bfs_date_range: after adjusted for leap years = 2332800</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
get_bfs_date_range: final bfs_time = 1044159732</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
get_bfs_date_range: Start range check: bfs_time=1044159732, start=819936000,
end=1045051339</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
get_bfs_date_range: Start Time = 02/01/03 04:22:12</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
get_bfs_date_range: End Time = 02/03/03 04:22:12</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4>
dbc_GetMediaListByName: entering dbc_GetMediaListByName.</font>
<br><font size=2 face="Courier New">12:02:19.875 [9685] <4> getOwnerName:
entering getOwnerName.</font>
<br><font size=2 face="Courier New">12:02:19.882 [9685] <4>
BuildBprdRequest: entering BuildBprdRequest.</font>
<br><font size=2 face="Courier New">12:02:19.882 [9685] <4>
BuildBprdRequest: request_string=<4.5GA tiger lion *NULL* 4 1044073332
1044246132 /HANK_I0_10eed2ok_1_1_484870932></font>
<br><font size=2 face="Courier New">12:02:19.882 [9685] <4>
dbc_GetMediaListByName: Request String = <4.5GA tiger lion *NULL* 4
1044073332 1044246132 /HANK_I0_10eed2ok_1_1_484870932></font>
<br><font size=2 face="Courier New">12:02:20.066 [9685] <2>
bind_on_port_addr: bound to port 50876</font>
<br><font size=2 face="Courier New">12:02:20.067 [9685] <2>
logconnections: BPRD CONNECT FROM 10.172.74.36.50876 TO
10.172.75.34.13720</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <2> bprd_connect:
Cannot authenticate server monkey: 18</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <16>
dbc_GetMediaListByName: Can't connect to host monkey: authentication failed
(160)</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <16>
find_backup_image: GetMediaListByName() failed</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <4> error_setup:
entering error_setup.</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <16> sbtrestore:
Failed to process backup file.</font>
<br><font size=2 face="Courier New">12:02:20.068 [9685] <4> sbterror:
entering: errcode=7501, errtxt=sbtrestore: Failed to process backup
file..</font>
<br><font size=2 face="Courier New">12:02:20.960 [9685] <4> sbtend:
entering sbtend.</font>
<br><font size=2 face="Courier New">12:02:20.961 [9685] <4> sbtend: ---
END of SESSION ---</font>
<br>
<br>
<br>
<br>
<br><font size=2 face="Courier New">It seems to me to be a problem with clients
being authorised to the master server or to the source machine - but I dont
know how to rectify this.</font>
<br>
<br>
<br>
<br><font size=2 face="Courier New">Any help would be appreciated.</font>
<br>
<br>
<br><font size=2 face="Courier New">###############</font>
<br><font size=2 face="Courier New"># Rob Bailey #</font>
<br><font size=2 face="Courier New">###############
</font><CODE><FONT SIZE=3><BR>
<BR>
This e-mail is confidential and may contain legally privileged information. If
you are not the intended recipient, you should not copy, distribute, disclose
or use the information it contains. Please e-mail the sender immediately and
delete this message from your system. E-mails are susceptible to corruption,
interception and unauthorised amendment; we do not accept liability for any
such changes, or for their consequences. You should be aware that Lafarge may
monitor your emails and their content.<BR>
</FONT></CODE>
--=_alternative 004D8F1E80256CCA_=--
|
