BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 85.68M DISK 00:00:11 06-JUL-15
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: USERS
Piece Name: /veris/np/oracle/app/oracle/man_recovery_area/ORCL/09qbc3q7_1_1
Keep: BACKUP_LOGS Until: FOREVER
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 93588703 06-JUL-15 /veris/np/oracle/app/oracle/oradata/orcl/users01.dbf
14 Full 93588703 06-JUL-15 /veris/np/oracle/app/oracle/oradata/orcl/users02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 80.00K DISK 00:00:01 06-JUL-15
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: USERS
Piece Name: /veris/np/oracle/app/oracle/man_recovery_area/ORCL/0aqbc3qo_1_1
Keep: BACKUP_LOGS Until: FOREVER
SPFILE Included: Modification time: 13-MAY-15
SPFILE db_unique_name: ORCL
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 8.00K DISK 00:00:00 06-JUL-15
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: USERS
Piece Name: /veris/np/oracle/app/oracle/man_recovery_area/ORCL/0bqbc3rg_1_1
Keep: BACKUP_LOGS Until: FOREVER
List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 2025 93588677 06-JUL-15 93588716 06-JUL-15
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 9.33M DISK 00:00:02 06-JUL-15
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: USERS
Piece Name: /veris/np/oracle/app/oracle/man_recovery_area/ORCL/0cqbc3rj_1_1
Keep: BACKUP_LOGS Until: FOREVER
Control File Included: Ckp SCN: 93588818 Ckp time: 06-JUL-15
*****************************************************************************************************
SQL> select * from dba_tablespaces;
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG PREDICA ENC COMPRESS_FOR
------------------------------ ---------- -------------- ----------- ----------- ----------- ---------- ------------ ---------- --------- --------- --------- --- ---------- --------- --- ------ -------- ----------- --- ------- --- ------------------------------------
SYSTEM 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO
SYSAUX 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
UNDOTBS1 8192 65536 1 2147483645 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO
TEMP 8192 1048576 1048576 1 2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO
USERS 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO
EXAMPLE 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT NOLOGGING NO LOCAL SYSTEM YES AUTO DISABLED NOT APPLY NO HOST NO
发表于 2015-7-7 16:19:40
