adding datafile to prod and standby issues

hi, wanted to confirm my analysis

1. add datafile in prod standby cant add have to wait.. cos ORA-01156: recovery in progress may need access to files

am i right?

2) so after adding the first datafile, i add the second but got this

SQL> alter database create datafile
 2 '/oracle/SID/data8/btabi_36/btabi.data36'  3 as
 4 '/oracle/SID/data8/btabi_36/btabi.data36'; alter database create datafile
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile "/oracle/SID/data8/btabi_36/btabi.data36"

SQL> !oerr ora 1156
01156, 00000, "recovery in progress may need access to files"
// *Cause: Either media recovery or instance recovery is in progress. It may
// need the files this operation is being applied to.
// *Action: Wait for recovery to complete.

realised that i have to apply the archive logs in standby database and recover and reached this

ORA-00283: recovery session canceled due to errors
ORA-01670: new datafile 228 needed for standby database recovery
ORA-01157: cannot identify/lock data file 228 - see DBWR trace file
ORA-01110: data file 228: '/oracle/SID/data8/btabi_36/btabi.data36'

then create the datafile as described above

am i right? Received on Tue Mar 16 2004 - 22:56:30 CST