课程第38次（2017-01-13星期五）

botang · 发表于 2017-1-14 12:23:49

上完1Z0-053第20章（克隆数据库）
（052共19章，053共21章，063多租户共9章，49-24）

ACTIVE:本机ASM到ASM：

run {
duplicate target database to dbtest
from active database
nofilenamecheck
spfile
set
control_files='+DATA','+FRA'
set
db_file_name_convert='+DATA/orcl/','+DATA/dbtest'
set
log_file_name_convert='+DATA/orcl','+DATA/dbtest','+FRA/orcl','+FRA/dbtest'
set
audit_file_dest='/u01/app/oracle/admin/dbtest/adump';
}

复制代码

ACTIVE:两机ASM到文件系统：

run{
duplicate target database to db11g
from active database
nofilenamecheck
spfile
set
control_files='/u01/app/oracle/oradata/db11g/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.265.816169651','/u01/app/oracle/oradata/db11g/example01.dbf','+DATA/orcl/datafile/users.259.816169553','/u01/app/oracle/oradata/db11g/users01.dbf','+DATA/orcl/datafile/undotbs1.258.816169553','/u01/app/oracle/oradata/db11g/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.816169553','/u01/app/oracle/oradata/db11g/sysaux01.dbf','+DATA/orcl/datafile/system.256.816169553','/u01/app/oracle/oradata/db11g/system01.dbf'
set
log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.816169635','/u01/app/oracle/oradata/db11g/redo01a.log','+FRA/orcl/onlinelog/group_1.257.816169637','/u01/app/oracle/oradata/db11g/redo01b.log','+DATA/orcl/onlinelog/group_3.263.816169641','/u01/app/oracle/oradata/db11g/redo03a.log','+FRA/orcl/onlinelog/group_3.259.816169641','/u01/app/oracle/oradata/db11g/redo03b.log','+DATA/orcl/onlinelog/group_2.262.816169639','/u01/app/oracle/oradata/db11g/redo02a.log','+FRA/orcl/onlinelog/group_2.258.816169639','/u01/app/oracle/oradata/db11g/redo02b.log';
set
audit_file_dest='/u01/app/oracle/admin/db11g/adump'
set
db_create_file_dest=''
set
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
}

复制代码

为了BACKUP LOCATION，在 TARGET上备份：

--源头把备份优化关掉，或用force语法
run {
allocate channel c1 device type disk format '/home/oracle/backup/%U';
allocate channel c2 device type disk format '/home/oracle/backup/%U';
allocate channel c3 device type disk format '/home/oracle/backup/%U';
allocate channel c4 device type disk format '/home/oracle/backup/%U';
allocate channel c5 device type disk format '/home/oracle/backup/%U';
allocate channel c6 device type disk format '/home/oracle/backup/%U';
allocate channel c7 device type disk format '/home/oracle/backup/%U';
allocate channel c8 device type disk format '/home/oracle/backup/%U';
backup database plus archivelog force;
backup spfile;
backup current controlfile;
}

复制代码

BACKUPLOCATION:两机ASM到文件系统：

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/mydb/control02.ctl','/u01/app/oracle/oradata/mydb/control03.ctl'
set
db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/mydb/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/mydb/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/mydb/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/mydb/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/mydb/system01.dbf'
set
log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/mydb/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/mydb/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/mydb/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/mydb/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/mydb/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/mydb/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'
}

复制代码

另一种语法（书上出现过一些，不一定要使用）：

run {
allocate auxiliary channel c1 device type disk;
allocate auxiliary channel c2 device type disk;
allocate auxiliary channel c3 device type disk;
allocate auxiliary channel c4 device type disk;
allocate auxiliary channel c5 device type disk;
allocate auxiliary channel c6 device type disk;
allocate auxiliary channel c7 device type disk;
allocate auxiliary channel c8 device type disk;
duplicate database to mydb2
backup location '/home/oracle/backup'
nofilenamecheck
db_file_name_convert '+DATA/orcl/datafile','/u01/app/oracle/oradata/mydb2'
logfile
group 1 ('/u01/app/oracle/oradata/mydb2/redo01.log') size 50M,
group 2 ('/u01/app/oracle/oradata/mydb2/redo02.log') size 50M,
group 3 ('/u01/app/oracle/oradata/mydb2/redo03.log') size 50M;
spfile
parameter_value_convert '+DATA','/u01/app/oracle/oradata/mydb2','+FRA','/u01/app/oracle/flash_recovery_area','/u01/app/oracle/admin/orcl/adump','/u01/app/oracle/admin/mydb2/adump'
set
control_files='/u01/app/oracle/oradata/mydb2/control01.ctl','/u01/app/oracle/oradata/mydb2/control02.ctl','/u01/app/oracle/oradata/mydb2/control03.ctl';
}

复制代码

lujiaguai · 发表于 2017-1-23 14:50:11

本帖最后由 lujiaguai 于 2017-1-23 14:54 编辑

--源头把备份优化关掉，或用force语法

run {
allocate channel  c1 device type disk format '/home/oracle/backup/%U';
allocate channel  c2 device type disk format '/home/oracle/backup/%U';
allocate channel  c3 device type disk format '/home/oracle/backup/%U';
allocate channel  c4 device type disk format '/home/oracle/backup/%U';
allocate channel  c5 device type disk format '/home/oracle/backup/%U';
allocate channel  c6 device type disk format '/home/oracle/backup/%U';
allocate channel  c7 device type disk format '/home/oracle/backup/%U';
allocate channel  c8 device type disk format '/home/oracle/backup/%U';
backup database plus archivelog force;
backup spfile;
backup current controlfile;
}

记得唐sir说过，这个最后都要release channel
真的还是假的？

另外%U备出来是类似这样的文件名：/9krqohvp_1_1
这样的文件名该如何解读？
还有其他类似 %F之类一大堆写法，试过备出来依然看不懂
RMAN> backup tablespace users format '/backup/database/%U';
Starting backup at 2017-01-23:14:51:34
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=563 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=12 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=564 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1107 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=1667 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=14 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=558 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1115 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.930714617
channel ORA_DISK_1: starting piece 1 at 2017-01-23:14:51:37
channel ORA_DISK_1: finished piece 1 at 2017-01-23:14:52:02
piece handle=/backup/database/9krqohvp_1_1 tag=TAG20170123T145137 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2017-01-23:14:52:02
Starting Control File and SPFILE Autobackup at 2017-01-23:14:52:02
piece handle=/backup/database/controlfile_c-1458495430-20170123-01 comment=NONE
Finished Control File and SPFILE Autobackup at 2017-01-23:14:52:03

botang · 发表于 2017-1-23 16:03:15

lujiaguai 发表于 2017-1-23 14:50
--源头把备份优化关掉，或用force语法

run {

也可以这样：

RMAN> run {
2> allocate channel c1 device type disk format '/home/oracle/%d_%N_%U';
3> backup tablespace users;
4> release channel c1;
5> }
allocated channel: c1
channel c1: SID=930 device type=DISK
Starting backup at 23-JAN-17
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/winorcl/datafile/users.257.933359019
channel c1: starting piece 1 at 23-JAN-17
channel c1: finished piece 1 at 23-JAN-17
piece handle=/home/oracle/WINORCL_USERS_05rqom4r_1_1 tag=TAG20170123T160235 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 23-JAN-17
released channel: c1

复制代码

lujiaguai · 发表于 2017-1-24 10:36:30

本帖最后由 lujiaguai 于 2017-1-24 10:38 编辑

唐老师，反复尝试过
如果备份表空间用 %d_%U_%Y%M%D_U%，结果是最明确的，比如： orcl_sysaux_20170124_********
如果备份数据库用 %d_%I_%Y%M%D_U%，结果也比较明确，比如： orcl_dbid_20170102_****

但是如果备份的时候 plus archivelog ,上面很明确的文件名就全部不行了:%d，%Y，%M，%D，%I
只剩下U%可以用，但是备出来的文件名确看不懂，这个问题是不是无解了？
只能通过list backup ，去看备份的时间，表空间之类的?