Erro no alert.log do Oracle dataguard
(spare):
Existing file may be overwritten
File #1401 added to control file as 'UNNAMED01401'.
Originally created as:
'/oracle/SID/sapdata64/btabd_587/btabd.data587'
Recovery was unable to create the file as:
'/oracle/SID/sapdata64/btabd_587/btabd.data587'
Errors with log
/oracle/SID/saparch/SIDarch1_267599_761383197.dbf
MRP0: Background Media Recovery terminated with
error 1119
Wed Dec 5
17:45:04 2012
Errors in file
/oracle/SID/saptrace/background/SID_mrp0_29567.trc:
ORA-01119: error in creating database file
'/oracle/SID/sapdata64/btabd_587/btabd.data587'
ORA-27054: NFS file system where the file is
created or resides is not mounted with correct options
Linux-x86_64 Error: 13: Permission denied
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may
fail
Wed Dec 5
17:45:04 2012
Errors in file /oracle/SID/saptrace/background/SID_mrp0_29567.trc:
ORA-01119: error in creating database file
'/oracle/SID/sapdata64/btabd_587/btabd.data587'
ORA-27054: NFS file system where the file is
created or resides is not mounted with correct options
Linux-x86_64 Error: 13: Permission denied
Wed Dec 5
17:45:04 2012
MRP0: Background Media Recovery process shutdown
(SID)
Wed Dec 5
17:48:56 2012
RFS[1]: Archived Log: '/oracle/SID/saparch/SIDarch1_267600_761383197.dbf'
A causa do erro era permissão no
diretório /oracle/SID/sapdata64, que estava root:root. Ao criar o novo datafile
btabd.data587 no server origem, este não foi replicado na server, travando o
dataguard.
A permissão do diretório foi corrigido
(oraSID:dba) e o Oracle na server reiniciado:
SQL> shutdown immediate;
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database recover managed standby
database disconnect;
Porém o erro persistiu, o dataguard não
criou o arquivo automaticamente:
MRP0: Background Managed Standby Recovery process
started (SID)
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with
error 1111
Thu Dec 6
11:33:45 2012
Errors in file /oracle/SID/saptrace/background/SID_mrp0_30181.trc:
ORA-01111: name for data file 1401 is unknown -
rename to correct file
ORA-01110: data file 1401: '/oracle/SID/102_64/dbs/UNNAMED01401'
ORA-01157: cannot identify/lock data file 1401 -
see DBWR trace file
ORA-01111: name for data file 1401 is unknown -
rename to correct file
ORA-01110: data file 1401: '/oracle/SID/102_64/dbs/UNNAMED01401'
Thu Dec 6
11:33:45 2012
Errors in file /oracle/SID/saptrace/background/SID_mrp0_30181.trc:
ORA-01111: name for data file 1401 is unknown -
rename to correct file
ORA-01110: data file 1401: '/oracle/SID/102_64/dbs/UNNAMED01401'
ORA-01157: cannot identify/lock data file 1401 -
see DBWR trace file
ORA-01111: name for data file 1401 is unknown -
rename to correct file
ORA-01110: data file 1401: '/oracle/SID/102_64/dbs/UNNAMED01401'
Thu Dec 6
11:33:45 2012
MRP0: Background Media Recovery process shutdown (SID)
Thu Dec 6
11:33:45 2012
O arquivo teve que ser criado
manualmente na Server. Primeiro foi criado o seu diretório:
server:oraSID
105> mkdir /oracle/SID/sapdata64/btabd_587
Modo recovery desativado:
SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active
Gerenciamento dos arquivos setado para
ser executado manualmente:
SQL> alter system set
standby_file_management=manual;
System altered.
Datafile criado:
alter database create datafile '/oracle/SID/102_64/dbs/UNNAMED01401'
as '/oracle/SID/sapdata64/btabd_587/btabd.data587';
O nome do arquivo determinado no alert.log:
ORA-01110: data file 1401: '/oracle/SID/102_64/dbs/UNNAMED01401'
ORA-01157: cannot identify/lock data file 1401 -
see DBWR trace file
ORA-01111: name for data file 1401 is unknown -
rename to correct file
Reativando o dataguard:
SQL> alter system set
standby_file_management=auto;
System altered.
SQL> alter database recover managed standby
database disconnect;
Database altered.
