Home > database >  Oracle Rman error ORA - 17629:/ORA - 17627:/ORA - 01017:
Oracle Rman error ORA - 17629:/ORA - 17627:/ORA - 01017:

Time:10-05

on both sides of the oracle is the same version of 11.2.0, but a redhat is a Windows platform,


[oracle @ testdb ~] $rman target sys/root @ former auxiliary sys/oracle @ ORCL2
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 28 14:52:32 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to the target database: former (DBID=1451001194)
Connected to auxiliary database: the former (not mounted)
RMAN> Duplicate the target database for standby from the active database;
Starting the Duplicate Db at 28 - OCT - 16
Home using target database control file recovery catalog
Allocated channel: ORA_AUX_DISK_1
The channel ORA_AUX_DISK_1: SID=193 device type=DISK
The contents of the Memory Script:
{
As backup copy reuse
Targetfile '/oracle/product/11.2.0/db_1/DBS/orapworcl' auxiliary format
'E: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ DATABASE \ PWDorcl ORA';
}
Executing the Memory Script
Starting backup at 28 - OCT - 16
Allocated channel: ORA_DISK_1
The channel ORA_DISK_1: SID=191 device type=DISK
RMAN - 00571:===========================================================
RMAN - 00569:===============ERROR MESSAGE STACK FOLLOWS===============
RMAN - 00571:===========================================================
RMAN - 03002: failure of Duplicate Db command at 10/28/2016 14:56:00
RMAN - 03015: an error occurred in stored script script Memory
RMAN - 03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 14:56:00
ORA - 17629: always connect to the remote database server
ORA - 17627: ORA - 01017: invalid username/password. Logon denied
ORA - 17629: always connect to the remote database server
RMAN> Duplicate the target database for standby from the active database;
Starting the Duplicate Db at 28 - OCT - 16
Using channel ORA_AUX_DISK_1
The contents of the Memory Script:
{
As backup copy reuse
Targetfile '/oracle/product/11.2.0/db_1/DBS/orapworcl' auxiliary format
'E: \ \ Administrator \ product \ app 11.2.0 \ dbhome_1 \ DATABASE \ PWDorcl ORA';
}
Executing the Memory Script
Starting backup at 28 - OCT - 16
Using channel ORA_DISK_1
RMAN - 00571:===========================================================
RMAN - 00569:===============ERROR MESSAGE STACK FOLLOWS===============
RMAN - 00571:===========================================================
RMAN - 03002: failure of Duplicate Db command at 10/28/2016 15:05:13
RMAN - 03015: an error occurred in stored script script Memory
RMAN - 03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 15:05:13
ORA - 17629: always connect to the remote database server
ORA - 17627: ORA - 01017: invalid username/password. Logon denied
ORA - 17629: always connect to the remote database server

Online method try many oh, have failed to solve,

CodePudding user response:

Look at the key information, invalid username/password; Logon denied, always connect to the remote database server
Database connection fails, affirmation can't perform rman,
Under the up sqlplus

Conn sys/root @ former as sysdba
Conn sys/oracle @ ORCL2 as sysdba
Look to whether can correctly connected two database

CodePudding user response:

reference 1st floor jdsnhan response:
look at the key information, invalid username/password. Logon denied, always connect to the remote database server
Database connection fails, affirmation can't perform rman,
Under the up sqlplus

Conn sys/root @ former as sysdba
Conn sys/oracle @ ORCL2 as sysdba
Look to whether can correctly connected two database
can normal connection, and rman can also be connected

CodePudding user response:

reference 1st floor jdsnhan response:
look at the key information, invalid username/password. Logon denied, always connect to the remote database server
Database connection fails, affirmation can't perform rman,
Under the up sqlplus

Conn sys/root @ former as sysdba
Conn sys/oracle @ ORCL2 as sysdba
Look to whether can correctly connected two database

This is on the former connection ORCL2, no problem, which in turn is also OK, RMAN can connect,, it is not the problem
[oracle @ testdb ~] $up sqlplus/nolog

SQL * Plus: Release 11.2.0.1.0 Production on Mon Oct 31 08:57:15 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> Conn sys/oracle @ ORCL2 as sysdba
Connected.

CodePudding user response:

The original poster is to do with hot backup to restore physical standby?

CodePudding user response:

See the official document:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382

CodePudding user response:

reference 5 floor jdsnhan reply:
see the official document:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcnctg.htm#BRADV89382


No, Linux is a 64 - bit Windows is 32-bit, always without success, finally my colleague after the primary database backup with the backup first, then using rman transmission as well as the dataguard subsequent operations are successful, don't know what's the bug

CodePudding user response:

The
reference 4 floor shanying_lv reply:
the original poster is to use hot backup to restore physical standby?
yesnullnullnullnullnullnull
  • Related