Performing direct loads originating from a direct path load, table create via subquery, or index create on the primary database, the performance gain applies only to the primary database. There is no corresponding recovery process performance improvement on the standby database. The standby database recovery process still sequentially reads and applies the redo information generated by the unrecoverable direct load. Also, operations using the UNRECOVERABLE option are not propagated to the standby database since the operations are not logged.
Data files affected by direct path operations on the primary database can be altered off-line in the standby database. Data files altered off-line in the standby database must be altered off-line with the DROP option. Tablespaces containing the off-line files must be dropped when the standby database is activated.