Ноябрь 2015 – Страница 2

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

[code language=”bash” highlight=”398-400″]
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

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

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]$
[/code]

[свернуть]

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 ~]#

bushmelev-aa.ru

Posts from Ноябрь 2015

Enable unified auditing option

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

Primary Sidebar