1. create the test tables with primary key and foreign key
SYS@testdb> CONN user1
Connected.
user1@testdb>
user1@testdb> create table emp (emp_id number constraint emp_pk primary key );
Table created.
user1@testdb> create table empinfo ( emp_name varchar2(10), emp_id number references emp(emp_id));
Table created.
user1@testdb> drop table emp;
drop table emp
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
user1@testdb> insert into emp values(1);
1 row created.
user1@testdb> insert into empinfo values ('li',2);
insert into empinfo values ('li',2)
*
ERROR at line 1:
ORA-02291: integrity constraint (user1.SYS_C0044749) violated - parent key
not found
user1@testdb> insert into empinfo values ('li',1);
1 row created.
user1@testdb> commit;
Commit complete.
2. attemp to drop parent table emp, even failed after diable both primary and foreign key constraints.
user1@testdb> drop table emp;
drop table emp
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints
2 where table_name in ('EMP','EMPINFO');
TABLE_NAME CONSTRAINT_NAME C
------------------------------ ------------------------------ -
R_CONSTRAINT_NAME STATUS
------------------------------ --------
EMPINFO SYS_C0044749 R
EMP_PK ENABLED
EMP EMP_PK P
ENABLED
user1@testdb> alter table empinfo disable constraint SYS_C0044749 ;
Table altered.
user1@testdb> drop table emp;
drop table emp
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
user1@testdb> alter table emp disable constraint EMP_PK;
Table altered.
user1@testdb> drop table emp;
drop table emp
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
user1@testdb> drop table emp cascade constraint;
Table dropped.
user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints where table_name in ('EMP','EMPINFO');
no rows selected
user1@testdb> select * from empinfo;
EMP_NAME EMP_ID
---------- ----------
li 1
3. create backup the parent table after changes made to it. e.g partition it.
user1@testdb> create table emp (emp_id number constraint emp_pk primary key );
Table created.
user1@testdb> alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id);
alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id)
*
ERROR at line 1:
ORA-02298: cannot validate (user1.EMPINFO_FK) - parent keys not found
user1@testdb> insert into emp values(1);
1 row created.
user1@testdb> alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id);
Table altered.
user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints
2 where table_name in ('EMP','EMPINFO');
TABLE_NAME CONSTRAINT_NAME C
------------------------------ ------------------------------ -
R_CONSTRAINT_NAME STATUS
------------------------------ --------
EMPINFO EMPINFO_FK R
EMP_PK ENABLED
EMP EMP_PK P
ENABLED
Conclusion:
drop table with cascade constraint is the must.
Monday, October 28, 2013
Thursday, October 24, 2013
How To Convert .MTS Video Files (AVCHD) To Other Formats On Ubuntu
x-terminal-emulator: error: Additional unexpected arguments found: ['&']
ConfigBase::load: Unable to open /home/hmc/.config/terminator/config ([Errno 2] No such file or directory: '/home/hmc/.config/terminator/config')
Usage: x-terminal-emulator [options]
x-terminal-emulator: error: Additional unexpected arguments found: ['&']
http://www.upubuntu.com/2011/11/how-to-convert-mts-video-files-avchd-to.html
http://ubuntuforums.org/showthread.php?t=1541808
Look in WinFF's edit > preferences > linux > set terminal options
Change it from e to x, or vice versa. Then try it again.
Size
hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l 00008.MTS
-rw-r--r-- 1 hmc hmc 83171328 Oct 23 20:02 00008.MTS
hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l ../
total 276068
-rw-rw-r-- 1 hmc hmc 8104429 Oct 24 00:43 00008_high.mp4
-rw-rw-r-- 1 hmc hmc 238273943 Oct 24 00:55 00008_superhigh.mp4
-rw-rw-r-- 1 hmc hmc 36299619 Oct 24 01:02 00008_very_high.mp4
Conclusion: the best video quality is the .MTS
ConfigBase::load: Unable to open /home/hmc/.config/terminator/config ([Errno 2] No such file or directory: '/home/hmc/.config/terminator/config')
Usage: x-terminal-emulator [options]
x-terminal-emulator: error: Additional unexpected arguments found: ['&']
http://www.upubuntu.com/2011/11/how-to-convert-mts-video-files-avchd-to.html
http://ubuntuforums.org/showthread.php?t=1541808
Look in WinFF's edit > preferences > linux > set terminal options
Change it from e to x, or vice versa. Then try it again.
Size
hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l 00008.MTS
-rw-r--r-- 1 hmc hmc 83171328 Oct 23 20:02 00008.MTS
hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l ../
total 276068
-rw-rw-r-- 1 hmc hmc 8104429 Oct 24 00:43 00008_high.mp4
-rw-rw-r-- 1 hmc hmc 238273943 Oct 24 00:55 00008_superhigh.mp4
-rw-rw-r-- 1 hmc hmc 36299619 Oct 24 01:02 00008_very_high.mp4
Conclusion: the best video quality is the .MTS
Wednesday, October 23, 2013
CreateOUIProcess(): 13 : Permission denied
Hit the error when install 11.2.0.3 client on Redhat 5.4 x64
[oracle@test01 client]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 664 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2001-07-23_06-31-05AM. Please wait ...Error in CreateOUIProcess(): 13 : Permission denied
[oracle@test01 client]$ cd /tmp/OraInstall2001-07-23_06-31-05AM
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l
total 44
-rwxr-x--- 1 oracle dba 8218 Jul 23 06:31 command_output_8385
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 diagnostics
drwxrwx--- 3 oracle dba 4096 Jul 23 06:31 ext
drwxr-x--- 2 oracle dba 4096 Jul 23 06:31 images
-rwxr-x--- 1 oracle dba 4855 Jul 23 06:31 installActions2001-07-23_06-31-05AM.log
drwxr-x--- 6 oracle dba 4096 Jul 23 06:31 jdk
drwxr-x--- 8 oracle dba 4096 Jul 23 06:31 oui
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 srvm
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ find ./ -name java
./jdk/jre/bin/java
./jdk/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/jre/bin/java
-rwxr-xr-x 1 oracle dba 66432 Jul 11 2011 ./jdk/jre/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/bin/java
-rwxr-x--- 1 oracle dba 66432 Jul 11 2011 ./jdk/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/jre/bin/java -version
-bash: ./jdk/jre/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/bin/java -version
-bash: ./jdk/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ grep tmp /etc/fstab
/dev/vgvolume/lv_tmp /tmp ext3 defaults,nodev,nosuid,noexec 1 2
/tmp /var/tmp none bind 0 0
tmpfs /dev/shm tmpfs defaults,nodev,nosuid,noexec 0 0
problem solved by following below URL
http://muthuappsdba.blogspot.sg/2013/02/error-in-createouiprocess-13-permission.html
http://pythianpang.wordpress.com/2010/06/03/oracle-runinstaller-createouiprocess-13-permission-denied/
http://kb.dbatoolz.com/tp/2817.error_in_createouiprocess_13.html
[oracle@test01 client]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 664 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2001-07-23_06-31-05AM. Please wait ...Error in CreateOUIProcess(): 13 : Permission denied
[oracle@test01 client]$ cd /tmp/OraInstall2001-07-23_06-31-05AM
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l
total 44
-rwxr-x--- 1 oracle dba 8218 Jul 23 06:31 command_output_8385
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 diagnostics
drwxrwx--- 3 oracle dba 4096 Jul 23 06:31 ext
drwxr-x--- 2 oracle dba 4096 Jul 23 06:31 images
-rwxr-x--- 1 oracle dba 4855 Jul 23 06:31 installActions2001-07-23_06-31-05AM.log
drwxr-x--- 6 oracle dba 4096 Jul 23 06:31 jdk
drwxr-x--- 8 oracle dba 4096 Jul 23 06:31 oui
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 srvm
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ find ./ -name java
./jdk/jre/bin/java
./jdk/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/jre/bin/java
-rwxr-xr-x 1 oracle dba 66432 Jul 11 2011 ./jdk/jre/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/bin/java
-rwxr-x--- 1 oracle dba 66432 Jul 11 2011 ./jdk/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/jre/bin/java -version
-bash: ./jdk/jre/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/bin/java -version
-bash: ./jdk/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ grep tmp /etc/fstab
/dev/vgvolume/lv_tmp /tmp ext3 defaults,nodev,nosuid,noexec 1 2
/tmp /var/tmp none bind 0 0
tmpfs /dev/shm tmpfs defaults,nodev,nosuid,noexec 0 0
problem solved by following below URL
http://muthuappsdba.blogspot.sg/2013/02/error-in-createouiprocess-13-permission.html
http://pythianpang.wordpress.com/2010/06/03/oracle-runinstaller-createouiprocess-13-permission-denied/
http://kb.dbatoolz.com/tp/2817.error_in_createouiprocess_13.html
Solution :
temporarily remove noexec option from /tmp
Or redirect TMP and TMPDIR environment variables to other
directory
Tuesday, October 22, 2013
Some info about initrans fround from blogs and Oracle docs
From internet blogs
When a session requires a slot but all the available ones are in use by other acve transacons, the database engine tries to dynamically create a new
slot. This is of course only possible when a) the maximum number of slots was not already allocated b) enough free space (one slot occupies 24 bytes) is
available in the block itself. If a new slot cannot be created, the session requiring it hits a so-called ITL wait. Note that the name of the actual wait event is
called “enq: TX – allocate ITL entry”.
It is essenal to point out that a session does not wait on the first slot becoming free. Instead, it probes, round-robin, the available slots to find out one
that becomes free. And, while doing so, it waits few seconds on every one it probes. When during this short wait the slot becomes free, it uses it.
Otherwise, it tries with another slot.
http://www.oracle-base.com/forums/viewtopic.php?f=1&t=4078 , says
Let's say you have a block that has five records in it. Let's also say that simultaneously five people update each of the records in the block. The block is taking part in 5 transactions. Space is required in the block to keep track of all this stuff. That's was these parameters are for. The initrans reserves a minimum amount of space in the block that can be used, the maxtrans specifies the maximum amount of space in the block that can be used to hold this information.
If you use locally managed tablespaces with automatic segment space management you can more or less forget about these parameters as Oracle takes care of it for you. In the past they were much more important that they are now.
Is above in red true ? Can experts advise ?
Searched from Entire Library of 11gR2 Oracle docs
Database Performance Tuning Guide
Data Guard Concepts and Administration
Troubleshooting ITL Pressure
Interested transaction list (ITL) pressure is reported in the alert log of the SQL Apply instance. Example A-3 shows an example of the warning messages.
...
Resolving ITL Pressure
To increase the
Database VLDB and Partitioning Guide
11g Release 2 (11.2)
Database Concepts
Entries in the ITL describe which transactions have rows locked and which rows in the block contain committed and uncommitted changes. The ITL points to the transaction table in the undo segment, which provides information about the timing of changes made to the database.
In a sense, the block header contains a recent history of transactions that affected each row in the block. The
Database Performance Tuning Guide
11g Release 2 (11.2)
If you are uncertain about which block size to choose, then try a database block size of 8 KB for most systems that process a large number of transactions. This represents a good compromise and is usually effective. Only systems processing LOB data need more than 8 KB.
When a session requires a slot but all the available ones are in use by other acve transacons, the database engine tries to dynamically create a new
slot. This is of course only possible when a) the maximum number of slots was not already allocated b) enough free space (one slot occupies 24 bytes) is
available in the block itself. If a new slot cannot be created, the session requiring it hits a so-called ITL wait. Note that the name of the actual wait event is
called “enq: TX – allocate ITL entry”.
It is essenal to point out that a session does not wait on the first slot becoming free. Instead, it probes, round-robin, the available slots to find out one
that becomes free. And, while doing so, it waits few seconds on every one it probes. When during this short wait the slot becomes free, it uses it.
Otherwise, it tries with another slot.
http://www.oracle-base.com/forums/viewtopic.php?f=1&t=4078 , says
Let's say you have a block that has five records in it. Let's also say that simultaneously five people update each of the records in the block. The block is taking part in 5 transactions. Space is required in the block to keep track of all this stuff. That's was these parameters are for. The initrans reserves a minimum amount of space in the block that can be used, the maxtrans specifies the maximum amount of space in the block that can be used to hold this information.
If you use locally managed tablespaces with automatic segment space management you can more or less forget about these parameters as Oracle takes care of it for you. In the past they were much more important that they are now.
Is above in red true ? Can experts advise ?
Searched from Entire Library of 11gR2 Oracle docs
Database Performance Tuning Guide
10 Instance Tuning Using Performance Views
-
Waits for TX in mode 4 can occur if the session is waiting for an ITL
(interested transaction list) slot in a block. This happens when the
session wants to lock a row in the block but one or more other sessions
have rows locked in the same block, and there is no free ITL slot in the
block. Usually, Oracle Database dynamically adds another ITL slot. This
may not be possible if there is insufficient free space in the block to
add an ITL. If so, the session waits for a slot with a TX enqueue in
mode 4. This type of TX enqueue wait corresponds to the wait event
enq:
TX
-
allocate
ITL
entry
.
The solution is to increase the number of ITLs available, either by changing theINITRANS
orMAXTRANS
for the table (either by using anALTER
statement, or by re-creating the table with the higher values).
Data Guard Concepts and Administration
A Troubleshooting Data Guard
Troubleshooting ITL Pressure
Interested transaction list (ITL) pressure is reported in the alert log of the SQL Apply instance. Example A-3 shows an example of the warning messages.
...
Resolving ITL Pressure
To increase the
INITRANS
integer for a particular database object, it is necessary to first stop SQL Apply.Database VLDB and Partitioning Guide
11g Release 2 (11.2)
Miscellaneous Parallel Execution Tuning Tips
Increasing INITRANS
If you have global indexes, a global index segment and global index blocks are shared by server processes of the same parallel DML statement. Even if the operations are not performed against the same row, the server processes can share the same index blocks. Each server transaction needs one transaction entry in the index block header before it can make changes to a block. Therefore, in theCREATE
INDEX
or ALTER
INDEX
statements, you should set INITRANS
,
the initial number of transactions allocated within each data block, to
a large value, such as the maximum DOP against this index.
Database Concepts
11g Release 2 (11.2)
9 Data Concurrency and Consistency
Read Consistency and Transaction Tables
The database uses information in the block header, also called an interested transaction list (ITL), to determine whether a transaction was uncommitted when the database began modifying the block. The block header of every segment block contains an ITL.Entries in the ITL describe which transactions have rows locked and which rows in the block contain committed and uncommitted changes. The ITL points to the transaction table in the undo segment, which provides information about the timing of changes made to the database.
In a sense, the block header contains a recent history of transactions that affected each row in the block. The
INITRANS
parameter of the CREATE
TABLE
and ALTER
TABLE
statements controls the amount of transaction history that is kept.Database Performance Tuning Guide
11g Release 2 (11.2)
8 I/O Configuration and Design
8.2.6.2 Writes
For high-concurrency OLTP systems, consider appropriate values forINITRANS
, MAXTRANS
, and FREELISTS
when using a larger block size. These parameters affect the degree of
update concurrency allowed within a block. However, you do not need to
specify the value for FREELISTS
when using automatic segment-space management.If you are uncertain about which block size to choose, then try a database block size of 8 KB for most systems that process a large number of transactions. This represents a good compromise and is usually effective. Only systems processing LOB data need more than 8 KB.
Object type of Foreign Key in DBMS_METADATA.GET_DDL
It is REF_CONSTRAINT for referential constraint, not CONSTRAINT
Wednesday, October 09, 2013
Forgot to backup REDO files for a NOARCHIVELOG database
1. startup database after restore from cold backup but failed.
testdb05d:/oradata/dmdb> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:21:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 30933094
Session ID: 254 Serial number: 3
SYS@dmdb> exit
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_lgwr_23199918.trc:
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_ora_30933094.trc:
ORA-00338: log 1 of thread is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
USER (ospid: 30933094): terminating the instance due to error 338
System state dump requested by (instance=1, osid=30933094), summary=[abnormal instance termination].
System State dumped to trace file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_diag_9502970.trc
Dumping diagnostic data in directory=[cdmp_20131002112203], requested by (instance=1, osid=30933094), summary=[abnormal insta
nce termination].
Instance terminated by USER, pid = 30933094
2. investigate and realized the cold backup set didn't include REDO files
testdb05d:/oralog/redo/dmdb> ls -l
total 2457696
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:48 redo_1a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:48 redo_1b_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:55 redo_2a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:55 redo_2b_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:33 redo_3a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:33 redo_3b_spda.log
testdb05d:/oralog/redo/dmdb> ps -fe |grep dmdb
oracle8 21758072 5505062 0 11:26:53 pts/0 0:00 grep dmdb
testdb05d:/oralog/redo/dmdb> df -k ./
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/oralog 5242880 4012868 24% 25 1% /oralog
3. continue to clear REDO files and succeeded.
testdb05d:/oralog/redo/dmdb> cd ..
testdb05d:/oralog/redo> ls
dmdb
testdb05d:/oralog/redo> mv dmdb dmdb_1002
testdb05d:/oralog/redo> mkdir dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:28:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
SYS@blus> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:29:00 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@dmdb> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
SYS@dmdb> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SYS@dmdb> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE#
---------------- ------------- ------------------- ------------
NEXT_TIME
-------------------
1 1 6070 209715200 512 2 NO
INACTIVE 3703950 2013-09-27 22:18:32 3704357
2013-09-27 22:33:33
3 1 6072 209715200 512 2 NO
CURRENT 3704765 2013-09-27 22:48:34 2.8147E+14
2 1 6071 209715200 512 2 NO
INACTIVE 3704357 2013-09-27 22:33:33 3704765
2013-09-27 22:48:34
SYS@dmdb> alter database clear logfile group 1;
Database altered.
SYS@dmdb> alter database clear logfile group 2;
Database altered.
SYS@dmdb> alter database clear logfile group 3;
Database altered.
SYS@dmdb> select member from V$logfile;
MEMBER
--------------------------------------------------------------------------------
/oralog/redo/dmdb/redo_1a_spda.log
/oralog/redo/dmdb/redo_1b_spda.log
/oralog/redo/dmdb/redo_2a_spda.log
/oralog/redo/dmdb/redo_2b_spda.log
/oralog/redo/dmdb/redo_3a_spda.log
/oralog/redo/dmdb/redo_3b_spda.log
6 rows selected.
SYS@dmdb> alter database open;
Database altered.
SYS@dmdb> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
Database opened.
SYS@dmdb> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> df -k /oralog
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/oralog 5242880 2784004 47% 32 1% /oralog
MMNL started with pid=16, OS id=24379452
ORACLE_BASE from environment = /oracle/product
Wed Oct 02 11:37:59 2013
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2345657111
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Oct 02 11:38:03 2013
ALTER DATABASE OPEN
Block change tracking file is current.
Thread 1 opened at log sequence 6074
Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Successful open of redo thread 1
Starting background process CTWR
Wed Oct 02 11:38:03 2013
CTWR started with pid=18, OS id=30933216
Block change tracking service is active.
SMON: enabling cache recovery
[13893792] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3198839111 end:3198839153 diff:42 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Oct 02 11:38:04 2013
QMNC started with pid=19, OS id=8323112
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Wed Oct 02 11:38:04 2013
CJQ0 started with pid=22, OS id=19988686
Incremental checkpoint up to RBA [0x17ba.f88e.0], current log tail at RBA [0x17ba.f8e2.0]
Wed Oct 02 11:38:34 2013
Thread 1 cannot allocate new log, sequence 6075
Private strand flush not complete
Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Beginning log switch checkpoint up to RBA [0x17bb.2.10], SCN: 3718854
Thread 1 advanced to log sequence 6075 (LGWR switch)
Current log# 3 seq# 6075 mem# 0: /oralog/redo/dmdb/redo_3a_spda.log
Current log# 3 seq# 6075 mem# 1: /oralog/redo/dmdb/redo_3b_spda.log
testdb05d:/oradata/dmdb> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:21:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 30933094
Session ID: 254 Serial number: 3
SYS@dmdb> exit
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_lgwr_23199918.trc:
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_ora_30933094.trc:
ORA-00338: log 1 of thread is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
USER (ospid: 30933094): terminating the instance due to error 338
System state dump requested by (instance=1, osid=30933094), summary=[abnormal instance termination].
System State dumped to trace file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_diag_9502970.trc
Dumping diagnostic data in directory=[cdmp_20131002112203], requested by (instance=1, osid=30933094), summary=[abnormal insta
nce termination].
Instance terminated by USER, pid = 30933094
2. investigate and realized the cold backup set didn't include REDO files
testdb05d:/oralog/redo/dmdb> ls -l
total 2457696
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:48 redo_1a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:48 redo_1b_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:55 redo_2a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:55 redo_2b_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:33 redo_3a_spda.log
-rw-rw---- 1 oracle8 dba 209715712 Oct 02 10:33 redo_3b_spda.log
testdb05d:/oralog/redo/dmdb> ps -fe |grep dmdb
oracle8 21758072 5505062 0 11:26:53 pts/0 0:00 grep dmdb
testdb05d:/oralog/redo/dmdb> df -k ./
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/oralog 5242880 4012868 24% 25 1% /oralog
3. continue to clear REDO files and succeeded.
testdb05d:/oralog/redo/dmdb> cd ..
testdb05d:/oralog/redo> ls
dmdb
testdb05d:/oralog/redo> mv dmdb dmdb_1002
testdb05d:/oralog/redo> mkdir dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:28:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
SYS@blus> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:29:00 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@dmdb> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
SYS@dmdb> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SYS@dmdb> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE#
---------------- ------------- ------------------- ------------
NEXT_TIME
-------------------
1 1 6070 209715200 512 2 NO
INACTIVE 3703950 2013-09-27 22:18:32 3704357
2013-09-27 22:33:33
3 1 6072 209715200 512 2 NO
CURRENT 3704765 2013-09-27 22:48:34 2.8147E+14
2 1 6071 209715200 512 2 NO
INACTIVE 3704357 2013-09-27 22:33:33 3704765
2013-09-27 22:48:34
SYS@dmdb> alter database clear logfile group 1;
Database altered.
SYS@dmdb> alter database clear logfile group 2;
Database altered.
SYS@dmdb> alter database clear logfile group 3;
Database altered.
SYS@dmdb> select member from V$logfile;
MEMBER
--------------------------------------------------------------------------------
/oralog/redo/dmdb/redo_1a_spda.log
/oralog/redo/dmdb/redo_1b_spda.log
/oralog/redo/dmdb/redo_2a_spda.log
/oralog/redo/dmdb/redo_2b_spda.log
/oralog/redo/dmdb/redo_3a_spda.log
/oralog/redo/dmdb/redo_3b_spda.log
6 rows selected.
SYS@dmdb> alter database open;
Database altered.
SYS@dmdb> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 638947328 bytes
Fixed Size 2224008 bytes
Variable Size 515899512 bytes
Database Buffers 104857600 bytes
Redo Buffers 15966208 bytes
Database mounted.
Database opened.
SYS@dmdb> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> df -k /oralog
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/oralog 5242880 2784004 47% 32 1% /oralog
MMNL started with pid=16, OS id=24379452
ORACLE_BASE from environment = /oracle/product
Wed Oct 02 11:37:59 2013
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 2345657111
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Oct 02 11:38:03 2013
ALTER DATABASE OPEN
Block change tracking file is current.
Thread 1 opened at log sequence 6074
Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Successful open of redo thread 1
Starting background process CTWR
Wed Oct 02 11:38:03 2013
CTWR started with pid=18, OS id=30933216
Block change tracking service is active.
SMON: enabling cache recovery
[13893792] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3198839111 end:3198839153 diff:42 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Oct 02 11:38:04 2013
QMNC started with pid=19, OS id=8323112
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Wed Oct 02 11:38:04 2013
CJQ0 started with pid=22, OS id=19988686
Incremental checkpoint up to RBA [0x17ba.f88e.0], current log tail at RBA [0x17ba.f8e2.0]
Wed Oct 02 11:38:34 2013
Thread 1 cannot allocate new log, sequence 6075
Private strand flush not complete
Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Beginning log switch checkpoint up to RBA [0x17bb.2.10], SCN: 3718854
Thread 1 advanced to log sequence 6075 (LGWR switch)
Current log# 3 seq# 6075 mem# 0: /oralog/redo/dmdb/redo_3a_spda.log
Current log# 3 seq# 6075 mem# 1: /oralog/redo/dmdb/redo_3b_spda.log
Monday, October 07, 2013
flashback db log size 3 times of AL size
interesting finding.
> du -sk *
10786344 archivelog
30174024 flashback
> ls -lR
total 48
drwxrwx--- 50 oracle1 dba1 8192 Oct 1 17:54 archivelog
drwxrwx--- 2 oracle1 dba1 16384 Oct 2 00:06 flashback
...
./archivelog/2013_10_01:
total 21572480
-rw-r----- 1 oracle1 dba1 1854297088 Oct 1 17:55 o1_mf_1_166081_94o6yvnp_.arc
-rw-r----- 1 oracle1 dba1 1819378688 Oct 1 17:56 o1_mf_1_166082_94o71ffv_.arc
-rw-r----- 1 oracle1 dba1 1821615104 Oct 1 17:58 o1_mf_1_166083_94o75onb_.arc
-rw-r----- 1 oracle1 dba1 1855338496 Oct 1 18:35 o1_mf_1_166084_94o9cf4t_.arc
-rw-r----- 1 oracle1 dba1 1833089024 Oct 1 19:15 o1_mf_1_166085_94oco8mm_.arc
-rw-r----- 1 oracle1 dba1 1861282816 Oct 1 19:30 o1_mf_1_166086_94odl28d_.arc
./flashback:
total 60348016
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94dzgovx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzgzbj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzh8rz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzhlfl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94dzhw0k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94dzj69y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94dzjj9z_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94dzjt58_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94dzk3nv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94dzkfrn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94dzkn9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94f001p7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:25 o1_mf_94f00c9r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 00:06 o1_mf_94f00nyx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f00vkj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01c1v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01njr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01v26_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f024kh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02c0j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02nm9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02v7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f034tl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03ck6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03oc2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03vxc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f045dx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f04cwq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f04ll8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94f04w2z_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94f052oc_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 1 19:01 o1_mf_94gndrfg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmmx3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmqnr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmyh1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpn5ls_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpnd9r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpnlxw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpnwoh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpo3cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpo9wk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpokfj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpor3v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpoyvc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpp8kv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpphnw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lppphc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lppxnb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpq7hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqbmy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqg40_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqj9t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqk7j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqn44_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqoh2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lpqr3t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lpqt1n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lqbnrh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3hls_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3pd8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3wyr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls43y6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls4c9p_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls4kwp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls95x6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lsyr3h_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ltpf7t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lttdcg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lttpcp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltww9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltx68t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltxp22_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltxzop_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94lty9d9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltyj7x_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltymtx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94lv20oq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2bh4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2k4o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2trd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv31g4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3c1p_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3no8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3vs9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv45r3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv4hjq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv4s86_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv52vy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5dlj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5mgy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5wyv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv66k9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv8rr2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv8zj7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv965y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvbc0w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvbtlh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvc4hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvcg2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvcnk7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvcv3r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvd1sm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvd8d9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdh8m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdp5q_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdwxc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvfdn1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvmt24_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsdob_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsmct_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsxgk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvt4rm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvtgx7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvtotj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lw81xf_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8cg2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8hk6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8sg1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx3t9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx3y66_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx8lo0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx8p0g_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8pd0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8trz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8yg6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx92b8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx95xp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx9hyv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lxdt6s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lxf42m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfghc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfo8n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfvqx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6z4ho_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6z9dy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6zjvm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7h8fh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7k1cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7kc2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7kv7r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7lqm1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7m4bt_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7mkcj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7n14o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7o9gk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7osd3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7pbdl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7pt7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94o7r52m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94o7rnwg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94o7s7lk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94o7t0sg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7tx2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7v72h_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7vmss_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7w3yc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7wjoh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7x0cd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7xf51_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7xqdy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7y7cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7yn2j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o7z3po_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o7zmjj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o800b0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o80jcy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o80xq9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:23 o1_mf_94o81fmy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:23 o1_mf_94o81xc5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o82b47_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o8363v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o83orx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o842fg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o84d43_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:25 o1_mf_94o88khc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 09:13 o1_mf_94o8p9nx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 11:09 o1_mf_94o8z5go_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8z9fd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zdx0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zjny_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8znpq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zs5j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o9007o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o906yr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o90fpd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o90qjk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91171_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91fyk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91qqg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o9220s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o92ct3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o92oh3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o92w6n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o93r23_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o93ysb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o945cp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o94h3k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:32 o1_mf_94o94p3y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:33 o1_mf_94o94zs5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:33 o1_mf_94o96q5k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94o970vx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94o977r8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94ob66mw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94ob6g0m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6ntq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6rdl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6zmw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob73by_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7c3w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7grs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7p29_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7wpp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob80fw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob872w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8bng_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8kdr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8o5j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8vxm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8zrd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob96bs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9f12_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9jod_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9q94_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9z2t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94obb2qg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obb9ol_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbfh4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbn36_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbqt5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbydv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obc21r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obc8sx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcddk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcm0x_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcplv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcxbl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obd12f_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obd7ob_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdgco_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdl6j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdrrb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdwm9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obf3hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obf7kz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfc68_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfktg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfokq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfw6l_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obfzqk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obg6f7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obg9xq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgjg3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgn25_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgqr1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgyov_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obh284_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obh605_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhdlp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhj7b_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhmt2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhtfb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obhy5w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obj4tm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obj8kq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objd7n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objj4v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objpr6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objtdb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk112_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk4qd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk8nj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obkh5c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obklv2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obkpm3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obkxc5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obl0xc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obl7sk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblcdp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblkwg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblohn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obls29_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obm00r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obm3lr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obmf2s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obmn5q_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obmrhy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obmw4j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn2t3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn6d7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn9wh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnjhn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnn70_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obntvo_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnyck_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obo1y3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obo8hf_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obod7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obolt4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obopp5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obotcn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obp12j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obp4ln_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpc3s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpgvs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpljj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpp72_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpwto_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obq0kz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obq44n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94obqbp5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94oco7k7_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 1 19:15 o1_mf_94ocoh4r_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 2 10:19 o1_mf_94owqsw7_.flb
> du -sk *
10786344 archivelog
30174024 flashback
> ls -lR
total 48
drwxrwx--- 50 oracle1 dba1 8192 Oct 1 17:54 archivelog
drwxrwx--- 2 oracle1 dba1 16384 Oct 2 00:06 flashback
...
./archivelog/2013_10_01:
total 21572480
-rw-r----- 1 oracle1 dba1 1854297088 Oct 1 17:55 o1_mf_1_166081_94o6yvnp_.arc
-rw-r----- 1 oracle1 dba1 1819378688 Oct 1 17:56 o1_mf_1_166082_94o71ffv_.arc
-rw-r----- 1 oracle1 dba1 1821615104 Oct 1 17:58 o1_mf_1_166083_94o75onb_.arc
-rw-r----- 1 oracle1 dba1 1855338496 Oct 1 18:35 o1_mf_1_166084_94o9cf4t_.arc
-rw-r----- 1 oracle1 dba1 1833089024 Oct 1 19:15 o1_mf_1_166085_94oco8mm_.arc
-rw-r----- 1 oracle1 dba1 1861282816 Oct 1 19:30 o1_mf_1_166086_94odl28d_.arc
./flashback:
total 60348016
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94dzgovx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzgzbj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzh8rz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94dzhlfl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94dzhw0k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94dzj69y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94dzjj9z_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94dzjt58_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94dzk3nv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94dzkfrn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94dzkn9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94f001p7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:25 o1_mf_94f00c9r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 00:06 o1_mf_94f00nyx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f00vkj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01c1v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01njr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f01v26_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f024kh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02c0j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02nm9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94f02v7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f034tl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03ck6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03oc2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f03vxc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f045dx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f04cwq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:00 o1_mf_94f04ll8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94f04w2z_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94f052oc_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 1 19:01 o1_mf_94gndrfg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmmx3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmqnr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpmyh1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpn5ls_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:01 o1_mf_94lpnd9r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpnlxw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpnwoh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpo3cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpo9wk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpokfj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpor3v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpoyvc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpp8kv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:02 o1_mf_94lpphnw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lppphc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lppxnb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpq7hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqbmy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqg40_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqj9t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqk7j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqn44_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:03 o1_mf_94lpqoh2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lpqr3t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lpqt1n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94lqbnrh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3hls_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3pd8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls3wyr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:04 o1_mf_94ls43y6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls4c9p_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls4kwp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ls95x6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lsyr3h_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94ltpf7t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lttdcg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:05 o1_mf_94lttpcp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltww9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltx68t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltxp22_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltxzop_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94lty9d9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltyj7x_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94ltymtx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:06 o1_mf_94lv20oq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2bh4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2k4o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv2trd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv31g4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3c1p_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3no8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv3vs9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:07 o1_mf_94lv45r3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv4hjq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv4s86_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv52vy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5dlj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5mgy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv5wyv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:08 o1_mf_94lv66k9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv8rr2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv8zj7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lv965y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvbc0w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvbtlh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvc4hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvcg2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:09 o1_mf_94lvcnk7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvcv3r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvd1sm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvd8d9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdh8m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdp5q_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvdwxc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvfdn1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:10 o1_mf_94lvmt24_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsdob_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsmct_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvsxgk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvt4rm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvtgx7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lvtotj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:11 o1_mf_94lw81xf_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8cg2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8hk6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lw8sg1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx3t9c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx3y66_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx8lo0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:12 o1_mf_94lx8p0g_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8pd0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8trz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx8yg6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx92b8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx95xp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lx9hyv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lxdt6s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:13 o1_mf_94lxf42m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfghc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfo8n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94ngfvqx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6z4ho_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6z9dy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94o6zjvm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7h8fh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7k1cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7kc2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7kv7r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7lqm1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7m4bt_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7mkcj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:15 o1_mf_94o7n14o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7o9gk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7osd3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7pbdl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:16 o1_mf_94o7pt7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94o7r52m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:17 o1_mf_94o7rnwg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94o7s7lk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:18 o1_mf_94o7t0sg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7tx2m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7v72h_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7vmss_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:19 o1_mf_94o7w3yc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7wjoh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7x0cd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:20 o1_mf_94o7xf51_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7xqdy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7y7cj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:21 o1_mf_94o7yn2j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o7z3po_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o7zmjj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o800b0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o80jcy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:22 o1_mf_94o80xq9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:23 o1_mf_94o81fmy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:23 o1_mf_94o81xc5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o82b47_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o8363v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o83orx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o842fg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:24 o1_mf_94o84d43_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:25 o1_mf_94o88khc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 09:13 o1_mf_94o8p9nx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 2 11:09 o1_mf_94o8z5go_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8z9fd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zdx0_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zjny_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8znpq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o8zs5j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o9007o_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o906yr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:29 o1_mf_94o90fpd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o90qjk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91171_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91fyk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o91qqg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o9220s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:30 o1_mf_94o92ct3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o92oh3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o92w6n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o93r23_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o93ysb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o945cp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:31 o1_mf_94o94h3k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:32 o1_mf_94o94p3y_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:33 o1_mf_94o94zs5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:33 o1_mf_94o96q5k_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94o970vx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94o977r8_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94ob66mw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:49 o1_mf_94ob6g0m_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6ntq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6rdl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob6zmw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob73by_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7c3w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7grs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7p29_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob7wpp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob80fw_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:50 o1_mf_94ob872w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8bng_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8kdr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8o5j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8vxm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob8zrd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob96bs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9f12_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9jod_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9q94_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94ob9z2t_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:51 o1_mf_94obb2qg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obb9ol_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbfh4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbn36_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbqt5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obbydv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obc21r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obc8sx_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcddk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcm0x_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcplv_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obcxbl_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:52 o1_mf_94obd12f_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obd7ob_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdgco_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdl6j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdrrb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obdwm9_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obf3hj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obf7kz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfc68_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfktg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfokq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:53 o1_mf_94obfw6l_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obfzqk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obg6f7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obg9xq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgjg3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgn25_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgqr1_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obgyov_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obh284_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obh605_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhdlp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhj7b_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhmt2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:54 o1_mf_94obhtfb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obhy5w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obj4tm_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obj8kq_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objd7n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objj4v_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objpr6_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94objtdb_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk112_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk4qd_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obk8nj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obkh5c_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obklv2_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:55 o1_mf_94obkpm3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obkxc5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obl0xc_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obl7sk_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblcdp_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblkwg_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94oblohn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obls29_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obm00r_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obm3lr_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obmf2s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:56 o1_mf_94obmn5q_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obmrhy_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obmw4j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn2t3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn6d7_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obn9wh_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnjhn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnn70_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obntvo_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obnyck_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obo1y3_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obo8hf_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:57 o1_mf_94obod7w_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obolt4_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obopp5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obotcn_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obp12j_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obp4ln_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpc3s_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpgvs_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpljj_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpp72_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obpwto_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obq0kz_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:58 o1_mf_94obq44n_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 18:59 o1_mf_94obqbp5_.flb
-rw-r----- 1 oracle1 dba1 99188736 Oct 1 19:14 o1_mf_94oco7k7_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 1 19:15 o1_mf_94ocoh4r_.flb
-rw-r----- 1 oracle1 dba1 49594368 Oct 2 10:19 o1_mf_94owqsw7_.flb
Wednesday, October 02, 2013
Tips of RMAN Fast Incremental backup
•Available
in Enterprise Edition Only
•Also
works with NOARCHIVELOG database, but needs MOUNT state
Subscribe to:
Posts (Atom)