Немного продвинулся в своем вопросе.
Внимательно почитал
официальную документацию и
статью по файлам паролей .
Снес СУБД на резервном сервере (в WMWare вернулся на снимок, когда только установил ПО СУБД).
Начал все сначала на резервном сервере.
Создал службу LISTENER .
Затем, перестроил файл listener.ora резервного сервера:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
# listener.ora Network Configuration File: c:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = MyApexSB)
(ORACLE_HOME = c:\app\Administrator\product\11.2.0\dbhome_1)
(GLOBAL_DBNAME = MyApexSB)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\app\Administrator
Перестроил файл tnsnames.ora резервного сервера:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
MYAPEXLINE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myApexLine)
)
)
MYAPEXSB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myApexSB)
)
)
Перезапустил листенер:
1.
2.
lsnrctl stop
lsnrctl start
Добавил в винду переменные окружения на постоянной основе (ПКМ "Мой компьютер" - "Свойства" - "Дополнительные параметры системы" - вкладка "Дополнительно" - кнопка "Переменные среды" - в разделе "Системные переменные" кнопка "Создать"):
ORACLE_HOME = c:\app\Administrator\product\11.2.0\dbhome_1
ORACLE_BASE = c:\app\Administrator
С основного сервера скопировал файл с паролями в папку резервного сервера: c:\app\Administrator\product\11.2.0\dbhome_1\database\PWDmyApexSB.ora (имя файла PWD<SID>.ora).
Соответственно переименовал этот файл под сид резервной базы.
С основного сервера взял pfile (выгружал его ранее по
инструкции ) и положил его на резервный в папку:
c:\app\Administrator\product\11.2.0\dbhome_1\database\INITmyApexSB.ORA
Файл переименовал, но, на сколько я понимаю, для команды запуска инстанса с этим файлом имя и место его расположения значения не имеет. Просто это нужно указать в параметре pfile команды startup.
Внес в файл изменения (отметил параметром color=red - что-то он в этом спойлере не работает, ну хоть отметит, где я внес изменения):
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
[color=red]*.[/color]__db_cache_size=117440512
[color=red]*.[/color]__java_pool_size=4194304
[color=red]*.[/color]__large_pool_size=8388608
[color=red]*.[/color]__oracle_base='C:\app\Administrator'#ORACLE_BASE set from environment
[color=red]*.[/color]__pga_aggregate_target=171966464
[color=red]*.[/color]__sga_target=260046848
[color=red]*.[/color]__shared_io_pool_size=0
[color=red]*.[/color]__shared_pool_size=117440512
[color=red]*.[/color]__streams_pool_size=4194304
*.audit_file_dest='C:\app\Administrator\admin\[color=red]myApexSB[/color]\adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='C:\app\Administrator\oradata\[color=red]myApexSB[/color]\control01.ctl','C:\app\Administrator\fast_recovery_area\[color=red]myApexSB[/color]\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='[color=red]myApexSB[/color]'
*.db_recovery_file_dest='C:\app\Administrator\fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.db_unique_name='[color=red]myApexSB[/color]'
*.diagnostic_dest='C:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=myApexLineXDB)'
*.memory_target=428867584
*.nls_language='RUSSIAN'
*.nls_territory='RUSSIA'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.star_transformation_enabled='TRUE'
*.undo_tablespace='UNDOTBS1'
[color=red]*.db_create_file_dest='c:\app\Administrator\oradata\myApexSB'[/color]
[color=red]*.job_queue_processes=10[/color]
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(myApexLine,myApexSB)'
*.LOG_ARCHIVE_DEST_1= 'LOCATION=c:\app\Administrator\[color=red]myApexSB[/color]\archives VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=myApexLine'
*.LOG_ARCHIVE_DEST_2= 'SERVICE=[color=red]myApexLine[/color] LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_MAX_PROCESSES=30
# Standby role parameters --------------------------------------------------------------------
*.fal_server='myApexSB'
*.fal_client='myApexLine'
*.standby_file_management=auto
*.db_file_name_convert=[color=red]'myApexLine','myApexSB'[/color]
*.log_file_name_convert=[color=red]'myApexLine','myApexSB'[/color]
# ---------------------------------------------------------------------------------------------
Создал дирректории:
%ORACLE_BASE%/admin
%ORACLE_BASE%/admin/myApexSB
%ORACLE_BASE%/admin/myApexSB/adump
%ORACLE_BASE%/oradata
%ORACLE_BASE%/oradata/myApexSB
Запустил PowerShell и сделал переменную oracle_sid = myApexSB на время сеанса (вторая строчка, чтобы убедится в установке переменной):
1.
2.
3.
PS C:\Users\Administrator> $env:oracle_sid = "myApexSB"
PS C:\Users\Administrator> $env:oracle_sid
myApexSB
То же самое в обычном CMD можно сделать так:
1.
2.
set oracle_sid = myApexSB
echo %oracle_sid%
Затем что в PS, что в CMD идет одинаково. Создаем инстанс myApexSB без его запуска:
1.
2.
PS C:\Users\Administrator> oradim -NEW -SID myApexSB -STARTMODE MANUAL
Instance created.
Далее:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
PS C:\Users\Administrator> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Oct 2 20:09:11 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='c:\app\Administrator\product\11.2.0\dbhome_1\database\initmyApexSB.ora';
ORACLE instance started.
Total System Global Area 430075904 bytes
Fixed Size 2281936 bytes
Variable Size 335547952 bytes
Database Buffers 88080384 bytes
Redo Buffers 4165632 bytes
Далее я взял RMAN-скрипт из
официальной документации cr_phys_sby1.txt и переделал его под себя :
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'myApexLine','myApexSB'
set db_unique_name='myApexSB'
set db_file_name_convert='myApexLine','myApexSB'
set log_file_name_convert='myApexLine','myApexSB'
set control_files='c:\app\Administrator\oradata\myApexSB\myApexSB.ctl'
set log_archive_max_processes='5'
set fal_client='myApexSB'
set fal_server='myApexLine'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(myApexLine,myApexSB)'
set log_archive_dest_2='service=myApexLine ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=myApexLine'
;
}
Скрипт поместил на основной сервер в папку c:\Share\ (не важно какая папка, главное на нее переключится в PS или CMD с помощью команды CD).
Далее на основном сервере я работал в PowerShell-e:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
cd c:\Share\
PS C:\Users\Administrator> $env:oracle_sid = "myApexLine"
PS C:\Users\Administrator> $env:oracle_sid
myApexLine
PS C:\Share> rman
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 2 21:09:50 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys
target database Password:
connected to target database: MYAPEXLI (DBID=658386243)
using target database control file instead of recovery catalog
RMAN> connect auxiliary sys@myApexSB
auxiliary database Password:
connected to auxiliary database: MYAPEXSB (not mounted)
RMAN> @cr_phys_sby1.txt
Далее идет выполнение скрипта:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
RMAN> run {
2> allocate channel prmy1 type disk;
3> allocate channel prmy2 type disk;
4> allocate channel prmy3 type disk;
5> allocate channel prmy4 type disk;
6> allocate auxiliary channel stby type disk;
7> duplicate target database for standby from active database
8> spfile
9> parameter_value_convert 'myApexLine','myApexSB'
10> set db_unique_name='myApexSB'
11> set db_file_name_convert='myApexLine','myApexSB'
12> set log_file_name_convert='myApexLine','myApexSB'
13> set control_files='c:\app\Administrator\oradata\myApexSB\myApexSB.ctl'
14> set log_archive_max_processes='5'
15> set fal_client='myApexSB'
16> set fal_server='myApexLine'
17> set standby_file_management='AUTO'
18> set log_archive_config='dg_config=(myApexLine,myApexSB)'
19> set log_archive_dest_2='service=myApexLine ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=
myApexLine'
20> ;
21> }
allocated channel: prmy1
channel prmy1: SID=88 device type=DISK
allocated channel: prmy2
channel prmy2: SID=64 device type=DISK
allocated channel: prmy3
channel prmy3: SID=1 device type=DISK
allocated channel: prmy4
channel prmy4: SID=75 device type=DISK
allocated channel: stby
channel stby: SID=20 device type=DISK
Starting Duplicate Db at 02-OCT-16
contents of Memory Script:
{
backup as copy reuse
targetfile 'C:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDmyapexline.ORA' auxiliary format
'c:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDmyapexsb.ORA' targetfile
'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMYAPEXLINE.ORA' auxiliary format
'C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMYAPEXSB.ORA' ;
sql clone "alter system set spfile= ''C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMYAPEXSB.ORA''";
}
executing Memory Script
Starting backup at 02-OCT-16
Finished backup at 02-OCT-16
sql statement: alter system set spfile= ''C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEMYAPEXSB.ORA''
contents of Memory Script:
{
sql clone "alter system set audit_file_dest =
''C:\app\Administrator\admin\myApexSB\adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=myApexSBXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''LOCATION=c:\app\Administrator\product\11.2.0\dbhome_1\database\archive\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_
NAME=myApexSB'' comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''myApexSB'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''myApexLine'', ''myApexSB'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''myApexLine'', ''myApexSB'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''c:\app\Administrator\oradata\myApexSB\myApexSB.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_max_processes =
5 comment=
'''' scope=spfile";
sql clone "alter system set fal_client =
''myApexSB'' comment=
'''' scope=spfile";
sql clone "alter system set fal_server =
''myApexLine'' comment=
'''' scope=spfile";
sql clone "alter system set standby_file_management =
''AUTO'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_config =
''dg_config=(myApexLine,myApexSB)'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_2 =
''service=myApexLine ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=myApexLine'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set audit_file_dest = ''C:\app\Administrator\admin\myApexSB\adump'' comment= '''' scope=sp
file
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=myApexSBXDB)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_1 = ''LOCATION=c:\app\Administrator\product\11.2.0\dbhome_1\database\
archive\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=myApexSB'' comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''myApexSB'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''myApexLine'', ''myApexSB'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''myApexLine'', ''myApexSB'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''c:\app\Administrator\oradata\myApexSB\myApexSB.ctl'' comment= '''' s
cope=spfile
sql statement: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile
sql statement: alter system set fal_client = ''myApexSB'' comment= '''' scope=spfile
sql statement: alter system set fal_server = ''myApexLine'' comment= '''' scope=spfile
sql statement: alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile
sql statement: alter system set log_archive_config = ''dg_config=(myApexLine,myApexSB)'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_2 = ''service=myApexLine ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE
) db_unique_name=myApexLine'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 430075904 bytes
Fixed Size 2281936 bytes
Variable Size 339742256 bytes
Database Buffers 83886080 bytes
Redo Buffers 4165632 bytes
allocated channel: stby
channel stby: SID=19 device type=DISK
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format 'C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\MYAPEXSB.CTL'
;
}
executing Memory Script
Starting backup at 02-OCT-16
channel prmy1: starting datafile copy
copying standby control file
output file name=C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFMYAPEXLINE.ORA tag=TAG20161002T211129 RECID=2
STAMP=924210690
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 02-OCT-16
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\TEMP01.DBF";
switch clone tempfile all;
set newname for datafile 1 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\SYSAUX01.DBF";
set newname for datafile 3 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\UNDOTBS01.DBF";
set newname for datafile 4 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\USERS01.DBF";
set newname for datafile 5 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\INDX01.DBF";
set newname for datafile 6 to
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\CARD101.DBF";
backup as copy reuse
datafile 1 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\SYSTEM01.DBF" datafile
2 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\SYSAUX01.DBF" datafile
3 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\UNDOTBS01.DBF" datafile
4 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\USERS01.DBF" datafile
5 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\INDX01.DBF" datafile
6 auxiliary format
"C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\CARD101.DBF" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\TEMP01.DBF 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
Starting backup at 02-OCT-16
channel prmy1: starting datafile copy
input datafile file number=00006 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\CARD101.DBF
channel prmy2: starting datafile copy
input datafile file number=00005 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\INDX01.DBF
channel prmy3: starting datafile copy
input datafile file number=00001 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\SYSTEM01.DBF
channel prmy4: starting datafile copy
input datafile file number=00002 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\SYSAUX01.DBF
RMAN-03009: failure of backup command on prmy2 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
continuing other job steps, job failed will not be re-run
channel prmy2: starting datafile copy
input datafile file number=00003 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\UNDOTBS01.DBF
RMAN-03009: failure of backup command on prmy3 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
continuing other job steps, job failed will not be re-run
channel prmy3: starting datafile copy
input datafile file number=00004 name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXLINE\USERS01.DBF
RMAN-03009: failure of backup command on prmy4 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
continuing other job steps, job failed will not be re-run
output file name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\USERS01.DBF tag=TAG20161002T211136
channel prmy3: datafile copy complete, elapsed time: 00:00:04
output file name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\UNDOTBS01.DBF tag=TAG20161002T211136
channel prmy2: datafile copy complete, elapsed time: 00:01:16
output file name=C:\APP\ADMINISTRATOR\ORADATA\MYAPEXSB\CARD101.DBF tag=TAG20161002T211136
channel prmy1: datafile copy complete, elapsed time: 00:27:23
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/02/2016 21:39:00
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy2 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
RMAN-03009: failure of backup command on prmy4 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
RMAN-03009: failure of backup command on prmy3 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
RMAN> **end-of-file**
RMAN>
Вот теперь не знаю, критичны ли ошибки в конце выполнения скрипта?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/02/2016 21:39:00
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy2 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
RMAN-03009: failure of backup command on prmy4 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
RMAN-03009: failure of backup command on prmy3 channel at 10/02/2016 21:12:22
ORA-03113: end-of-file on communication channel
Вроде какие-то данные все-таки передались в резервную базу.
Мозг уже не работает. Завтра буду уже разбираться. Потом отпишусь.
Всем доброй ночи :)
