| Fortunately this happened in our dev environment but still I am trying to
recover the data if possible.
Version 9.2.0.6 <http //9.2.0.6 >
SQL > alter database open
alter database open
*
ERROR at linThe database has to be open to end backup mode... I can 't open it
SQL > alter database open
alter database open
*
ERROR at line 1
ORA-01113 file 1 needs media recovery
ORA-01110 data file Hi oracle-l
i did a test about 'alter database datafile xxx offline (drop) '
it seems for the end user there is no diffrent. i can recover the datafile and take the datafile online even i offline I have an Oracle 8i database that I 'm trying to create a standby copy of
for testing / possible future DR use. The database is in ARCHIVELOG
mode.
On the master database I have placed each tabl |
|
