Shulou(Shulou.com)06/01 Report--

Archival document management

Oracle archived files are often full or can not be mounted. Here is a brief introduction to a full case.

Backup archive file: Backup archivelog all

Backup archive log

1. Sql > alter system archive logcurrent; to archive the current log

2. Sql > show parameter archive; to view the archive directory

3. Rman > backup archivelog all; backup and archiving

Rman > backup archivelog all delete allinput; delete archive after backup

Rman > backup database plus archivelog; backup database and archive log

Archival document management

SQL > select * from vault log; archive status

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-

FIRST_CHANGE# FIRST_TIME

1 1 5638 52428800 1 NO INACTIVE 1.2895E+13 26-JUL-14

2 1 5639 5242880 1 NO CURRENT 1.2895E+13 26-JUL-14

4 1 5635 10485760 1 NO INACTIVE 1.2895E+13 25-JUL-14

SQL > select * from vested recovery fileholders destinations; archive size

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

/ home/oracle/flash_recovery_area 21474836482133713408 0 23

SQL > select * from vastly flashworthy recovery of space usage, archive backup close to 100%

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

-

CONTROLFILE 0 0 0

ONLINELOG 4.88 0 1

ARCHIVELOG 27.62 0 19

BACKUPPIECE 66.86 0 3

IMAGECOPY 0 0 0

FLASHBACKLOG 0 0 0

6 rows selected.

SQL > alter system set db_recovery_file_dest_size=10g

System altered.

SQL > select * from v$recovery_file_dest

NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES

/ home/oracle/flash_recovery_area 1.0737E+10 2234790400 0 26

SQL > select * from v$flash_recovery_area_usage

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

-

CONTROLFILE 0 0 0

ONLINELOG. 98 0 1

ARCHIVELOG 6.47 0 22

BACKUPPIECE 13.37 0 3

IMAGECOPY 0 0 0

FLASHBACKLOG 0 0 0

6 rows selected.

Rman > backup database plus archivelogdelete input; backs up the database and archive logs and deletes the backed up archive logs

Rman > backup archivelog from sequence 79until sequance 82; according to serial number

Rman > backup archivelog from time "sysdate-15" until time "sysdate-7"; backup log archived 15 to 7 days ago

4. Sql > alter system archive logcurrent; do log archiving again, and log during archiving

Rman > list archivelog all

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.