|
|
正好以前研究过
SQL> create table test.test as select * from all_objects ;
Table created.
SQL> insert into test.test select * from test.test ;
49840 rows created.
SQL> /
99680 rows created.
SQL> /
199360 rows created.
SQL> commit;
Commit complete.
SQL> drop table test.test ;
Table dropped.
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG .1 0 1
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> alter system switch logfile ;
System altered.
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 2.3 0 2
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> select owner,object_name,ts_name from dba_recyclebin order by droptime ;
OWNER OBJECT_NAME
------------------------------ ------------------------------
TS_NAME
------------------------------
TEST BIN$MJyuu8o5ZxvgQAB/AQAOxA==$0
TEST
TEST BIN$MJyuu8o6ZxvgQAB/AQAOxA==$0
TEST
TEST BIN$MJyuu8pAZxvgQAB/AQAOxA==$0
TEST
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@test02 u02]$
[oracle@test02 u02]$ rman target sys/oracle@db002
Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 17 05:48:31 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DB002 (DBID=908667212)
RMAN> backup database ;
Starting backup at 17-MAY-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=133 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/opt/oracle/oradata/db002/system01.dbf
input datafile fno=00003 name=/opt/oracle/oradata/db002/sysaux01.dbf
input datafile fno=00002 name=/opt/oracle/oradata/db002/undotbs01.dbf
input datafile fno=00005 name=/opt/oracle/oradata/db002/example01.dbf
input datafile fno=00006 name=/opt/oracle/oradata/db002/test01.dbf
input datafile fno=00004 name=/opt/oracle/oradata/db002/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-MAY-07
channel ORA_DISK_1: finished piece 1 at 17-MAY-07
piece handle=/u02/recovery/DB002/backupset/2007_05_17/o1_mf_nnndf_TAG20070517T054843_34pz1wmp_.bkp tag=TAG20070517T054843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:48
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 17-MAY-07
channel ORA_DISK_1: finished piece 1 at 17-MAY-07
piece handle=/u02/recovery/DB002/backupset/2007_05_17/o1_mf_ncsnf_TAG20070517T054843_34pz5cbx_.bkp tag=TAG20070517T054843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 17-MAY-07
RMAN> exit
Recovery Manager complete.
[oracle@test02 u02]$
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 2.3 2.3 2
BACKUPPIECE 43 0 2
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL>
backup use rman again ;
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 2.3 2.3 2
BACKUPPIECE 86 43 4
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL>
SQL> SELECT substr(name, 1, 30) name, space_limit AS quota,space_used AS used,
space_reclaimable AS reclaimable,number_of_files AS files
FROM v$recovery_file_dest ;
2 3
NAME QUOTA USED RECLAIMABLE FILES
------------------------------ ---------- ---------- ----------- ----------
/u02/recovery 2147483648 1896140288 972746240 6
SQL>
[oracle@test02 u02]$ rman target sys/oracle@db002
Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 17 06:06:45 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DB002 (DBID=908667212)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
..............................................
archive log filename=/u02/recovery/DB002/archivelog/2007_05_17/o1_mf_1_27_34px7p7g_.arc recid=26 stamp=622790264
Crosschecked 26 objects
RMAN>
RMAN> delete expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=153 devtype=DISK
specification does not match any archive log in the recovery catalog
RMAN> delete noprompt obsolete ;
delete expired backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
RMAN> exit
Recovery Manager complete.
[oracle@test02 u02]$
SQL> SELECT substr(name, 1, 30) name, space_limit AS quota,space_used AS used,
space_reclaimable AS reclaimable,number_of_files AS files
FROM v$recovery_file_dest ; 2 3
NAME QUOTA USED RECLAIMABLE FILES
------------------------------ ---------- ---------- ----------- ----------
/u02/recovery 2147483648 923394048 0 2
SQL>
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 0 0 0
BACKUPPIECE 43 0 2
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> |
|
楼主: patrickdong
IP卡
狗仔卡
发表于 2007-6-1 15:28
显身卡
楼主
