| RMAN error swhile refreshing a database [message #74485] |
Sun, 19 December 2004 07:59  |
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 #74492 is a reply to message #74490] |
Mon, 20 December 2004 05:19  |
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 |
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 #192458 is a reply to message #74494] |
Tue, 12 September 2006 08:25 |
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 |
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 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
kjgslg wrote on Thu, 05 November 2009 11:03Hi
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
