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

nkoocmlb  于 2023-06-05  发布在  Oracle
关注(0)|答案(1)|浏览(146)

请建议如何修改参数,以便我可以将文件写入指定的目录和格式。
下面是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.159\CF_%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.159\recovery\';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  "SBT_LIBRARY=D:\ODB11GR2\opc\lib\oraopc.dll, SBT_PARMS=(OPC_PFILE=D:\ODB11GR2\opc\config\opc.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.159\RMAN\SNAPSHOT\SNCFORCL.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:\ODB11GR2\product\11.2.0\dbhome_1
set PATH=%ORACLE_HOME%/bin;%PATH%
echo "RMAN start at `date "+%F %H:M:%S"`" >E:\RMAN_Backup\logs\daily-rman-`date +%F`.log

D:\ODB11GR2\product\11.2.0\dbhome_1\bin\rman target=/ log=E:\RMAN_Backup\logs\daily-rman-%datetimeF%.log append cmdfile=E:\RMAN_Backup\scripts\daily_full_disk.rman

echo "RMAN finished at `date "+%F H:%M:%S"`" >> E:\RMAN_Backup\logs\daily-rman-%date:~4,2%-%date:~7,2%.log

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

j8ag8udp

j8ag8udp1#

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

rman target /
rman>backup database format '\10.20.1.159\recovery\Full_DB_%U';

如果失败,请尝试:

rman>backup database format '\\10.20.1.159\recovery\Full_DB_%U';

如果其中一个工作,然后更新以下与“一个反斜杠”或“两个反斜杠”-拿起一个可行的!

backup database plus archivelog;

进入:

backup database format '\10.20.1.159\recovery\Full_DB_%U';
backup archivelog all delete input format '\10.20.1.159\recovery\archive_%U';

相关问题