Problem datafile at standby database

untuk datafile yang corrupt di standby database misal file_id 43 currupt
soluasinya :
1. alter database recover automatic standby database allow 1 corruption;
(lihat di alert log)

di primary
2. select file_name, tablespace_name from dba_data_files where file_id= 43
3. alter tablespace test begin backup;

copy file dengan file_id 43 ke standby database

primary :
4.
alter tablespace test end backup;

standby
5.
alter database recover managed standby database disconnect from session;

jika error nya karena

ora-600 [3o20]
1. di standby
tambahkan hidden parameter _disable_recoverable_recovery=true
2. apply patch
patch number 7197445