rman支持普通用户远程备份吗?
1)具备dba或者sysdba权限的用户就可以使用rman对数据库进行备份。
2)rman的backup database只能够本地备份,备份的路径设置在CONFIGURE DEFAULT DEVICE TYPE TO DISK;中;即,使用rman备份的路径是由rman的设备路径控制,用机器B rman 机器A,备份也是在机器A上的,不会再机器B上。
3)如果想在机器B上,可以使用copy的方式+auxiliary。
4)backup as copy是物理文件的复制,backup会扫描物理块,跳过空块。
测试记录如下: rman target dbamonitor/dbamonitor_1@192.168.10.82:1521/ser_zyt BACKUP DATABASE; rman target dbamonitor/dbamonitor_1@192.168.10.82:1521/ser_zyt auxiliary sys/oracle@192.168.10.66:1521/test11g BACKUP AS COPY DEVICE TYPE DISK DATABASE auxiliary format '/picclife/backup/%f'; backup as copy archivelog sequence 85 thread 2 auxiliary format '/picclife/backup/%U';
rman target dbamonitor/dbamonitor_1@192.168.10.82:1521/ser_zyt RMAN> BACKUP DATABASE; Starting backup at 17-NOV-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=43 instance=zytrac2 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=00001 name=+DATA/zytrac/datafile/system.256.1058372141 input datafile file number=00002 name=+DATA/zytrac/datafile/sysaux.266.1058372141 input datafile file number=00005 name=+DATA/zytrac/datafile/example.265.1058372261 input datafile file number=00003 name=+DATA/zytrac/datafile/undotbs1.257.1058372141 input datafile file number=00008 name=+DATA/zytrac/datafile/tbs_dbamonitor.276.1107907173 input datafile file number=00007 name=+DATA/zytrac/datafile/undotbs3.396.1060794123 input datafile file number=00006 name=+DATA/zytrac/datafile/undotbs2.269.1058372579 input datafile file number=00004 name=+DATA/zytrac/datafile/users.272.1058372141 channel ORA_DISK_1: starting piece 1 at 08-AUG-22 channel ORA_DISK_1: finished piece 1 at 08-AUG-22 piece handle=+DATA/zytrac/backupset/2022_08_08/nnndf0_tag20220808t203841_0.393.1112215121 tag=TAG20220808T203841 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 08-AUG-22 channel ORA_DISK_1: finished piece 1 at 08-AUG-22 piece handle=+DATA/zytrac/backupset/2022_08_08/ncsnf0_tag20220808t203841_0.288.1112215201 tag=TAG20220808T203841 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 17-NOV-21 RMAN> RMAN> RMAN> RMAN> rman target dbamonitor/dbamonitor_1@192.168.10.82:1521/ser_zyt auxiliary sys/oracle@192.168.10.66:1521/test11g RMAN> BACKUP AS COPY DEVICE TYPE DISK DATABASE auxiliary format '/picclife/backup/%f'; Starting backup at 17-NOV-21 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=+DATA/zytrac/datafile/system.256.1058372141 output file name=/picclife/backup/1 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=+DATA/zytrac/datafile/sysaux.266.1058372141 output file name=/picclife/backup/2 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=+DATA/zytrac/datafile/example.265.1058372261 output file name=/picclife/backup/5 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=+DATA/zytrac/datafile/undotbs1.257.1058372141 output file name=/picclife/backup/3 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00008 name=+DATA/zytrac/datafile/tbs_dbamonitor.276.1107907173 output file name=/picclife/backup/8 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00007 name=+DATA/zytrac/datafile/undotbs3.396.1060794123 output file name=/picclife/backup/7 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy input datafile file number=00006 name=+DATA/zytrac/datafile/undotbs2.269.1058372579 output file name=/picclife/backup/6 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=+DATA/zytrac/datafile/users.272.1058372141 output file name=/picclife/backup/4 tag=TAG20220808T205510 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 17-NOV-21 RMAN> exit RMAN> backup as copy archivelog sequence 85 thread 2 auxiliary format '/picclife/backup/%U'; Starting backup at 17-NOV-21 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=2 sequence=85 RECID=98 STAMP=1112217007 output file name=/picclife/backup/arch_D-ZYTRAC_id-3628924225_S-85_T-2_A-3628911678_1214m5kr RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03 Finished backup at 17-NOV-21 RMAN>
参考:Oracle? Database Backup and Recovery User's Guide --> 9 Backing Up the Database