为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
SQL> BACKUP ARCHIVELOG ALL backupset '/dm8/data/DAMENG/bak/arc_all';
操作已执行
已用时间: 00:00:01.048. 执行号:73613.
SQL> select ARCH_LSN, CLSN, PATH from V$ARCH_FILE d ;
ARCH_LSN CLSN PATH
-------------------- -------------------- --------------------------------------------------------------
488718 490196 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-20_10-27-49.log
490196 513982 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-20_10-28-26.log
513983 553661 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-20_10-36-13.log
553661 3671415 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-20_11-13-14.log
3671416 4443655 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_05-10-12.log
4443656 4469931 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_09-55-00.log
4469932 4470381 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_10-21-31.log
4470381 4471457 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_10-23-19.log
4471458 4471479 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_10-27-54.log
4471479 4523156 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_10-28-01.log
4523157 5299743 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_10-55-35.log
5299743 5341130 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-27-38.log
5341130 5341645 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-35-54.log
5341645 5381018 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-38-05.log
5381018 5381069 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-40-08.log
5381069 5381106 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-40-20.log
5381107 5381153 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-40-31.log
5381153 5382009 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-40-42.log
5382009 5382010 /dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-21_14-44-17.log
19 rows got
已用时间: 62.028(毫秒). 执行号:73614.
SQL>
SQL>
SQL> select file_name,D.BEGIN_LSN,D.END_LSN from V$BACKUPSET_ARCH d where d.BACKUPpath='/dm8/data/DAMENG/bak/arc_all';
FILE_NAME BEGIN_LSN END_LSN
-------------------------------------------------------------- -------------------- --------------------
/dm8/arch/ARCHIVE_LOCAL1_0x4A76B92C[0]_2021-10-20_10-27-49.log 488718 490196
已用时间: 122.128(毫秒). 执行号:73616.
修复一下归档,在rman里面执行:repair archivelog database ‘/dm8/data/DAMENG/dm.ini’
你查下数据库版本是多少select id_code
谁能帮我测试一下呢,我在麒麟上测试也是报错:
SQL> select id_code;
LINEID ID_CODE
---------- ---------------------------------------
1 1-2-18-21.06.07-141116-10013-ENT Pack2
used time: 2.129(ms). Execute id is 304.
难道是我安装问题吗,求解
在这个版本上测试,没有问题
SQL> select id_code;
id_code
----------------------------------
1-1-144-20.11.06-129436-ENT Pack1
已用时间: 47.580(毫秒). 执行号:803.
我这个版本也有同样问题,只能备份头一个日志
大神能回答我的问题吗,如何备份所有的归档文件,为啥我这里
backup archivelog all database '/dm8/data/DAMENG/dm.ini';
不能备份所有的归档文件呢?