我准备搭建一套oracle 11g 的dg。主库是AIX上的双节点RAC,备库是虚拟机上的linux单实例。
主库上使用rman备份了全库、归档、控制文件,命令如下:
全库备份:backup as compressed backupset database format='/backup/rmanbak/bak/${ORACLE_SID}_%Y-%M-%D_%U.full';
归档备份:backup as compressed backupset archivelog all format='/backup/rmanbak/bak/${ORACLE_SID}_%Y-%M-%D_%U.arc';
控制文件备份:backup device type disk format '/backup/rmanbak/standby_%U.ctl' current controlfile for standby;
查看主库上备份的控制文件的权限:
# ls -l /backup/rmanbak
-rw-r----- 1 oracle asmadmin 24903680 Mar 24 15:43 standby_ff3l5kkb_1_1.ctl
使用sftp传输备份到备库,赋权
chown -R oracle:oinstall /data/rmanbak
查看备库上的备份的权限:
[root@mdmdb rmanbak]# ls -l /data/rmanbak/
-rw-r--r-- 1 oracle oinstall 24903680 Mar 24 15:43 standby_ff3l5kkb_1_1.ctl
备库使用rman恢复控制文件:
[oracle@mdmdb rmanbak]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Mar 25 17:55:10 2025
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 1157628808 bytes
Database Buffers 3103784960 bytes
Redo Buffers 12107776 bytes
RMAN> restore standby controlfile from '/data/rmanbak/standby_ff3l5kkb_1_1.ctl';
Starting restore at 2025-03-25 17:55:31
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=385 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/25/2025 17:55:31
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
在主库上备份的文件都是 asmadmin组的,备库上没有这个组,我在备库新建了这个组并把oracle用户加入进去,然后授权控制文件的备份为oracle:asmadmin,再恢复依然报RMAN-06172:
不知道到底是哪里的问题,希望能得到大神的指点