Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Ошибка при RMAN duplicate target database for standby from active database  [new]
xtender
Member

Откуда: Мск
Сообщений: 5704
Подскажите, плиз, не могу понять в чем проблема:
+
RMAN> run
2> {
3> duplicate target database for standby
4>    FROM ACTIVE DATABASE
5>    DORECOVER
6>    SPFILE
7>    set db_unique_name='TMDSTB2'
8>    set fal_client='TMDSTB2'
9>    set fal_server='TMDLIVE','TMDSTBY'
10>    set log_archive_config='DG_CONFIG=(TMDLIVE,TMDSTBY,TMDSTB2)'
11>    set log_archive_dest_2='SERVICE=TMDLIVE LGWR ASYNC NOAFFIRM VALID_FOR=(ON
LINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDLIVE'
12>    set log_archive_dest_3='SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ON
LINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY'
13>    nofilenamecheck;
14> }

Starting Duplicate Db at 19-SEP-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
current log archived

contents of Memory Script:
{
   backup as copy reuse
   targetfile  'D:\Oracle\product\12.1.0\dbhome_1\DATABASE\PWDtmdlive.ORA' auxil
iary format
 'D:\Oracle\product\12.1.0\dbhome_1\DATABASE\PWDtmdstb2.ORA'   ;
   restore clone from service  'TMDLIVE' spfile to
 'D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILETMDSTB2.ORA';
   sql clone "alter system set spfile= ''D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATAB
ASE\SPFILETMDSTB2.ORA''";
}
executing Memory Script

Starting backup at 19-SEP-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 device type=DISK
Finished backup at 19-SEP-16

Starting restore at 19-SEP-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TMDLIVE
channel ORA_AUX_DISK_1: restoring SPFILE
output file name=D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILETMDSTB2.ORA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 19-SEP-16

sql statement: alter system set spfile= ''D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATA
BASE\SPFILETMDSTB2.ORA''

contents of Memory Script:
{
   sql clone "alter system set  db_unique_name =
 ''TMDSTB2'' comment=
 '''' scope=spfile";
   sql clone "alter system set  fal_client =
 ''TMDSTB2'' comment=
 '''' scope=spfile";
   sql clone "alter system set  fal_server =
 ''TMDLIVE'', ''TMDSTBY'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_config =
 ''DG_CONFIG=(TMDLIVE,TMDSTBY,TMDSTB2)'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_2 =
 ''SERVICE=TMDLIVE LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=TMDLIVE'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_3 =
 ''SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=TMDSTBY'' comment=
 '''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_unique_name =  ''TMDSTB2'' comment= '''' sco
pe=spfile

sql statement: alter system set  fal_client =  ''TMDSTB2'' comment= '''' scope=s
pfile

sql statement: alter system set  fal_server =  ''TMDLIVE'', ''TMDSTBY'' comment=
 '''' scope=spfile

sql statement: alter system set  log_archive_config =  ''DG_CONFIG=(TMDLIVE,TMDS
TBY,TMDSTB2)'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_2 =  ''SERVICE=TMDLIVE LGWR AS
YNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDLIVE'' c
omment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_3 =  ''SERVICE=TMDSTBY LGWR AS
YNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY'' c
omment= '''' scope=spfile

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/19/2016 10:56:03
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-03113: end-of-file on communication channel

alert.log:
+
Mon Sep 19 10:54:48 2016
ALTER SYSTEM SET log_archive_dest_3='SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY' SCOPE=SPFILE;
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 5
alter database close
ORA-1507 signalled during: alter database close...
alter database dismount
ORA-1507 signalled during: alter database dismount...
Mon Sep 19 10:54:57 2016
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Sep 19 10:54:58 2016
Stopping background process VKTM
Mon Sep 19 10:55:02 2016
Instance shutdown complete

Вроде ORA-1507 signalled during: alter database close... вполне ожидаемо, так как запущено c nomount, не из-за этого же происходит "ORA-03113: end-of-file on communication channel"?
19 сен 16, 15:09    [19683148]     Ответить | Цитировать Сообщить модератору
 Re: Ошибка при RMAN duplicate target database for standby from active database  [new]
xtender
Member

Откуда: Мск
Сообщений: 5704
Спасибо, уже неактуально usolcew уже помог :)
автор
A1.8) Windows only:
If the Server's sqlnet.ora file contains Authentication services
which are NOT reachable by Oracle, then an ORA-3113 error will
result.
For example, if the sqlnet.ora file contains the parameter:
SQLNET.AUTHENTICATION_SERVICES = (NTS) and the Oracle database
is moved from a Windows NT Domain to an Active Directory one,
or if a Domain Controller is introduced, then an error will result
trying to start the database.
Remove the sqlnet.authentication_services line so that Oracle
does not look for a non-existent KDC (Kerberos Domain Controller).
19 сен 16, 15:51    [19683444]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить