sql> clear screen sql> archive log list sp2-0718: illegal archive log option sql> archive log list database log mode archive mode automatic archival disabled archive destination d:\oracle oldest online log sequence 5 next log sequence to archive 7 current log sequence 7 sql> ---- closed backup sql> sql> ---- before go to closed backup to check the archive mode is in no archive mode sql> sql> ---- to change the archive mode to the no archive mode sql> sql> ---- use the following syntax sql> sql> alter database noarchive log; alter database noarchive log * error at line 1: ora-02231: missing or invalid option to alter database sql> alter database noarchivelog; alter database noarchivelog * error at line 1: ora-01126: database must be mounted exclusive and not open for this operation sql> alterb database open sp2-0734: unknown command beginning "alterb dat..." - rest of line ignored. sql> alter database open; alter database open * error at line 1: ora-01531: a database already open by the instance sql> show parameter log_archive; name -----------------------------------log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9
type value ----------- -----------------------------string string location=d:\oracle string string string string string string string string string
name -----------------------------------log_archive_dest_state_1 log_archive_dest_state_10 log_archive_dest_state_2 log_archive_dest_state_3 log_archive_dest_state_4 log_archive_dest_state_5 log_archive_dest_state_6 log_archive_dest_state_7 log_archive_dest_state_8 log_archive_dest_state_9 log_archive_duplex_dest
type ----------string string string string string string string string string string string
value -----------------------------enable enable enable enable enable enable enable enable enable enable
name type value ------------------------------------ ----------- -----------------------------log_archive_format string bkp%s.%t log_archive_max_processes integer 10 log_archive_min_succeed_dest integer 1 log_archive_start boolean false log_archive_trace integer 0 sql> archive log list database log mode archive mode automatic archival disabled archive destination d:\oracle oldest online log sequence 5 next log sequence to archive 7 current log sequence 7 sql> alter database noarchivelog; alter database noarchivelog * error at line 1: ora-01126: database must be mounted exclusive and not open for this operation sql> shutdown immediate database closed. database dismounted. oracle instance shut down. sql> startup mount oracle instance started. total system global area 135338868 bytes fixed size 453492 bytes variable size 109051904 bytes database buffers 25165824 bytes redo buffers 667648 bytes database mounted. sql> alter database noarchive log; alter database noarchive log * error at line 1: ora-02231: missing or invalid option to alter database sql> alter database noarchivelog; database altered.
sql> alter database open; database altered. sql> alter tablespace users rename datafile 'd:\bkp\users01.dbf' to 'd:\oracle\oradata\iimdba\\users01.dbf'; alter tablespace users rename datafile 'd:\bkp\users01.dbf' to 'd:\oracle\oradata\iimdba\\users01.dbf' * error at line 1: ora-01525: error in renaming data files ora-01121: cannot rename database file 9 - file is in use or recovery ora-01110: data file 9: 'd:\bkp\users01.dbf' sql> ed wrote file afiedt.buf 1* alter tablespace users rename datafile 'd:\bkp\users01.dbf' to 'd:\oracle\oradata\iimdba\users01.dbf' sql> / alter tablespace users rename datafile 'd:\bkp\users01.dbf' to 'd:\oracle\oradata\iimdba\users01.dbf' * error at line 1: ora-01525: error in renaming data files ora-01121: cannot rename database file 9 - file is in use or recovery ora-01110: data file 9: 'd:\bkp\users01.dbf' sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf to 'd:\bkp\users01.dbf'; alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf to 'd:\bkp\users01.dbf' error at line 1: ora-00946: missing to keyword
*
sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf'; alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf' * error at line 1: ora-02236: invalid file name sql> -------first we want to make the tablespace offline; sql> sql> alter tablespace users offline; tablespace altered. sql> alter tablespace users rename datafile 'd:\bkp\users01.dbf' to 'd:\oracle\oradata\iimdba\users01.dbf'; alter tablespace users rename datafile 'd:\bkp\users01.dbf' to
'd:\oracle\oradata\iimdba\users01.dbf' * error at line 1: ora-01525: error in renaming data files ora-01141: error renaming data file 9 - new file 'd:\oracle\oradata\iimdba\users01.dbf' not found ora-01110: data file 9: 'd:\bkp\users01.dbf' ora-27041: unable to open file osd-04002: unable to open file o/s-error: (os 2) the system cannot find the file specified. sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf'; alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf' * error at line 1: ora-02236: invalid file name sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01'; alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01' * error at line 1: ora-02236: invalid file name sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf'; alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to d:\bkp\users01.dbf' * error at line 1: ora-02236: invalid file name sql> ed wrote file afiedt.buf 1* alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users01.dbf' sql> / alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users01.dbf' * error at line 1: ora-01525: error in renaming data files ora-01522: file 'd:\oracle\oradata\iimdba\users01.dbf' to be renamed does not exist sql> ed wrote file afiedt.buf
1* alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users01.dbf' sql> spool off