Ola galera o Oracle Database 12c acaba de ser lancado.Para quem se interessar, segue os links:OTN:Oracle Database 12c (12.10.1) - Linux x86-64Oracle Database 12c (12.10.1) - Solaris SPARC64Oracle Database 12c (12.10.1) - Solaris x86-64e-Delivery:Oracle Database 12c (12.10.1) - Linux x86-64Oracle Database 12c (12.10.1) - Solaris SPARC64Oracle Database 12c (12.10.1) - Solaris x86-64Para quem quiser saber mais sobre o Oracle Database 12c:http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlE que venham os novos desafios e novas VMS..Emerson MartinsDBA Oracle Ola pessoal.Hoje irei falar sobre um erro "ORA" que recebi durante um backup full para migracao de um servidor para outro em um cliente.Os nomes dos datafiles e outros arquivos foram alterados para garantir a confidencialidade do ambiente do cliente.O processo era simples migrar uma base de dados em NOARCHIVELOG para outro servidor usando o Recovery Manager.ORA-19502: write error on file "C:\U01\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\02O4LT5M_1_1", block number 783744 (block size=8192)Segue saida de LOG do RMAN:Recovery Manager: Release 11.2.0.2.0 - Production on Sat Mar 16 12:44:23 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connected to target database: PROD (DBID=190803984, not open)using target database control file instead of recovery catalogRMAN> shutdown immediate;2> startup mount;3> 4> RUN {5> ALLOCATE CHANNEL ch00 TYPE disk ;6> BACKUP database SKIP INACCESSIBLE 7> TAG cold_db_bk_level0 8> FILESPERSET 59> # recommended format10> FORMAT 'F:\PROD\backupset\cold_bk_%s_%p_%t' DATABASE tag = 'FULL-DB';11> RELEASE CHANNEL ch00;12> ALLOCATE CHANNEL ch00 TYPE disk;13> BACKUP14> # recommended format15> FORMAT 'F:\PROD\backupset\cold_cntrl_%s_%p_%t' CURRENT CONTROLFILE tag='CTRF';16> RELEASE CHANNEL ch00;17> }18> 19> alter database open;20> database dismountedOracle instance shut downconnected to target database (not started)Oracle instance starteddatabase mountedTotal System Global Area 4476211200 bytesFixed Size 2260512 bytesVariable Size 3422552544 bytesDatabase Buffers 1040187392 bytesRedo Buffers 11210752 bytesallocated channel: ch00channel ch00: SID=1878 device type=DISKStarting backup at 16-MAR-2013 12:44:37channel ch00: starting full datafile backup setchannel ch00: specifying datafile(s) in backup setinput datafile file number=00001 name=C:\U02\APP\ORACLE\ORADATA\PROD\SYSTEM01.DBFinput datafile file number=00006 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS01.DBFinput datafile file number=00007 name=C:\U02\APP\ORACLE\ORADATA\PROD\INDICES01.DBFinput datafile file number=00014 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS02.DBFinput datafile file number=00015 name=C:\U02\APP\ORACLE\ORADATA\PROD\SYSTEM02.DBFinput datafile file number=00012 name=C:\U02\APP\ORACLE\ORADATA\PROD\HML01.DBFinput datafile file number=00005 name=C:\U02\APP\ORACLE\ORADATA\PROD\AUXDADOS.DBFinput datafile file number=00019 name=C:\U01\APP\ORACLE\ORADATA\PROD\DADOS05.DBFinput datafile file number=00020 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS04.DBFinput datafile file number=00021 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS03.DBFinput datafile file number=00016 name=C:\U02\APP\ORACLE\ORADATA\PROD\INDICES02.DBFinput datafile file number=00003 name=C:\U02\APP\ORACLE\ORADATA\PROD\UNDOTBS01.DBFinput datafile file number=00002 name=C:\U02\APP\ORACLE\ORADATA\PROD\SYSAUX01.DBFinput datafile file number=00017 name=C:\U02\APP\ORACLE\ORADATA\PROD\INDICES03.DBFinput datafile file number=00018 name=C:\U02\APP\ORACLE\ORADATA\PROD\INDICES04.DBFinput datafile file number=00008 name=C:\U02\APP\ORACLE\ORADATA\PROD\DEVDADOS.DBFinput datafile file number=00011 name=C:\U02\APP\ORACLE\ORADATA\PROD\SAMINDICES01.DBFinput datafile file number=00009 name=C:\U02\APP\ORACLE\ORADATA\PROD\DEVINDICES01.DBFinput datafile file number=00010 name=C:\U02\APP\ORACLE\ORADATA\PROD\HMLDADOS01.DBFinput datafile file number=00013 name=C:\U02\APP\ORACLE\ORADATA\PROD\PSI_MEGA.DBFinput datafile file number=00004 name=C:\U02\APP\ORACLE\ORADATA\PROD\USERS01.DBFinput datafile file number=00022 name=C:\U01\APP\ORACLE\ORADATA\PROD\DADOS06.DBFinput datafile file number=00023 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS07.DBFinput datafile file number=00024 name=C:\U02\APP\ORACLE\ORADATA\PROD\DADOS08.DBFchannel ch00: starting piece 1 at 16-MAR-2013 12:44:38released channel: ch00RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ch00 channel at 03/16/2013 12:47:43ORA-19502: write error on file "C:\U01\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\02O4LT5M_1_1", block number 783744 (block size=8192)ORA-27070: async read/write failedOSD-04016: Erro ao enfileirar uma solicitacao de E/S assincrona.O/S-Error: (OS 112) Espaco insuficiente no disco.Recovery Manager complete.Esta informacao sobre ORA-19502 no inicio nao ajudou muito a esclarecer a causa inicial do erro, pois aparentemente era um erro de gravacao em um arquivo de saida que deveria ser escrito em outro local e nao no onde o erro informava, inclusive ja as permissoes necessarias.Analisei se o script acima estava algo setado para o local onde o erro apontava, mas o formato onde deveria ser efetivado o backup do RMAN estava