我想将数据库备份到共享驱动器10.20.1.159,但RMAN没有使用我的配置参数



请建议如何修复参数,以便我可以在指定的目录和格式中写入文件

下面是RMAN SHOW ALL

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '10.20.1.159CF_%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '10.20.1.159recovery';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=D:ODB11GR2opcliboraopc.dll, SBT_PARMS=(OPC_PFILE=D:ODB11GR2opcconfigopc.ora)";
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '10.20.1.159RMANSNAPSHOTSNCFORCL.ORA';

这是我正在运行的脚本:

RUN
{
crosscheck archivelog all;
ALLOCATE CHANNEL ch01 TYPE DISK;
backup database plus archivelog;
crosscheck backup;
RELEASE CHANNEL ch01;
}

这是我的启动文件:

set ORACLE_SID=orcl
set ORACLE_HOME=D:ODB11GR2product11.2.0dbhome_1
set PATH=%ORACLE_HOME%/bin;%PATH%
echo "RMAN start at `date "+%F %H:M:%S"`" >E:RMAN_Backuplogsdaily-rman-`date +%F`.log
D:ODB11GR2product11.2.0dbhome_1binrman target=/ log=E:RMAN_Backuplogsdaily-rman-%datetimeF%.log append cmdfile=E:RMAN_Backupscriptsdaily_full_disk.rman
echo "RMAN finished at `date "+%F H:%M:%S"`" >> E:RMAN_Backuplogsdaily-rman-%date:~4,2%-%date:~7,2%.log

请建议如何修复参数,以便我可以将文件写入指定的目录和所需的格式

步骤01:测试我们是否可以驱动到外部驱动器

rman target /
rman>backup database format '10.20.1.159recoveryFull_DB_%U';

如果失败,请尝试:

rman>backup database format '\10.20.1.159recoveryFull_DB_%U';

如果它们中的一个成功,则用";一个后斜杠";或";两个后斜杠"-拿起那个可行的!

backup database plus archivelog; 

进入:

backup database format '10.20.1.159recoveryFull_DB_%U';
backup archivelog all delete input format '10.20.1.159recoveryarchive_%U';

最新更新