Windows Oracle10g
-------------------------------------------------------------------------
SQL> alter database begin backup;
Alter database begin backup
*
Row 3 has an error:
ORA-01123: online backup cannot be started; media recovery not enabled
SQL> archive log list
Database Log mode non-archive Mode
Disable automatic archiving
Archiving end point use_db_recovery_file_dest
Oldest online log sequence 13
Current Log sequence 15
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01531: Instance opened database
SQL> shutdown immediate
The database has been closed.
The database has been detached.
The Oracle routine has been disabled.
SQL> startup Mount
The Oracle routine has been started.
Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
SQL> alter database archivelog;
The database has been changed.
SQL> alter database open;
The database has been changed.
SQL> alter database begin backup;
The database has been changed.
SQL> host xcopy C:/Oracle/product/10.2.0/oradata/ora/*. DBF C:/bak/
SQL> alter Database End backup;
The database has been changed.
SQL> shutdown immediate
The database has been closed.
The database has been detached.
The Oracle routine has been disabled.
SQL> destroys database files *. DBF
SP2-0734: Unknown command starting with "corrupt database..."-ignore the remaining lines.
SQL> startup
The Oracle routine has been started.
Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
ORA-01157: unable to identify/lock data file 4-see dbwr trace file
ORA-01110: data file 4: 'C:/Oracle/product/10.2.0/oradata/ora/users01.dbf'
SQL> shutdown immediate
ORA-01109: the database is not open
The database has been detached.
The Oracle routine has been disabled.
SQL> copy Hot Standby files
SP2-0734: Unknown command starting with "Copy hot standby..."-ignore the remaining lines.
SQL> Start Mount
SP2-0310: Unable to open file "Mount. SQL"
SQL> startup Mount;
The Oracle routine has been started.
Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
SQL> recover database;
Media recovery is completed.
-- If you want to change the database to non-archive mode, alter database noarchivelog
SQL> alter database open;
The database has been changed.
SQL> spool off;
---------------------------------------------------------------------------
This completes the entire operation!