Funda 2 > Onlinebackup11- 12 May

sql> sql> sql> ---------- online backup sql> sql> archive log list database log mode archive mode automatic archival enabled archive destination d:\oracle oldest online log sequence 14 next log sequence to archive 16 current log sequence 16 sql> sql> sql> select name from v$datafile where ts#=9; name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------d:\bkp\users02.dbf sql> sql> sql> sql> alter tablespace users begin backup; tablespace altered. sql> sql> host sql> -------- use ocopy command sql> sql> ----- then exit from command prompt sql> sql> sql> sql> alter tablespace users end backup; tablespace altered. sql> sql> select * from v$logfile; group# status

type

---------- ------- ------member -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------3 online d:\oracle\oradata\iimdba\redo03.log

2

online

d:\oracle\oradata\iimdba\redo02.log

1

online

d:\oracle\oradata\iimdba\redo01.log

sql> set linesize 150; sql> set pagesize 150; sql> / group# status

type

---------- ------- ------member ----------------------------------------------------------------------------------------------------------------------------------------------------3 online d:\oracle\oradata\iimdba\redo03.log

2

online

d:\oracle\oradata\iimdba\redo02.log

1

online

d:\oracle\oradata\iimdba\redo01.log

sql> set linesize 200; sql> / group# status

type

---------- ------- ------member -------------------------------------------------------------------------------------------------------------------------------------------------------------------

-----------------------------------3 online d:\oracle\oradata\iimdba\redo03.log

2

online

d:\oracle\oradata\iimdba\redo02.log

1

online

d:\oracle\oradata\iimdba\redo01.log

sql> set pagesize 200; sql> / group# status

type

---------- ------- ------member -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------3 online d:\oracle\oradata\iimdba\redo03.log

2

online

d:\oracle\oradata\iimdba\redo02.log

1

online

d:\oracle\oradata\iimdba\redo01.log

sql> select * from v$logfile; group# status

type

---------- ------- ------member

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------3 online d:\oracle\oradata\iimdba\redo03.log

2

online

d:\oracle\oradata\iimdba\redo02.log

1

online

d:\oracle\oradata\iimdba\redo01.log

sql> select * from v$datafile; file# creation_change# creation_ ts# rfile# status enabled checkpoint_change# checkpoin unrecoverable_change# unrecover last_change# last_time offline_change# online_change# ---------- ---------------- --------- ---------- ---------- ------- --------------------------- --------- --------------------- --------- -------------------- --------------- -------------online_ti bytes blocks create_bytes block_size --------- ---------- ---------- ------------ ---------name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------plugged_in block1_offset ---------- ------------aux_name -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1 11 12-may-02 0 1 system read write 321067 12-may-08 0 190577 190578 08-may-08 419430400 51200 0 8192 d:\oracle\oradata\iimdba\system01.dbf 0

8192

none

2 187697 12-may-02 321067 12-may-08 0 190577 190578 08-may-08 209715200 25600

1 0

2 online

read write

3 online

read write

4 online

read write

5 online

read write

6 online

read write

8192

d:\oracle\oradata\iimdba\undotbs01.dbf 0

8192

none

3 321067 12-may-08 190577 190578 08-may-08 20971520

6283 12-may-02

3

0

2560

0

8192

d:\oracle\oradata\iimdba\cwmlite01.dbf 0

8192

none

4 321067 12-may-08 190577 190578 08-may-08 20971520

6302 12-may-02

4 0

2560

0

8192

d:\oracle\oradata\iimdba\drsys01.dbf 0

8192

none

5 321067 12-may-08 190577 190578 08-may-08 155975680

6324 12-may-02

5

0

19040

0

8192

d:\oracle\oradata\iimdba\example01.dbf 0

8192

none

6 321067 12-may-08

6343 12-may-02

6 0

190577 08-may-08

190578 26214400

3200

0

8192

d:\oracle\oradata\iimdba\indx01.dbf 0

8192

none

7 321067 12-may-08 190577 190578 08-may-08 20971520

6363 12-may-02

7

0

2560

0

7 online

read write

8 online

read write

9 online

read write

10 online

read write

8192

d:\oracle\oradata\iimdba\odm01.dbf 0

8192

none

8 321067 12-may-08 190577 190578 08-may-08 10485760

6382 12-may-02

8 0

1280

0

8192

d:\oracle\oradata\iimdba\tools01.dbf 0

8192

none

9 322251 12-may-08 320886 321333 12-may-08 26214400

6401 12-may-02

9

0

3200

0

8192

d:\bkp\users02.dbf 0

8192

none

10 321067 12-may-08 190577 190578 08-may-08 39976960

6420 12-may-02 4880

d:\oracle\oradata\iimdba\xdb01.dbf 0

8192

10 0 0

8192

none

10 rows selected. sql> select * from v$log 2 ; group# thread# sequence# first_change# first_tim

bytes

members arc status

---------- ---------- ---------- ---------- ---------- --- ---------------------------- --------1 320797 12-may-08

1

14

104857600

1 yes inactive

2 320800 12-may-08

1

15

104857600

1 yes inactive

3 320802 12-may-08

1

16

104857600

1 no

current

sql> alter system switch logfile; system altered. sql> / system altered. sql> / system altered. sql>

select * from v$log;

group# thread# sequence# first_change# first_tim

bytes

members arc status

---------- ---------- ---------- ---------- ---------- --- ---------------------------- --------1 322976 12-may-08

1

17

104857600

1 yes inactive

2 322978 12-may-08

1

18

104857600

1 yes inactive

3 322982 12-may-08

1

19

104857600

1 no

sql>

current

sql> sql> alter tablespace users offline; tablespace altered. sql> shutdown immediate; database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started. total system global area fixed size variable size database buffers redo buffers

135338868 bytes 453492 bytes 109051904 bytes 25165824 bytes 667648 bytes

database mounted. database opened. sql> sql> sql> sql> alter tablespace users online; alter tablespace users online * error at line 1: ora-01157: cannot identify/lock data file 9 - see dbwr trace file ora-01110: data file 9: 'd:\bkp\users02.dbf' sql> alter tablespace set rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.dbf'; alter tablespace set rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.dbf' * error at line 1: ora-02140: invalid tablespace name sql> ed wrote file afiedt.buf 1* alter tablespace rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.dbf' sql> / alter tablespace rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.dbf' * error at line 1: ora-02140: invalid tablespace name sql> ed

wrote file afiedt.buf 1* alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.dbf' sql> / alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.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\users02.dbf' sql> / alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users02.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> alter tablespace users rename datafile 'd:\bkp\users02.dbf' 'd:\oracle\oradata\iimdba\users01.dbf';

to

tablespace altered. sql> alter tablespace users rename datafile 'd:\oracle\oradata\iimdba\users01.dbf' to 'd:\bkp\users01.dbf'; tablespace altered. sql> alter tablespace users online; alter tablespace users online * error at line 1: ora-01113: file 9 needs media recovery ora-01110: data file 9: 'd:\bkp\users01.dbf' sql> recover tablespace users; ora-00279: change 294480 generated at 05/10/2008 16:21:37 needed for thread 1 ora-00289: suggestion : d:\oracle\bkp7.1 ora-00280: change 294480 for thread 1 is in sequence #7 specify log: {=suggested | filename | auto | cancel} auto ora-00308: cannot open archived log 'd:\oracle\bkp7.1' ora-27041: unable to open file osd-04002: unable to open file

o/s-error: (os 2) the system cannot find the file specified. ora-00308: ora-27041: osd-04002: o/s-error:

cannot unable unable (os 2)

sql> sql> sql> spool off

open archived log 'd:\oracle\bkp7.1' to open file to open file the system cannot find the file specified.