活动第28/29次（2018-06-16星期六上下午）
FROM ACTIVE DATABASE实验：1. 准备initdbclone1.ora：
db_name=dbclone1
db_domain=example.com2.准备orapwdbclone1：
orapwd file=orapwdbclone1 password=oracle_4Uentries=43.启动auxiliary实例。（目的地实例）
先写/etc/oratab：
+ASM:/u01/app/oracle/product/11.2.0/grid:N
winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
再. oraenv
4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dbclone1.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
DBCLONE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone1.example.com)
)
)
6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：
在目的地操作系统上建一下adump目录：
mkdir -p /u01/app/oracle/admin/dbclone1/adump
run {
duplicate target database to dbclone1
from active database
nofilenamecheck
spfile
set
control_files='+DATA','+FRA'
set
db_file_name_convert='+DATA/orcl/','+DATA/dbclone1/'
set
log_file_name_convert='+DATA/orcl/','+DATA/dbclone1/','+FRA/orcl','+FRA/dbclone1/'
set
audit_file_dest='/u01/app/oracle/admin/dbclone1/adump';
}7. 具体执行命令：
$ rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone1cmdfile=dbclone1.rcv内存脚本的执行全过程（输出）：
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 16 10:52:18 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
connected to target database: ORCL (DBID=1359978017)
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in AUXILIARY database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in AUXILIARY database is not current
connected to auxiliary database: DBCLONE1 (not mounted)
RMAN> exit
Recovery Manager complete.
$ rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone1cmdfile=dbclone1.rcv
Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 16 10:52:53 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
connected to target database: ORCL (DBID=1359978017)
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in AUXILIARY database is not current
PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in AUXILIARY database is not current
connected to auxiliary database: DBCLONE1 (not mounted)
RMAN> run {
2> duplicate target database to dbclone1
3> from active database
4> nofilenamecheck
5> spfile
6> set
7> control_files='+DATA','+FRA'
8> set
9> db_file_name_convert='+DATA/orcl/','+DATA/dbclone1/'
10> set
11> log_file_name_convert='+DATA/orcl/','+DATA/dbclone1/','+FRA/orcl','+FRA/dbclone1/'
12> set
13> audit_file_dest='/u01/app/oracle/admin/dbclone1/adump';
14> }
15>
Starting Duplicate Db at 16-JUN-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=95 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=10 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=97 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=11 device type=DISK
allocated channel: ORA_AUX_DISK_5
channel ORA_AUX_DISK_5: SID=98 device type=DISK
allocated channel: ORA_AUX_DISK_6
channel ORA_AUX_DISK_6: SID=12 device type=DISK
allocated channel: ORA_AUX_DISK_7
channel ORA_AUX_DISK_7: SID=99 device type=DISK
allocated channel: ORA_AUX_DISK_8
channel ORA_AUX_DISK_8: SID=13 device type=DISK
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=100 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_AUX_SBT_TAPE_2
channel ORA_AUX_SBT_TAPE_2: SID=14 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
contents of Memory Script:
{
backup as copy reuse
targetfile'+DATA/orcl/spfileorcl.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora''";
}
executing Memory Script
Starting backup at 16-JUN-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=138 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=195 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=11 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=71 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=140 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=200 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=12 device type=DISK
Finished backup at 16-JUN-18
sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora''
contents of Memory Script:
{
sql clone "alter system setdb_name =
''DBCLONE1'' comment=
''duplicate'' scope=spfile";
sql clone "alter system setcontrol_files =
''+DATA'', ''+FRA'' comment=
'''' scope=spfile";
sql clone "alter system setdb_file_name_convert =
''+DATA/orcl/'', ''+DATA/dbclone1/'' comment=
'''' scope=spfile";
sql clone "alter system setlog_file_name_convert =
''+DATA/orcl/'', ''+DATA/dbclone1/'', ''+FRA/orcl'', ''+FRA/dbclone1/'' comment=
'''' scope=spfile";
sql clone "alter system setaudit_file_dest =
''/u01/app/oracle/admin/dbclone1/adump'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system setdb_name =''DBCLONE1'' comment= ''duplicate'' scope=spfile
sql statement: alter system setcontrol_files =''+DATA'', ''+FRA'' comment= '''' scope=spfile
sql statement: alter system setdb_file_name_convert =''+DATA/orcl/'', ''+DATA/dbclone1/'' comment= '''' scope=spfile
sql statement: alter system setlog_file_name_convert =''+DATA/orcl/'', ''+DATA/dbclone1/'', ''+FRA/orcl'', ''+FRA/dbclone1/'' comment= '''' scope=spfile
sql statement: alter system setaudit_file_dest =''/u01/app/oracle/admin/dbclone1/adump'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 820236288 bytes
Fixed Size 1339628 bytes
Variable Size 482348820 bytes
Database Buffers 331350016 bytes
Redo Buffers 5197824 bytes
contents of Memory Script:
{
sql clone "alter system setcontrol_files =
''+DATA/dbclone1/controlfile/current.266.978979989'', ''+FRA/dbclone1/controlfile/current.320.978979991'' comment=
''Set by RMAN'' scope=spfile";
sql clone "alter system setdb_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system setdb_unique_name =
''DBCLONE1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format'+DATA/dbclone1/controlfile/current.264.978979991';
restore clone controlfile to'+FRA/dbclone1/controlfile/current.258.978979991' from
'+DATA/dbclone1/controlfile/current.264.978979991';
sql clone "alter system setcontrol_files =
''+DATA/dbclone1/controlfile/current.264.978979991'', ''+FRA/dbclone1/controlfile/current.258.978979991'' comment=
''Set by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
alter clone database mount;
}
executing Memory Script
sql statement: alter system setcontrol_files = ''+DATA/dbclone1/controlfile/current.266.978979989'', ''+FRA/dbclone1/controlfile/current.320.978979991'' comment= ''Set by RMAN'' scope=spfile
sql statement: alter system setdb_name =''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system setdb_unique_name =''DBCLONE1'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 820236288 bytes
Fixed Size 1339628 bytes
Variable Size 482348820 bytes
Database Buffers 331350016 bytes
Redo Buffers 5197824 bytes
Starting backup at 16-JUN-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f tag=TAG20180616T105316 RECID=2 STAMP=978951197
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 16-JUN-18
Starting restore at 16-JUN-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=13 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=135 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=136 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=15 device type=DISK
allocated channel: ORA_AUX_DISK_5
channel ORA_AUX_DISK_5: SID=137 device type=DISK
allocated channel: ORA_AUX_DISK_6
channel ORA_AUX_DISK_6: SID=16 device type=DISK
allocated channel: ORA_AUX_DISK_7
channel ORA_AUX_DISK_7: SID=138 device type=DISK
allocated channel: ORA_AUX_DISK_8
channel ORA_AUX_DISK_8: SID=17 device type=DISK
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=139 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_AUX_SBT_TAPE_2
channel ORA_AUX_SBT_TAPE_2: SID=18 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_5: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_6: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_7: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_8: skipped, AUTOBACKUP already found
channel ORA_AUX_SBT_TAPE_1: skipped, AUTOBACKUP already found
channel ORA_AUX_SBT_TAPE_2: skipped, AUTOBACKUP already found
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 16-JUN-18
sql statement: alter system setcontrol_files = ''+DATA/dbclone1/controlfile/current.264.978979991'', ''+FRA/dbclone1/controlfile/current.258.978979991'' comment= ''Set by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 820236288 bytes
Fixed Size 1339628 bytes
Variable Size 482348820 bytes
Database Buffers 331350016 bytes
Redo Buffers 5197824 bytes
database mounted
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 datafile1 to
"+data";
set newname for datafile2 to
"+data";
set newname for datafile3 to
"+data";
set newname for datafile4 to
"+data";
set newname for datafile5 to
"+data";
backup as copy reuse
datafile1 auxiliary format
"+data" datafile
2 auxiliary format
"+data" datafile
3 auxiliary format
"+data" datafile
4 auxiliary format
"+data" datafile
5 auxiliary format
"+data" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 16-JUN-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
channel ORA_DISK_2: starting datafile copy
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
channel ORA_DISK_3: starting datafile copy
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
channel ORA_DISK_4: starting datafile copy
input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
channel ORA_DISK_5: starting datafile copy
input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
output file name=+DATA/dbclone1/datafile/users.259.978980031 tag=TAG20180616T105349
channel ORA_DISK_5: datafile copy complete, elapsed time: 00:00:15
output file name=+DATA/dbclone1/datafile/example.265.978980031 tag=TAG20180616T105349
channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:45
output file name=+DATA/dbclone1/datafile/undotbs1.267.978980031 tag=TAG20180616T105349
channel ORA_DISK_3: datafile copy complete, elapsed time: 00:01:25
output file name=+DATA/dbclone1/datafile/system.260.978980031 tag=TAG20180616T105349
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:09
output file name=+DATA/dbclone1/datafile/sysaux.268.978980031 tag=TAG20180616T105349
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:02:09
Finished backup at 16-JUN-18
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like"+FRA/orcl/archivelog/2018_06_16/thread_1_seq_4.351.978951273" auxiliary format
"+FRA" archivelog like
"+FRA/orcl/archivelog/2018_06_16/thread_1_seq_5.352.978951293" auxiliary format
"+FRA" archivelog like
"+FRA/orcl/archivelog/2018_06_16/thread_1_seq_6.359.978951361" auxiliary format
"+FRA" ;
catalog clone start with"+FRA";
switch clone datafile all;
}
executing Memory Script
Starting backup at 16-JUN-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=4 RECID=105 STAMP=978951276
channel ORA_DISK_2: starting archived log copy
input archived log thread=1 sequence=5 RECID=106 STAMP=978951296
channel ORA_DISK_3: starting archived log copy
input archived log thread=1 sequence=6 RECID=107 STAMP=978951361
output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163 RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07
output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163 RECID=0 STAMP=0
channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:07
output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163 RECID=0 STAMP=0
channel ORA_DISK_3: archived log copy complete, elapsed time: 00:00:07
Finished backup at 16-JUN-18
searching for all files that match the pattern +FRA
List of Files Unknown to the Database
=====================================
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_4.266.978980163
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_5.296.978980163
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_6.293.978980163
File Name: +fra/DBCLONE1/CONTROLFILE/Current.320.978979991
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_4.266.978980163
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_5.296.978980163
File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_6.293.978980163
List of Files Which Where Not Cataloged
=======================================
File Name: +fra/DBCLONE1/CONTROLFILE/Current.320.978979991
RMAN-07517: Reason: The file header is corrupted
datafile 1 switched to datafile copy
input datafile copy RECID=2 STAMP=978980170 file name=+DATA/dbclone1/datafile/system.260.978980031
datafile 2 switched to datafile copy
input datafile copy RECID=3 STAMP=978980170 file name=+DATA/dbclone1/datafile/sysaux.268.978980031
datafile 3 switched to datafile copy
input datafile copy RECID=4 STAMP=978980170 file name=+DATA/dbclone1/datafile/undotbs1.267.978980031
datafile 4 switched to datafile copy
input datafile copy RECID=5 STAMP=978980170 file name=+DATA/dbclone1/datafile/users.259.978980031
datafile 5 switched to datafile copy
input datafile copy RECID=6 STAMP=978980170 file name=+DATA/dbclone1/datafile/example.265.978980031
contents of Memory Script:
{
set until scn1161526;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 16-JUN-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=135 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=15 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=14 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=137 device type=DISK
allocated channel: ORA_AUX_DISK_5
channel ORA_AUX_DISK_5: SID=138 device type=DISK
allocated channel: ORA_AUX_DISK_6
channel ORA_AUX_DISK_6: SID=139 device type=DISK
allocated channel: ORA_AUX_DISK_7
channel ORA_AUX_DISK_7: SID=18 device type=DISK
allocated channel: ORA_AUX_DISK_8
channel ORA_AUX_DISK_8: SID=140 device type=DISK
allocated channel: ORA_AUX_SBT_TAPE_1
channel ORA_AUX_SBT_TAPE_1: SID=19 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_AUX_SBT_TAPE_2
channel ORA_AUX_SBT_TAPE_2: SID=141 device type=SBT_TAPE
channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
starting media recovery
archived log for thread 1 with sequence 4 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163
archived log for thread 1 with sequence 5 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163
archived log for thread 1 with sequence 6 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163
archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163 thread=1 sequence=4
archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163 thread=1 sequence=5
archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163 thread=1 sequence=6
media recovery complete, elapsed time: 00:00:17
Finished recover at 16-JUN-18
Oracle instance started
Total System Global Area 820236288 bytes
Fixed Size 1339628 bytes
Variable Size 482348820 bytes
Database Buffers 331350016 bytes
Redo Buffers 5197824 bytes
contents of Memory Script:
{
sql clone "alter system setdb_name =
''DBCLONE1'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system resetdb_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system setdb_name =''DBCLONE1'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system resetdb_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 820236288 bytes
Fixed Size 1339628 bytes
Variable Size 482348820 bytes
Database Buffers 331350016 bytes
Redo Buffers 5197824 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DBCLONE1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '+data', '+fra' ) SIZE 50 MREUSE,
GROUP 2 ( '+data', '+fra' ) SIZE 50 MREUSE,
GROUP 3 ( '+data', '+fra' ) SIZE 50 MREUSE
DATAFILE
'+DATA/dbclone1/datafile/system.260.978980031'
CHARACTER SET AL32UTF8
contents of Memory Script:
{
set newname for tempfile1 to
"+data";
switch clone tempfile all;
catalog clone datafilecopy"+DATA/dbclone1/datafile/sysaux.268.978980031",
"+DATA/dbclone1/datafile/undotbs1.267.978980031",
"+DATA/dbclone1/datafile/users.259.978980031",
"+DATA/dbclone1/datafile/example.265.978980031";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
cataloged datafile copy
datafile copy file name=+DATA/dbclone1/datafile/sysaux.268.978980031 RECID=1 STAMP=978980209
cataloged datafile copy
datafile copy file name=+DATA/dbclone1/datafile/undotbs1.267.978980031 RECID=2 STAMP=978980209
cataloged datafile copy
datafile copy file name=+DATA/dbclone1/datafile/users.259.978980031 RECID=3 STAMP=978980209
cataloged datafile copy
datafile copy file name=+DATA/dbclone1/datafile/example.265.978980031 RECID=4 STAMP=978980209
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=978980209 file name=+DATA/dbclone1/datafile/sysaux.268.978980031
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=978980209 file name=+DATA/dbclone1/datafile/undotbs1.267.978980031
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=978980209 file name=+DATA/dbclone1/datafile/users.259.978980031
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=978980209 file name=+DATA/dbclone1/datafile/example.265.978980031
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 16-JUN-18
Recovery Manager complete.
$
8. 在目的地数据库这边，注册：
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station87
ora.FRA.dg ora....up.type ONLINE ONLINE station87
ora....ER.lsnr ora....er.type ONLINE ONLINE station87
ora.asm ora.asm.type ONLINE ONLINE station87
ora.cssd ora.cssd.typeONLINE ONLINE station87
ora.diskmon ora....on.type ONLINE ONLINE station87
$ srvctl add database -d dbclone1 -o /u01/app/oracle/product/11.2.0/dbhome_1
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station87
ora.FRA.dg ora....up.type ONLINE ONLINE station87
ora....ER.lsnr ora....er.type ONLINE ONLINE station87
ora.asm ora.asm.type ONLINE ONLINE station87
ora.cssd ora.cssd.typeONLINE ONLINE station87
ora....one1.db ora....se.type OFFLINE OFFLINE
ora.diskmon ora....on.type ONLINE ONLINE station87
$ srvctl start database -d dbclone1
$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE station87
ora.FRA.dg ora....up.type ONLINE ONLINE station87
ora....ER.lsnr ora....er.type ONLINE ONLINE station87
ora.asm ora.asm.type ONLINE ONLINE station87
ora.cssd ora.cssd.typeONLINE ONLINE station87
ora....one1.db ora....se.type ONLINE ONLINE station87
ora.diskmon ora....on.type ONLINE ONLINE station87
$
FROM ACTIVE DATABASE实验（源头是ASM目的地是文件系统）：
1. 准备initdbclone2.ora：
db_name=dbclone2
db_domain=example.com2.准备orapwdbclone2：
orapwd file=orapwdbclone2 password=oracle_4Uentries=43.启动auxiliary实例。（目的地实例）
先写/etc/oratab：
+ASM:/u01/app/oracle/product/11.2.0/grid:N
winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
dbclone2:/u01/app/oracle/product/11.2.0/dbhome_1:N
再. oraenv
4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dbclone1.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone1)
)
(SID_DESC =
(GLOBAL_DBNAME = dbclone2.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone2)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
DBCLONE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone1.example.com)
)
)
DBCLONE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone2.example.com)
)
)
6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：
在目的地操作系统上建一下adump目录：
mkdir -p /u01/app/oracle/admin/dbclone2/adump
mkdir -p /u01/app/oracle/oradata/dbclone2
mkdir -p /u01/app/oracle/fast_recovery_area
顺便测试一下：选一部份表空间，不选另外一部分表空间：
SQL> conn / as sysdba
Connected.
SQL> selecttablespacE_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
6 rows selected.
SQL> create tablespace tbs1 datafile size 5M ;
Tablespace created.
SQL> create tablespace tbs2 datafile size 5M ;
Tablespace created.
SQL> create table t1(a number)tablespacetbs1;
Table created.
SQL> insert into t1 values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> create table hr.t2(a number)tablespacetbs2;
Table created.
SQL> insert into hr.t2 values (1) ;
1 row created.
SQL> commit;
Commit complete.
SQL>
对排除的表空间一定要做“自包含 集检查”：
SQL> exec dbms_tts.TRANSPORT_SET_CHECK('tbs1,tbs2');
PL/SQL procedure successfully completed.
SQL> select * from transport_set_violations;
VIOLATIONS
--------------------------------------------------------------------------------
ORA-39917: SYS owned object T1 in tablespace TBS1 not allowed in pluggable set
处理办法都是“移走”：
SQL> alter table T1move tablespace system;
Table altered.
run{
duplicate target database to dbclone2
from active database
nofilenamecheck
skip tablespace 'TBS1','TBS2'
spfile
set
control_files='/u01/app/oracle/oradata/dbclone2/control01.ctl','/u01/app/oracle/oradata/dbclone2/control02.ctl','/u01/app/oracle/oradata/dbclone2/control03.ctl'
set
db_file_name_convert='+DATA/orcl/datafile/example.257.978643425','/u01/app/oracle/oradata/dbclone2/example01.dbf','+DATA/orcl/datafile/users.265.978645015','/u01/app/oracle/oradata/dbclone2/users01.dbf','+DATA/orcl/datafile/undotbs1.259.978643423','/u01/app/oracle/oradata/dbclone2/undotbs01.dbf','+DATA/orcl/datafile/sysaux.258.978643425','/u01/app/oracle/oradata/dbclone2/sysaux01.dbf','+DATA/orcl/datafile/system.256.978643425','/u01/app/oracle/oradata/dbclone2/system01.dbf'
set
log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.978643689','/u01/app/oracle/oradata/dbclone2/redo01a.log','+FRA/orcl/onlinelog/group_1.257.978643689','/u01/app/oracle/oradata/dbclone2/redo01b.log','+DATA/orcl/onlinelog/group_3.263.978643691','/u01/app/oracle/oradata/dbclone2/redo03a.log','+FRA/orcl/onlinelog/group_3.259.978643691','/u01/app/oracle/oradata/dbclone2/redo03b.log','+DATA/orcl/onlinelog/group_2.262.978643689','/u01/app/oracle/oradata/dbclone2/redo02a.log','+FRA/orcl/onlinelog/group_2.258.978643691','/u01/app/oracle/oradata/dbclone2/redo02b.log'
set
audit_file_dest='/u01/app/oracle/admin/dbclone2/adump'
set
db_create_file_dest=''
set
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
set
memory_target='2G'
;
}
rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone2 cmdfile=dbclone2.rcv
BACKUP LOCATION实验：
1. 准备initdbclone3.ora：
db_name=dbclone3
db_domain=example.com2.准备orapwdbclone3：
orapwd file=orapwdbclone3 password=oracle_4Uentries=43.启动auxiliary实例。（目的地实例）
先写/etc/oratab：
+ASM:/u01/app/oracle/product/11.2.0/grid:N
winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
dbclone2:/u01/app/oracle/product/11.2.0/dbhome_1:N
dbclone3:/u01/app/oracle/product/11.2.0/dbhome_1:N
再. oraenv
4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dbclone1.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone1)
)
(SID_DESC =
(GLOBAL_DBNAME = dbclone2.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone2)
)
(SID_DESC =
(GLOBAL_DBNAME = dbclone3.example.com)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = dbclone3)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.example.com)
)
)
DBCLONE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone1.example.com)
)
)
DBCLONE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone2.example.com)
)
)
DBCLONE3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbclone3.example.com)
)
)
6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：
在目的地操作系统上建一下adump目录：
mkdir -p /u01/app/oracle/admin/dbclone3/adump7. 在源头和目的地机器上都建一个相同的目录：
mkdir /home/oracle/backup8. 在源头数据库上做备份（源头备份做完后，可以关闭）：run {
allocate channelc1 device type disk format '/home/oracle/backup/%U';
allocate channelc2 device type disk format '/home/oracle/backup/%U';
allocate channelc3 device type disk format '/home/oracle/backup/%U';
allocate channelc4 device type disk format '/home/oracle/backup/%U';
allocate channelc5 device type disk format '/home/oracle/backup/%U';
allocate channelc6 device type disk format '/home/oracle/backup/%U';
allocate channelc7 device type disk format '/home/oracle/backup/%U';
allocate channelc8 device type disk format '/home/oracle/backup/%U';
backup database plus archivelog force;
backup spfile;
backup current controlfile;
}以上脚本结束后，把源头/home/oracle/backup/*传送到目的地/home/oracle/backup/
$ scp * station87:/home/oracle/backup/
The authenticity of host 'station87 (192.168.0.87)' can't be established.
RSA key fingerprint is 3c:21:7a:9c:cd:d9:41:16:75:08:fe:16:4d:37:54:5b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'station87,192.168.0.87' (RSA) to the list of known hosts.
oracle@station87's password:
2et5jl2p_1_1 100% 21MB21.3MB/s 00:00
2ft5jl2p_1_1 100% 43MB21.7MB/s 00:02
2gt5jl2q_1_1 100% 46MB45.9MB/s 00:01
2ht5jl2r_1_1 顺便试一下新语法，老的语法供参考和显式分配通道：
run{
duplicate target database to mydb
backup location '/home/oracle/backup'
nofilenamecheck
spfile
set
control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/db11g/control02.ctl','/u01/app/oracle/oradata/db11g/control03.ctl'
set
db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/db11g/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/db11g/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/db11g/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/db11g/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/db11g/system01.dbf'
set
log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/db11g/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/db11g/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/db11g/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/db11g/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/db11g/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/db11g/redo02b.log'
set
audit_file_dest='/u01/app/oracle/admin/mydb/adump'
set
db_create_file_dest=''
set
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
}
新的语法：
在目的地机器上创建/u01/app/oracle/oradata/dbclone3
run {
allocateauxiliary channel c1 device type disk;
allocateauxiliary channel c2 device type disk;
allocateauxiliary channel c3 device type disk;
allocateauxiliary channel c4 device type disk;
allocateauxiliary channel c5 device type disk;
allocateauxiliary channel c6 device type disk;
allocateauxiliary channel c7 device type disk;
allocateauxiliary channel c8 device type disk;
duplicate database to dbclone3
backup location '/home/oracle/backup'
nofilenamecheck
db_file_name_convert '+DATA/orcl/datafile/example.257.978643425','/u01/app/oracle/oradata/dbclone3/example01.dbf','+DATA/orcl/datafile/users.265.978645015','/u01/app/oracle/oradata/dbclone3/users01.dbf','+DATA/orcl/datafile/undotbs1.259.978643423','/u01/app/oracle/oradata/dbclone3/undotbs01.dbf','+DATA/orcl/datafile/sysaux.258.978643425','/u01/app/oracle/oradata/dbclone3/sysaux01.dbf','+DATA/orcl/datafile/system.256.978643425','/u01/app/oracle/oradata/dbclone3/system01.dbf'
logfile
group 1 ('/u01/app/oracle/oradata/dbclone3/redo01a.log','/u01/app/oracle/oradata/dbclone3/redo01b.log') size 50M,
group 2 ('/u01/app/oracle/oradata/dbclone3/redo02a.log','/u01/app/oracle/oradata/dbclone3/redo02b.log') size 50M,
group 3 ('/u01/app/oracle/oradata/dbclone3/redo03a.log','/u01/app/oracle/oradata/dbclone3/redo03b.log') size 50M
spfile
set
control_files='/u01/app/oracle/oradata/dbclone3/control01.ctl','/u01/app/oracle/oradata/dbclone3/control02.ctl','/u01/app/oracle/oradata/dbclone3/control03.ctl'
set
audit_file_dest='/u01/app/oracle/admin/dbclone3/adump'
set
db_create_file_dest=''
set
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
;
}
在1Z0-052第18章/1Z0-053第9章之前，数据库里没有物理和逻辑坏块：
selectdepartment_id , rowid,substr(rowid,10,6) , dbms_rowid.rowid_block_number(rowid)from departments;RMAN备份的同时负责发现以下三个视图：
select * from v$database_block_corruption;
select * from v$copy_corruption;
select* from v$backup_corruption;
create tablespace tbslogical datafile size 10Mnologging;
create table hr.tlogical ( a varchar2(30), b number)
tablespace tbslogical;
create index hr.ilogical_a on hr.tlogical (a) ;
create index hr.ilogical_b on hr.tlogical(b);
insert into hr.tlogical values('backare',32285);
commit;
制造逻辑坏块的过程：
create tablespace tbslogical datafile size 10Mnologging;
create table hr.tlogical ( a varchar2(30), b number)
tablespace tbslogical;
create index hr.ilogical_a on hr.tlogical (a) ;
create index hr.ilogical_b on hr.tlogical(b);
insert into hr.tlogical values('backare',32285);
commit;
SQL> select* from hr.tlogical ;
A B
------------------------------ ----------
backare 32285
SQL> insert /*+ append */ into hr.tlogical select* from hr.tlogical ;
1 row created.
SQL> select* from hr.tlogical ;
select * from hr.tlogical
*
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
SQL> commit;
Commit complete.
SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from tlogical;
select a, b , dbms_rowid.rowid_block_number(rowid) from tlogical
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from hr.tlogical;
A B DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------ ---------- ------------------------------------
backare 32285 135
backare 32285 136
SQL> alter database datafile 6 offline;
Database altered.
SQL> alter database datafile 6 online;
alter database datafile 6 online
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '+DATA/orcl/datafile/tbslogical.268.978972513'
SQL> alter database create datafile 6 as new;
Database altered.
SQL> recover datafile 6;
ORA-00279: change 1887708 generated at 06/16/2018 16:33:52 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_94.337.978971647
ORA-00280: change 1887708 for thread 1 is in sequence #94
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1890411 generated at 06/16/2018 16:34:06 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_95.339.978972203
ORA-00280: change 1890411 for thread 1 is in sequence #95
ORA-00279: change 1897905 generated at 06/16/2018 16:34:27 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_96.338.978973541
ORA-00280: change 1897905 for thread 1 is in sequence #96
ORA-00279: change 1906255 generated at 06/16/2018 16:35:03 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_97.340.978972205
ORA-00280: change 1906255 for thread 1 is in sequence #97
ORA-00279: change 1933151 generated at 06/16/2018 16:43:23 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_98.341.978972277
ORA-00280: change 1933151 for thread 1 is in sequence #98
ORA-00279: change 1943929 generated at 06/16/2018 16:44:37 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_99.342.978972311
ORA-00280: change 1943929 for thread 1 is in sequence #99
ORA-00279: change 1961134 generated at 06/16/2018 16:45:10 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_100.343.978972319
ORA-00280: change 1961134 for thread 1 is in sequence #100
ORA-00279: change 1965454 generated at 06/16/2018 16:45:18 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_101.344.978972327
ORA-00280: change 1965454 for thread 1 is in sequence #101
ORA-00279: change 1970102 generated at 06/16/2018 16:45:26 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_102.345.978972333
ORA-00280: change 1970102 for thread 1 is in sequence #102
ORA-00279: change 1974963 generated at 06/16/2018 16:45:33 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_103.346.978972343
ORA-00280: change 1974963 for thread 1 is in sequence #103
ORA-00279: change 1990668 generated at 06/16/2018 16:45:43 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_104.347.978972431
ORA-00280: change 1990668 for thread 1 is in sequence #104
ORA-00279: change 2005567 generated at 06/16/2018 16:47:09 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_105.348.978972483
ORA-00280: change 2005567 for thread 1 is in sequence #105
ORA-00279: change 2024814 generated at 06/16/2018 16:48:02 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_106.349.978972493
ORA-00280: change 2024814 for thread 1 is in sequence #106
ORA-00279: change 2028975 generated at 06/16/2018 16:48:13 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_107.350.978972519
ORA-00280: change 2028975 for thread 1 is in sequence #107
ORA-00279: change 2033778 generated at 06/16/2018 16:48:39 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_108.351.978972537
ORA-00280: change 2033778 for thread 1 is in sequence #108
ORA-00279: change 2036872 generated at 06/16/2018 16:48:56 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_109.352.978972561
ORA-00280: change 2036872 for thread 1 is in sequence #109
ORA-00279: change 2044292 generated at 06/16/2018 16:49:21 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_110.353.978972591
ORA-00280: change 2044292 for thread 1 is in sequence #110
ORA-00279: change 2051545 generated at 06/16/2018 16:49:51 needed for thread 1
ORA-00289: suggestion :
+FRA/orcl/archivelog/2018_06_16/thread_1_seq_111.354.978972609
ORA-00280: change 2051545 for thread 1 is in sequence #111
Log applied.
Media recovery complete.
SQL> alter database datafile 6 online;
Database altered.
SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from hr.tlogical;
ERROR:
ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
ORA-01110: data file 6: '+DATA/orcl/datafile/tbslogical.267.978972737'
ORA-26040: Data block was loaded using the NOLOGGING option
no rows selected
SQL>
让RMAN去发现，并填充这3个corruption视图：
RMAN> backup tablespace tbslogical ;
Starting backup at 16-JUN-18
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/orcl/datafile/tbslogical.267.978972737
channel ORA_SBT_TAPE_1: starting piece 1 at 16-JUN-18
channel ORA_SBT_TAPE_1: finished piece 1 at 16-JUN-18
piece handle=1bt5js7i_1_1 tag=TAG20180616T165514 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
Finished backup at 16-JUN-18
Starting Control File and SPFILE Autobackup at 16-JUN-18
piece handle=c-1343950367-20180616-02 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 16-JUN-18
RMAN>
ADR也会反映事故：
关于MOS的视频：
**** Hidden Message *****
页:
[1]