Home » RDBMS Server » Backup & Recovery » RMAN error swhile refreshing a database
RMAN error swhile refreshing a database [message #74485] Sun, 19 December 2004 07:59 Go to next message
Natraj
Messages: 53
Registered: March 2003
Member
Hi,

I am trying to refresh from a production database hot database refresh to another database. the data is being picked froma  tape drive.while refreshing i get the following different types of errors ..on different ocaasions.let me tell u we had prosbs with the server were backups were going but now server is ok

released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/18/2004 12:19:19
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="al_22407_1_545126414", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open for restore.

for another database when i tried to refresh  get another error..i tried refreshing this database twice both times i got different error,

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u05/oradata/sidname/assss.dbf
restoring datafile 00035 to /u04/oradata/sidname/ssdsds.dbf
restoring datafile 00063 to /u06/oradata/sidname/psdddsd01.dbf
restoring datafile 00125 to /u12/oradata/sidname/undo.dbf
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/18/2004 12:59:25
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="bk_40973_1_545119671", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open for restore.

Recovery Manager complete.

Sat Dec 18 12:59:25 CST 2004 ----------------End of Script------------------

exit 1

i ran the sme script again after some time i got error as below the second time i get connection timed out error i guess...this is the error below...

Finished recover at 18-DEC-2004 20:44:15

printing stored script: Memory Script
{
   shutdown clone;
   startup clone nomount ;
}
executing script: Memory Script

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/18/2004 21:46:04
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation

Recovery Manager complete.

Sat Dec 18 21:46:04 CST 2004 ----------------End of Script------------------

exit 1
Re: RMAN error swhile refreshing a database [message #74490 is a reply to message #74485] Mon, 20 December 2004 03:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> ORA-19511: Error received from media manager layer
is a generic one and points that the issue is with the MML ( Media Management Layer).
Are you using veritas/netbackup or anything like that?
Please Post exact information.
The usual cause of this error is unavailablity of disk space ( check all the disk space for database and veritas/netbackup server/client logfiles etc )or client time out ( depends on the MML you use).
Re: RMAN error swhile refreshing a database [message #74492 is a reply to message #74490] Mon, 20 December 2004 05:19 Go to previous messageGo to next message
Natraj
Messages: 53
Registered: March 2003
Member
yes netbackup is being used. today i got this error.
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/20/2004 08:48:22
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="bk_22446_1_545371208", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open for restore.

Recovery Manager complete.

Mon Dec 20 08:48:22 CST 2004 ----------------End of Script------------------
Re: RMAN error swhile refreshing a database [message #74493 is a reply to message #74492] Mon, 20 December 2004 05:32 Go to previous messageGo to next message
Natraj
Messages: 53
Registered: March 2003
Member
This is the error wi got while refreshing another database ....
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/20/2004 09:26:10
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="bk_41041_1_545364043", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Failed to open for restore.

Recovery Manager complete.

Mon Dec 20 09:26:11 AM CST 2004 ----------------End of Script------------------
Re: RMAN error swhile refreshing a database [message #74494 is a reply to message #74492] Mon, 20 December 2004 05:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check the availability of disk space where netbackup writes log files.
if its is all set,
open the netbackup log file and look for any recent relevant messages.
look closely in rmanlogs and netbackup logs for any messages ralating to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Re: RMAN error swhile refreshing a database [message #192458 is a reply to message #74494] Tue, 12 September 2006 08:25 Go to previous messageGo to next message
harooncr2
Messages: 3
Registered: September 2006
Junior Member
I m doing cloning of databases
with a differnet instance name from where the backup was taken. And
while running it gives the following error:
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03002: failure of Duplicate Db command at 09/07/2006 15:06:16
RMAN-03015: error occurred in stored script Memory Script
ORA-19505: failed to identify file "E:\BACKUPS\CLONEBKUP\DB03HSMQIF_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

I did following
1. Made Network Drive Mapping
2. Mapped Original System local Drive
but still doesnt work

I really need help if somebody can help out
Re: RMAN error swhile refreshing a database [message #429762 is a reply to message #192458] Thu, 05 November 2009 13:03 Go to previous messageGo to next message
kjgslg
Messages: 1
Registered: November 2009
Location: Oregon
Junior Member
Hi

1. Is this a redirected refresh? If so you should check to make sure you have the following: /usr/openv/netbackup/db/altnames/No.Restrictions touch file.

NetBackup looks for authorization for redirect restores and the above touch file is important. Admin Guide is Veritas technote number 290216.

[Updated on: Thu, 05 November 2009 13:17]

Report message to a moderator

Re: RMAN error swhile refreshing a database [message #429766 is a reply to message #429762] Thu, 05 November 2009 13:32 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
kjgslg wrote on Thu, 05 November 2009 11:03
Hi

1. Is this a redirected refresh? If so you should check to make sure you have the following: /usr/openv/netbackup/db/altnames/No.Restrictions touch file.

NetBackup looks for authorization for redirect restores and the above touch file is important. Admin Guide is Veritas technote number 290216.


I doubt that OP waiting since Tue, 12 September 2006 06:25 will benefit from this response.
Previous Topic: daily backup automatically
Next Topic: Oracle Flashback Logs backups
Goto Forum:
  


Current Time: Thu Mar 28 11:41:04 CDT 2024