Oracle (2k8r2) every backup rman errors

[Deni74]

Oracle 11, 2008r2 VM

VM:
/etc/pve/nodes/lab/qemu-server/300.conf
agent: 1
balloon: 1
boot: c
bootdisk: virtio0
cores: 4
cpu: host
ide3: NAS-MCA:iso/virtio-win-0.1.141.iso,media=cdrom,size=309208K
localtime: 1
memory: 20480
name: ariadna
net0: virtio=3A:62:34:34:32:35,bridge=vmbr0
numa: 0
onboot: 1
ostype: win7
protection: 1
smbios1: uuid=c1d2d9dd-ab73-4b7a-b449-4ba92ac8ac3f
sockets: 2
virtio0: local-lvm2:vm-300-disk-1,size=100G
virtio1: local-lvm2:vm-300-disk-2,size=150G
virtio2: local-lvm2:vm-300-disk-3,size=170G

STORAGE:
lvmthin: local-lvm2
<------>thinpool array0
<------>vgname local-lvm2
<------>content rootdir,images

RMAN cmd:
%ORA_HOME%\bin\rman.exe target sys/oracle@med; < task_backup.script

TASK_BACKUP.SCRIPT:
run {
configure retention policy to redundancy 1;
configure controlfile autobackup on;
crosscheck archivelog all;
crosscheck backup;
delete force noprompt expired backup;
delete force noprompt expired archivelog all;
backup database plus archivelog delete all input;
delete force noprompt obsolete;
}

RESULT:
channel ORA_DISK_1: starting piece 1 at 10-DEC-17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/10/2017 07:20:31
ORA-19566: exceeded limit of 0 corrupt blocks for file D:\DATAFILES\MED\UNDOTBS01.DBF
RMAN>
Recovery Manager complete.

.... and similar results (screenshots).


I don't know features of Oracle under VM. Some additional settings are perhaps necessary?

Thank you.

 

[miha_r]

Привет, я так понимаю это ЛИС Ариадна?
Колеги значит. А какая МСЧ?

 

[Deni74]

Привет, ага, они самые - коллеги ) МСЧ?

Server:
CPU usage
9.32% of 16 CPU(s)
IO delay
0.00%
Load average
0.96,0.91,0.94
RAM usage
69.81% (24.67 GiB of 35.34 GiB)
KSM sharing
0 B
HD space(root)
3.62% (2.38 GiB of 65.69 GiB)
SWAP usage
5.27% (431.77 MiB of 8.00 GiB)
CPU(s)
16 x Intel(R) Xeon(R) CPU E5540 @ 2.53GHz (2 Sockets)
Kernel Version Linux 4.13.8-3-pve #1 SMP PVE 4.13.8-30 (Tue, 5 Dec 2017 13:06:48 +0100)
PVE Manager Version pve-manager/5.1-38/1e9bc777

Storage: lvmthin: local-lvm2 - 10 SAS Unit 10-HW Raid 9750-8i

Брегис утверждает (Олег), что с виртуалкой никак, а я думаю дело или в настройках Оракла или особенностях. Беда в том, что в Оракле я 0 полный.

 

[Deni74]

Dump working without errors

%ORA_HOME%\BIN\exp.exe 'sys/oracle@med as sysdba' FILE="%DUMP_PATH%\dmp\%DUMP_FILE%.dmp" LOG="%DUMP_PATH%\dmp\%DUMP_FILE%.log" FULL=Y FEEDBACK=1000 COMPRESS=Y STATISTICS=NONE

 

[LnxBil]

English, please.

What about a scandisk/chkdsk of the disk? What about Windows event log? Normally, block errors occur only on "real" block errors, so maybe Windows has a problem with the underlying storage backend.

 

[Deni74]

I have information that it's Oracle (windows version) problem in any virtual environment. I don't think so, but I don't know Oracle.

Only Oracle (RMAN) errors (win events clear, filesystem OK). Storage backend 9750-8i - OK

I started this VM on other hosts (Proxmox 3.4, Proxmox 4.1) - all most too, rman error.
Copying of UNDOTBS01.DBF (and any DB file) finishes without errors.

 

[LnxBil]

You really don't need the undo tablespace, but the error could - of course - occur in any other tablespace. If you have a block error in that tablespace, just add a new undo tablespace and drop the old one.

In general, Oracle runs also inside virtual machines without any problem, including RMAN. I have no production database in PVE, yet I maintained some Windows-based Oracle databases over the years and we never had problems with rman in virtual environments. We run at least 20 Oracle 11 databases in virtualized environments under Linux (mainly Oracle Linux), yet no one in PVE.

 

[miha_r]

ЦМСЧ №31, у нас тоже ЛИС Ариадна, правда не в виртуалке пока.
Давай емаил в личку что ли, у меня в отделе есть в оракле разбирающиеся, может что поможем.

 

[tom]

ЦМСЧ №31, у нас тоже ЛИС Ариадна, правда не в виртуалке пока.
Давай емаил в личку что ли, у меня в отделе есть в оракле разбирающиеся, может что поможем.

This is an English forum only.