RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:/backup/';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'e:/backup/';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;下面是dos批处理:
set oracle_sid=orcl
rman target / msglog E:\oracleScript\backup\logs\úte:~0,10%.log cmdfile=E:\oracleScript\backup\database_backup_orcl.rman 运行后提示:
rman-00557:could not open msglog "E:\oracleScript\backup\logs\úte:~0,10\oracleScript\backup\database_backup_orcl.rman "请问这是为什么呢?我该怎么样改一下?
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:/backup/';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT 'e:/backup/';
BACKUP DATABASE SKIP INACCESSIBLE FILESPERSET 10
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;下面是dos批处理:
set oracle_sid=orcl
rman target / msglog E:\oracleScript\backup\logs\úte:~0,10%.log cmdfile=E:\oracleScript\backup\database_backup_orcl.rman 运行后提示:
rman-00557:could not open msglog "E:\oracleScript\backup\logs\úte:~0,10\oracleScript\backup\database_backup_orcl.rman "请问这是为什么呢?我该怎么样改一下?
没玩过rman
rman target / msglog E:\oracleScript\backup\logs\úte:~0,10%.log cmdfile=E:\oracleScript\backup\database_backup_orcl.rman 应该是这个吧,取当前日期%DATE:~0,10%
rman target / msglog E:\oracleScript\backup\logs\%DATE:~0,10%.log cmdfile=E:\oracleScript\backup\database_backup_orcl.rman
rman>2>3>4>5>6>7>8>9>10>11>12>13>14>15>
这是什么意思呢?E:\oracleScript\backup\logs 这个文件夹里面多了一个2010-12-04.log的日志,日志里面有一个错误的提示:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 12/04/2010 12:28:41
RMAN-06492: controlfile autobackup format "e:/backup/" must specify a "%F" format specifier
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:/backup/%F';控制文件的自动备份文件必须遵循 %F 格式:c-IIIIIIIIII-YYYYMMDD-QQ (IIIIIIIIII 为 dbid,YYYYMMDD 为年月日,QQ 为 16 进制序号)。
这样在没有控制文件的情况下,rman 也可以从自动备份中还原控制文件。
rman-00557:could not open msglog "E:\oracleScript\backup\logs\úte:~0,10\oracleScript\backup\database_backup_orcl.rman "
找这个目录
rman>2>3>4>5>6>7>8>9>10>11>12>13>14>15>
这是什么意思呢?
可能虽然你调整为归档模式了,但原先的参数是手动归档,所以