However this computer gets rebooted everyday and is starting up just fine
everytime.
On Thu, Aug 16, 2018 at 11:21 AM Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
That is what I am wondering. Is the only option to recovery database from
controlfile trace backup?
On Thu, Aug 16, 2018 at 10:32 AM Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>
wrote:
Could the control file itself be corrupted?
Thanks everyone for your input. I ran a show all it listed that file asJeff Chirco <backseatdba@xxxxxxxxx> 8/16/18 1:21 PM >>>
the snapshot controlfile. I altered the name to a new file and ran a backup
spfile. Unfortunately I am still getting a corruption error.
RMAN-03009: failure of Control File and SPFILE Autobackup command on
ORA_DISK_1
channel at 08/16/2018 10:19:52
ORA-19599: block number 10014 is corrupt in control file
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE1.ORA
On Wed, Aug 15, 2018 at 11:00 PM LK <lkaing@xxxxxxxxx> wrote:
If it's the snapshot controlfile you can simply point it to a new
location and name, eg:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\DBA\SNAPCF_XE.F';
And take a backup - this should genereate a new snapshot controlfile:
RMAN> backup spfile;
I'd also get the sysadmin to do hardware/os/firmware check of the server
in case this is just the tip of the iceberg... is there corruption in the
underlying hardware/storage/firmware etc.
On Thu, Aug 16, 2018 at 2:22 PM, Tony <dedba@xxxxxxxxxx> wrote:
Hi Jeff,
You could try configuring a new name for the snapshot controlfile. To
get the command, just say
RMAN> show all;
It will be in de output. That should also confirm that it is indeed the
snapshot ctrl file.
Cheers,
Tony
On 16 August 2018 9:21:37 am AEST, Jeff Chirco <backseatdba@xxxxxxxxx>
wrote:
I have an 10g XE database that is failing during rman backup.
ORA-19624: operation failed, retry possible
ORA-19599: block number 10014 is corrupt in control file
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA
I am not sure what SNCFXE.ORA is but I believe it is some snapshot
control file backup. Anybody know how to recover for this? Do I need to do
a full recovery from controlfile trace?
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.