Erreur lors de la sauvegarde BD avec Orace11g
Résolu
rexhab
Messages postés
13
Date d'inscription
Statut
Membre
Dernière intervention
-
rexhab Messages postés 13 Date d'inscription Statut Membre Dernière intervention -
rexhab Messages postés 13 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
Je me trouve dans Oracle Linux 6, Oracle 11g XE.
Alors que hier cela marchait parfaitement, j'ai voulu il y a quelques instants effectuer une sauvegarde de ma BD et voila l'erreur qui est survenue. Que dois-je faire ?
XE Backup Log
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Sep 20 13:11:26 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2663440029)
RMAN>
echo set on
RMAN> configure retention policy to redundancy 2;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
RMAN> configure controlfile autobackup format for device type disk clear;
RMAN configuration parameters are successfully reset to default value
RMAN> configure controlfile autobackup on;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> sql "create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile";
sql statement: create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile
RMAN> backup as backupset device type disk database;
Starting backup at 20-SEP-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/XE/sysaux.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/XE/system.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/XE/users.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/XE/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 20-SEP-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/20/2012 13:11:55
ORA-19502: write error on file "/u01/app/oracle/fast_recovery_area/XE/backupset/2012_09_20/o1_mf_nnndf_TAG20120920T131130_85oyh52s_.bkp", block number 76544 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 76544
Additional information: 749568
RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
no obsolete backups found
RMAN>
Recovery Manager complete.
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Sep 20 13:11:58 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2663440029)
RMAN>
using target database control file instead of recovery catalog
sql statement: alter system archive log current
RMAN>
Recovery Manager complete.
RMAN error: See log for details.
Je me trouve dans Oracle Linux 6, Oracle 11g XE.
Alors que hier cela marchait parfaitement, j'ai voulu il y a quelques instants effectuer une sauvegarde de ma BD et voila l'erreur qui est survenue. Que dois-je faire ?
XE Backup Log
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Sep 20 13:11:26 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2663440029)
RMAN>
echo set on
RMAN> configure retention policy to redundancy 2;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
RMAN> configure controlfile autobackup format for device type disk clear;
RMAN configuration parameters are successfully reset to default value
RMAN> configure controlfile autobackup on;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> sql "create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile";
sql statement: create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile
RMAN> backup as backupset device type disk database;
Starting backup at 20-SEP-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/XE/sysaux.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/XE/system.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/XE/users.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/XE/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 20-SEP-12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/20/2012 13:11:55
ORA-19502: write error on file "/u01/app/oracle/fast_recovery_area/XE/backupset/2012_09_20/o1_mf_nnndf_TAG20120920T131130_85oyh52s_.bkp", block number 76544 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 76544
Additional information: 749568
RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
no obsolete backups found
RMAN>
Recovery Manager complete.
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Sep 20 13:11:58 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2663440029)
RMAN>
using target database control file instead of recovery catalog
sql statement: alter system archive log current
RMAN>
Recovery Manager complete.
RMAN error: See log for details.
A voir également:
- Erreur lors de la sauvegarde BD avec Orace11g
- Logiciel de sauvegarde gratuit - Guide
- Sauvegarde android - Guide
- Iptv erreur de lecture - Forum TV & Vidéo
- Effacer sauvegarde pokemon y ✓ - Forum DS
- Télécharger bd pdf gratuit sans inscription ✓ - Forum Téléchargement