Skip to content

Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server

Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server published on Комментариев к записи Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server нет
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:25<br /> ORA-17628: Oracle error 19505 returned by remote Oracle server

RMAN>  run { allocate channel ch1 device type disk; allocate auxiliary channel ch2 device type disk; duplicate target database for standby from active database;}

using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=10534 device type=DISK

allocated channel: ch2
channel ch2: SID=1506 device type=DISK

Starting Duplicate Db at 02-11-2015 10:45:42

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/oracle/app/base/db/11.2.0/dbs/orapws00somedb' auxiliary format 
 '/oracle/app/base/db/11.2.0.4/dbs/orapwu00somedb1'   ;
}
executing Memory Script

Starting backup at 02-11-2015 10:45:42
Finished backup at 02-11-2015 10:45:44

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '/home/oracle/control1.ctl';
}
executing Memory Script

Starting backup at 02-11-2015 10:45:44
channel ch1: starting datafile copy
copying standby control file
output file name=/oracle/app/base/db/11.2.0/dbs/snapcf_s00somedb.f tag=TAG20151102T104544 RECID=27 STAMP=894710744
channel ch1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 02-11-2015 10:45:47

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:
{
   set newname for tempfile  1 to 
 "+data";
   set newname for tempfile  2 to 
 "+data";
   set newname for tempfile  3 to 
 "+data";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "+data";
   set newname for datafile  2 to 
 "+data";
   set newname for datafile  3 to 
 "+data";
   set newname for datafile  4 to 
 "+data";
   set newname for datafile  5 to 
 "+data";
   set newname for datafile  6 to 
 "+data";
   set newname for datafile  7 to 
 "+data";
   set newname for datafile  8 to 
 "+data";
   set newname for datafile  9 to 
 "+data";
   set newname for datafile  10 to 
 "+data";
   set newname for datafile  11 to 
 "+data";
   set newname for datafile  12 to 
 "+data";
   set newname for datafile  13 to 
 "+data";
   set newname for datafile  14 to 
 "+data";
   set newname for datafile  15 to 
 "+data";
   set newname for datafile  16 to 
 "+data";
   set newname for datafile  17 to 
 "+data";
   set newname for datafile  18 to 
 "+data";
   set newname for datafile  19 to 
 "+data";
   set newname for datafile  20 to 
 "+data";
   set newname for datafile  21 to 
 "+data";
   set newname for datafile  22 to 
 "+data";
   set newname for datafile  23 to 
 "+data";
   set newname for datafile  24 to 
 "+data";
   set newname for datafile  25 to 
 "+data";
   set newname for datafile  26 to 
 "+data";
   set newname for datafile  27 to 
 "+data";
   set newname for datafile  28 to 
 "+data";
   backup as copy reuse
   datafile  1 auxiliary format 
 "+data"   datafile 
 2 auxiliary format 
 "+data"   datafile 
 3 auxiliary format 
 "+data"   datafile 
 4 auxiliary format 
 "+data"   datafile 
 5 auxiliary format 
 "+data"   datafile 
 6 auxiliary format 
 "+data"   datafile 
 7 auxiliary format 
 "+data"   datafile 
 8 auxiliary format 
 "+data"   datafile 
 9 auxiliary format 
 "+data"   datafile 
 10 auxiliary format 
 "+data"   datafile 
 11 auxiliary format 
 "+data"   datafile 
 12 auxiliary format 
 "+data"   datafile 
 13 auxiliary format 
 "+data"   datafile 
 14 auxiliary format 
 "+data"   datafile 
 15 auxiliary format 
 "+data"   datafile 
 16 auxiliary format 
 "+data"   datafile 
 17 auxiliary format 
 "+data"   datafile 
 18 auxiliary format 
 "+data"   datafile 
 19 auxiliary format 
 "+data"   datafile 
 20 auxiliary format 
 "+data"   datafile 
 21 auxiliary format 
 "+data"   datafile 
 22 auxiliary format 
 "+data"   datafile 
 23 auxiliary format 
 "+data"   datafile 
 24 auxiliary format 
 "+data"   datafile 
 25 auxiliary format 
 "+data"   datafile 
 26 auxiliary format 
 "+data"   datafile 
 27 auxiliary format 
 "+data"   datafile 
 28 auxiliary format 
 "+data"   ;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to +data in control file
renamed tempfile 2 to +data in control file
renamed tempfile 3 to +data in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 02-11-2015 10:45:55
channel ch1: starting datafile copy
input datafile file number=00008 name=+DATA/s00somedb/datafile/somedb.272.848695139
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:56
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00017 name=+DATA/s00somedb/datafile/aud_evt_04.280.864489643
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:58
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00014 name=+DATA/s00somedb/datafile/aud_evt_01.264.864489545
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:59
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00015 name=+DATA/s00somedb/datafile/aud_evt_02.258.864489637
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:00
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00016 name=+DATA/s00somedb/datafile/aud_evt_03.257.864489641
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:01
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00018 name=+DATA/s00somedb/datafile/aud_evt_05.279.864489647
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:02
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00019 name=+DATA/s00somedb/datafile/aud_evt_06.278.864489649
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:03
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00006 name=+DATA/s00somedb/datafile/sia_db.273.843746737
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:04
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00011 name=+DATA/s00somedb/datafile/somedb_arch.290.849349975
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:05
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00013 name=+DATA/s00somedb/datafile/somedb_arch.259.859243111
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:06
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00021 name=+DATA/s00somedb/datafile/somedb_arch_emergency.302.868721455
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:07
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00020 name=+DATA/s00somedb/datafile/somedb_arch.275.868719829
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:09
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00003 name=+DATA/s00somedb/datafile/undotbs1.268.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:10
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00004 name=+DATA/s00somedb/datafile/undotbs2.266.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:11
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00002 name=+DATA/s00somedb/datafile/sysaux.269.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:12
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00026 name=+DATA/s00somedb/datafile/somedb_arch_emergency.308.888666289
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:13
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00025 name=+DATA/s00somedb/datafile/somedb_arch_02.307.888665401
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:14
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00022 name=+DATA/s00somedb/datafile/egs_db.303.870185105
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:15
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00005 name=+DATA/s00somedb/datafile/users.271.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:16
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00023 name=+DATA/s00somedb/datafile/egs_sia_db.304.870185511
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:17
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00001 name=+DATA/s00somedb/datafile/system.267.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:18
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00007 name=+DATA/s00somedb/datafile/somedb_tech.270.848695135
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:20
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00009 name=+DATA/s00somedb/datafile/somedb_adm.286.846186103
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:21
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00010 name=+DATA/s00somedb/datafile/somedb_pds.287.846186119
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:22
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00012 name=+DATA/s00somedb/datafile/somedb_cpp.291.848604621
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:23
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00024 name=+DATA/s00somedb/datafile/somedb_support.305.876591437
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:24
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00027 name=+DATA/s00somedb/datafile/somedb_arch_03.309.888669979
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:25
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00028 name=+DATA/s00somedb/datafile/somedb_arch_04_big.310.892636427
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/02/2015 10:46:26
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:26
ORA-17628: Oracle error 19505 returned by remote Oracle server

RMAN> exit


Recovery Manager complete.
[oracle@u00somedb12db-01 /home/oracle]$cd $ORACLE_HOME
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4]$cd bin
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all ora
orabase  oracg    oracle   oracleO  oradism  oraenv   orajaxb  orapipe  orapki   orapwd   orapwdO  oraxml   oraxsl   
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac
oracg    oracle   oracleO  
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac
oracg    oracle   oracleO  
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac*
-rwxr-xr-x 1 oracle oinstall        46 Nov  7  2000 oracg
-rwsr-s--x 1 oracle oinstall 239768932 Oct 23 17:36 oracle
-rwsr-s--x 1 oracle oinstall 239768900 Oct 23 17:36 oracleO
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$

[свернуть]

after check oracle binary group solution will be :

[root@u00somedb12db-01 ~]# /oracle/grid/12.1.0.2/bin/setasmgid -o=/oracle/app/base/db/11.2.0.4/bin/oracle
[root@u00somedb12db-01 ~]# 

Primary Sidebar

Яндекс.Метрика