Funda 2 > Closed_backup 1 - 10th May

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Funda 2 > Closed_backup 1 - 10th May as PDF for free.

More details

  • Words: 753
  • Pages: 5
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

Related Documents