(BACKUP SCRIPTS)
host ocopy C:\Oracle\RDBMS\*.001 e:\temp
host del C:\Oracle\RDBMS\*.001 /q
set echo on
alter tablespace system begin backup;
host ocopy E:\LOCAL\ORADATA\SYSTEM.DBF e:\bu
alter tablespace system end backup;
alter tablespace undotbs begin backup;
host ocopy E:\LOCAL\ORADATA\UNDOTBS.DBF e:\bu
alter tablespace undotbs end backup;
alter tablespace data begin backup;
host ocopy E:\LOCAL\ORADATA\DATA.DBF e:\bu
alter tablespace data end backup;
alter tablespace "INDEX" begin backup;
host ocopy E:\LOCAL\ORADATA\FLEX_INDEX.DBF e:\bu
alter tablespace "INDEX" end backup;
alter database backup controlfile to 'e:\bu\control01.bak' reuse ;
host ocopy C:\Oracle\RDBMS\*.001 e:\bu /q
2. Backup all Archivelog files by using following commands on Daily Basic.
host ocopy C:\Oracle\RDBMS\*.001 e:\local\bu /q
3. Suppose You have Sunday hot backup and you have also Monday to Wednesday archive log file backup. Suppose any data file corrupt or missed on Thursday, how will you recover database up to Wednesday.
4. When you triying to open database following error accore:
SQL> startup
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 62914560 bytes
Database Buffers 54525952 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'E:\LOCAL\ORADATA\SYSTEM.DBF'
5. Check backup status and messing file (Required recovery) and current log sicquence of all data file.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 FILE NOT FOUND 0
2 NOT ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 314027 13-OCT-06
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
1 ONLINE ONLINE FILE NOT FOUND 0
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 304 52428800 1 NO CURRENT 335069 14-OCT-06
2 1 302 52428800 1 YES INACTIVE 335067 14-OCT-06
3 1 303 52428800 1 YES INACTIVE 335068 14-OCT-06
6. Restore datafile from backup location.
7. Try to open database by using following command:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\LOCAL\ORADATA\SYSTEM.DBF'
8. SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 334936 14-OCT-06
2 NOT ACTIVE 334942 14-OCT-06
3 ACTIVE 334949 14-OCT-06
4 NOT ACTIVE 334977 14-OCT-06
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
1 ONLINE ONLINE 334936 14-OCT-06
3 ONLINE ONLINE 334949 14-OCT-06
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 304 52428800 1 NO CURRENT 335069 14-OCT-06
2 1 302 52428800 1 YES INACTIVE 335067 14-OCT-06
3 1 303 52428800 1 YES INACTIVE 335068 14-OCT-06
SQL> select * from v$log_history;
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
1 603754350 1 1 313930 13-OCT-06 314115
2 603754360 1 2 314115 13-OCT-06 314116
3 603754369 1 3 314116 13-OCT-06 314118
4 603754369 1 4 314118 13-OCT-06 314119
5 603754374 1 5 314119 13-OCT-06 314120
6 603754374 1 6 314120 13-OCT-06 314121
7 603754379 1 7 314121 13-OCT-06 314122
8 603754379 1 8 314122 13-OCT-06 314123
9 603754385 1 9 314123 13-OCT-06 314124
10 603754385 1 10 314124 13-OCT-06 314125
11 603754390 1 11 314125 13-OCT-06 314126
303 603822241 1 303 335068 14-OCT-06 335069
SQL> recover datafile 1;
ORA-00279: change 334936 generated at 10/14/2006 16:13:22 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\RDBMS\ARC00208.001
ORA-00280: change 334936 for thread 1 is in sequence #208
Specify log: {
AUTO
SQL*Plus: Release 9.0.1.0.1 - Production on Fri Oct 13 21:20:42 2006
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
SQL> set linesize 7777
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 1 52428800 1 NO CURRENT 313930 13-OCT-06
2 1 0 52428800 1 YES UNUSED 0
3 1 0 52428800 1 YES UNUSED 0
SQL> select * from v$recover_file;
no rows selected
SQL> select * from v$bachup;
select * from v$bachup
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 251373 12-OCT-06
2 NOT ACTIVE 251381 12-OCT-06
3 NOT ACTIVE 251388 12-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 251388 12-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 251388 12-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 251388 12-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 251396 12-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 314021 13-OCT-06
4 ACTIVE 314027 13-OCT-06
SQL> /
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 314027 13-OCT-06
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 62914560 bytes
Database Buffers 54525952 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 62914560 bytes
Database Buffers 54525952 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'E:\LOCAL\ORADATA\SYSTEM.DBF'
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 25 52428800 1 YES INACTIVE 314139 13-OCT-06
2 1 26 52428800 1 NO CURRENT 314140 13-OCT-06
3 1 24 52428800 1 YES INACTIVE 314138 13-OCT-06
SQL> select * from V$log_history;
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
1 603754350 1 1 313930 13-OCT-06 314115
2 603754360 1 2 314115 13-OCT-06 314116
3 603754369 1 3 314116 13-OCT-06 314118
4 603754369 1 4 314118 13-OCT-06 314119
5 603754374 1 5 314119 13-OCT-06 314120
6 603754374 1 6 314120 13-OCT-06 314121
7 603754379 1 7 314121 13-OCT-06 314122
8 603754379 1 8 314122 13-OCT-06 314123
9 603754385 1 9 314123 13-OCT-06 314124
10 603754385 1 10 314124 13-OCT-06 314125
11 603754390 1 11 314125 13-OCT-06 314126
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
12 603754390 1 12 314126 13-OCT-06 314127
13 603754395 1 13 314127 13-OCT-06 314128
14 603754395 1 14 314128 13-OCT-06 314129
15 603754401 1 15 314129 13-OCT-06 314130
16 603754401 1 16 314130 13-OCT-06 314131
17 603754406 1 17 314131 13-OCT-06 314132
18 603754406 1 18 314132 13-OCT-06 314133
19 603754411 1 19 314133 13-OCT-06 314134
20 603754412 1 20 314134 13-OCT-06 314135
21 603754417 1 21 314135 13-OCT-06 314136
22 603754417 1 22 314136 13-OCT-06 314137
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
23 603754422 1 23 314137 13-OCT-06 314138
24 603754422 1 24 314138 13-OCT-06 314139
25 603754445 1 25 314139 13-OCT-06 314140
25 rows selected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'E:\LOCAL\ORADATA\SYSTEM.DBF'
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 314007 13-OCT-06
2 NOT ACTIVE 314014 13-OCT-06
3 NOT ACTIVE 314021 13-OCT-06
4 NOT ACTIVE 314027 13-OCT-06
SQL> alter * from v$recover_file;
alter * from v$recover_file
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME
---------- ------- ------- ----------------------------------------------------------------- ---------- ---------
1 ONLINE ONLINE 314007 13-OCT-06
SQL> select * from v$log_history;
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
1 603754350 1 1 313930 13-OCT-06 314115
2 603754360 1 2 314115 13-OCT-06 314116
3 603754369 1 3 314116 13-OCT-06 314118
4 603754369 1 4 314118 13-OCT-06 314119
5 603754374 1 5 314119 13-OCT-06 314120
6 603754374 1 6 314120 13-OCT-06 314121
7 603754379 1 7 314121 13-OCT-06 314122
8 603754379 1 8 314122 13-OCT-06 314123
9 603754385 1 9 314123 13-OCT-06 314124
10 603754385 1 10 314124 13-OCT-06 314125
11 603754390 1 11 314125 13-OCT-06 314126
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
12 603754390 1 12 314126 13-OCT-06 314127
13 603754395 1 13 314127 13-OCT-06 314128
14 603754395 1 14 314128 13-OCT-06 314129
15 603754401 1 15 314129 13-OCT-06 314130
16 603754401 1 16 314130 13-OCT-06 314131
17 603754406 1 17 314131 13-OCT-06 314132
18 603754406 1 18 314132 13-OCT-06 314133
19 603754411 1 19 314133 13-OCT-06 314134
20 603754412 1 20 314134 13-OCT-06 314135
21 603754417 1 21 314135 13-OCT-06 314136
22 603754417 1 22 314136 13-OCT-06 314137
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
23 603754422 1 23 314137 13-OCT-06 314138
24 603754422 1 24 314138 13-OCT-06 314139
25 603754445 1 25 314139 13-OCT-06 314140
25 rows selected.
SQL> select 8 from v$datafile;
8
----------
8
8
8
8
SQL> select * from v$datafile;
FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# UNRECOVER LAST_CHANGE# LAST_TIME O
---------- ---------------- --------- ---------- ---------- ------- ---------- ------------------ --------- --------------------- --------- ------------ --------- -
1 4 06-OCT-06 0 1 SYSTEM READ WRITE 314150 13-OCT-06 0 314150 13-OCT-06
2 5827 06-OCT-06 1 2 ONLINE READ WRITE 314150 13-OCT-06 0 314150 13-OCT-06
3 6752 06-OCT-06 2 3 ONLINE READ WRITE 314150 13-OCT-06 0 314150 13-OCT-06
4 6774 06-OCT-06 3 4 ONLINE READ WRITE 314150 13-OCT-06 0 314150 13-OCT-06
SQL> select namr from V%archivelogs;
select namr from V%archivelogs
*
ERROR at line 1:
ORA-00911: invalid character
SQL> select * from V$archive_logs;
select * from V$archive_logs
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select * from V$archive_log;
select * from V$archive_log
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> ed
Wrote file afiedt.buf
1* select * from V$archived_log
SQL> /
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
1 603465266 C:\ORACLE\RDBMS\ARC00002.001
2 603465267 C:\ORACLE\RDBMS\ARC00003.001
3 603465268 C:\ORACLE\RDBMS\ARC00004.001
4 603491991 C:\ORACLE\RDBMS\ARC00005.001
5 603540234 C:\ORACLE\RDBMS\ARC00006.001
6 603668585 C:\ORACLE\RDBMS\ARC00007.001
7 603668586 C:\ORACLE\RDBMS\ARC00008.001
8 603668592 C:\ORACLE\RDBMS\ARC00009.001
9 603669141
10 603670713 C:\ORACLE\RDBMS\ARC00001.001
11 603670715 C:\ORACLE\RDBMS\ARC00002.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
12 603670719 C:\ORACLE\RDBMS\ARC00003.001
13 603670720 C:\ORACLE\RDBMS\ARC00004.001
14 603670726 C:\ORACLE\RDBMS\ARC00005.001
15 603670728 C:\ORACLE\RDBMS\ARC00006.001
16 603670729 C:\ORACLE\RDBMS\ARC00007.001
17 603670733 C:\ORACLE\RDBMS\ARC00008.001
18 603670733 C:\ORACLE\RDBMS\ARC00009.001
19 603670737 C:\ORACLE\RDBMS\ARC00010.001
20 603670737 C:\ORACLE\RDBMS\ARC00011.001
21 603670742 C:\ORACLE\RDBMS\ARC00012.001
22 603670743 C:\ORACLE\RDBMS\ARC00013.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
23 603670748 C:\ORACLE\RDBMS\ARC00014.001
24 603670748 C:\ORACLE\RDBMS\ARC00015.001
25 603670753 C:\ORACLE\RDBMS\ARC00016.001
26 603670753 C:\ORACLE\RDBMS\ARC00017.001
27 603670759 C:\ORACLE\RDBMS\ARC00018.001
28 603670759 C:\ORACLE\RDBMS\ARC00019.001
29 603670759 C:\ORACLE\RDBMS\ARC00020.001
30 603670764 C:\ORACLE\RDBMS\ARC00021.001
31 603670764 C:\ORACLE\RDBMS\ARC00022.001
32 603670769 C:\ORACLE\RDBMS\ARC00023.001
33 603670769 C:\ORACLE\RDBMS\ARC00024.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
34 603671995 C:\ORACLE\RDBMS\ARC00025.001
35 603672005 C:\ORACLE\RDBMS\ARC00026.001
36 603672006 C:\ORACLE\RDBMS\ARC00027.001
37 603672011 C:\ORACLE\RDBMS\ARC00028.001
38 603672011 C:\ORACLE\RDBMS\ARC00029.001
39 603672016 C:\ORACLE\RDBMS\ARC00030.001
40 603672017 C:\ORACLE\RDBMS\ARC00031.001
41 603673030 C:\ORACLE\RDBMS\ARC00032.001
42 603721691 C:\ORACLE\RDBMS\ARC00033.001
43 603722884 C:\ORACLE\RDBMS\ARC00034.001
44 603722886 C:\ORACLE\RDBMS\ARC00035.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
45 603722890 C:\ORACLE\RDBMS\ARC00036.001
46 603722890 C:\ORACLE\RDBMS\ARC00037.001
47 603726744 C:\ORACLE\RDBMS\ARC00038.001
48 603726745 C:\ORACLE\RDBMS\ARC00039.001
49 603726747 C:\ORACLE\RDBMS\ARC00040.001
50 603728810 C:\ORACLE\RDBMS\ARC00041.001
51 603737242 C:\ORACLE\RDBMS\ARC00042.001
52 603737242 C:\ORACLE\RDBMS\ARC00043.001
53 603737242 C:\ORACLE\RDBMS\ARC00044.001
54 603737243 C:\ORACLE\RDBMS\ARC00045.001
55 603737244 C:\ORACLE\RDBMS\ARC00046.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
56 603737244 C:\ORACLE\RDBMS\ARC00047.001
57 603737246 C:\ORACLE\RDBMS\ARC00048.001
58 603737251 C:\ORACLE\RDBMS\ARC00049.001
59 603737252 C:\ORACLE\RDBMS\ARC00050.001
60 603737253 C:\ORACLE\RDBMS\ARC00051.001
61 603737255 C:\ORACLE\RDBMS\ARC00052.001
62 603738258 C:\ORACLE\RDBMS\ARC00053.001
63 603738298 C:\ORACLE\RDBMS\ARC00054.001
64 603738303 C:\ORACLE\RDBMS\ARC00055.001
65 603738303 C:\ORACLE\RDBMS\ARC00056.001
66 603738303 C:\ORACLE\RDBMS\ARC00057.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
67 603738308 C:\ORACLE\RDBMS\ARC00058.001
68 603738309 C:\ORACLE\RDBMS\ARC00059.001
69 603738314 C:\ORACLE\RDBMS\ARC00060.001
70 603738314 C:\ORACLE\RDBMS\ARC00061.001
71 603738314 C:\ORACLE\RDBMS\ARC00062.001
72 603738319 C:\ORACLE\RDBMS\ARC00063.001
73 603738325 C:\ORACLE\RDBMS\ARC00064.001
74 603739549 C:\ORACLE\RDBMS\ARC00065.001
75 603739882 C:\ORACLE\RDBMS\ARC00001.001
76 603739883 C:\ORACLE\RDBMS\ARC00002.001
77 603739883 C:\ORACLE\RDBMS\ARC00003.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
78 603739884 C:\ORACLE\RDBMS\ARC00004.001
79 603739884 C:\ORACLE\RDBMS\ARC00005.001
80 603739890 C:\ORACLE\RDBMS\ARC00006.001
81 603739890 C:\ORACLE\RDBMS\ARC00007.001
82 603739896 C:\ORACLE\RDBMS\ARC00008.001
83 603749449 C:\ORACLE\RDBMS\ARC00009.001
84 603749779 C:\ORACLE\RDBMS\ARC00010.001
85 603749780 C:\ORACLE\RDBMS\ARC00011.001
86 603749784 C:\ORACLE\RDBMS\ARC00012.001
87 603749785 C:\ORACLE\RDBMS\ARC00013.001
88 603749791 C:\ORACLE\RDBMS\ARC00014.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
89 603749795 C:\ORACLE\RDBMS\ARC00015.001
90 603749796 C:\ORACLE\RDBMS\ARC00016.001
91 603749796 C:\ORACLE\RDBMS\ARC00017.001
92 603749797 C:\ORACLE\RDBMS\ARC00018.001
93 603749803 C:\ORACLE\RDBMS\ARC00019.001
94 603749804 C:\ORACLE\RDBMS\ARC00020.001
95 603749809 C:\ORACLE\RDBMS\ARC00021.001
96 603749810 C:\ORACLE\RDBMS\ARC00022.001
97 603751702 C:\ORACLE\RDBMS\ARC00023.001
98 603751703 C:\ORACLE\RDBMS\ARC00024.001
99 603751707 C:\ORACLE\RDBMS\ARC00025.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
100 603751707 C:\ORACLE\RDBMS\ARC00026.001
101 603751712 C:\ORACLE\RDBMS\ARC00027.001
102 603751712 C:\ORACLE\RDBMS\ARC00028.001
103 603751718 C:\ORACLE\RDBMS\ARC00029.001
104 603751718 C:\ORACLE\RDBMS\ARC00030.001
105 603751723 C:\ORACLE\RDBMS\ARC00031.001
106 603751723 C:\ORACLE\RDBMS\ARC00032.001
107 603751728 C:\ORACLE\RDBMS\ARC00033.001
108 603751728 C:\ORACLE\RDBMS\ARC00034.001
109 603751733 C:\ORACLE\RDBMS\ARC00035.001
110 603751733 C:\ORACLE\RDBMS\ARC00036.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
111 603751739 C:\ORACLE\RDBMS\ARC00037.001
112 603751753 C:\ORACLE\RDBMS\ARC00038.001
113 603752151
114 603754350 C:\ORACLE\RDBMS\ARC00001.001
115 603754360 C:\ORACLE\RDBMS\ARC00002.001
116 603754369 C:\ORACLE\RDBMS\ARC00003.001
117 603754369 C:\ORACLE\RDBMS\ARC00004.001
118 603754374 C:\ORACLE\RDBMS\ARC00005.001
119 603754374 C:\ORACLE\RDBMS\ARC00006.001
120 603754379 C:\ORACLE\RDBMS\ARC00007.001
121 603754379 C:\ORACLE\RDBMS\ARC00008.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
122 603754385 C:\ORACLE\RDBMS\ARC00009.001
123 603754385 C:\ORACLE\RDBMS\ARC00010.001
124 603754390 C:\ORACLE\RDBMS\ARC00011.001
125 603754390 C:\ORACLE\RDBMS\ARC00012.001
126 603754395 C:\ORACLE\RDBMS\ARC00013.001
127 603754395 C:\ORACLE\RDBMS\ARC00014.001
128 603754401 C:\ORACLE\RDBMS\ARC00015.001
129 603754401 C:\ORACLE\RDBMS\ARC00016.001
130 603754406 C:\ORACLE\RDBMS\ARC00017.001
131 603754406 C:\ORACLE\RDBMS\ARC00018.001
132 603754412 C:\ORACLE\RDBMS\ARC00019.001
RECID STAMP NAME
---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------
133 603754412 C:\ORACLE\RDBMS\ARC00020.001
134 603754417 C:\ORACLE\RDBMS\ARC00021.001
135 603754417 C:\ORACLE\RDBMS\ARC00022.001
136 603754422 C:\ORACLE\RDBMS\ARC00023.001
137 603754422 C:\ORACLE\RDBMS\ARC00024.001
138 603754445 C:\ORACLE\RDBMS\ARC00025.001
138 rows selected.
SQL> show parameter log_Archive_form
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string ARC%S.%T
Post a Comment