how to check archive log destination size in oracle

Tags: sys source har Select where profile exe let. sh Recently do a DG archive log Delete,[Email protected] logs]crontab-l * 8 * * * sh/home/oracle/dbscripts/del_arc.sh The script calls generate delete checksum three scripts respectivelyCat del_arc.sh #!/bin/bash source/home/oracle/.bash_profile sh/home/

432.63 57% 167 1%/rman_db2_bk/Dev/lv_zs_bck_01 2992.00 1836.57 39% 224/rman_data/Dev/lv_cdump 200.00 199.97 1% 15 1%/oracle10g/app/oracle/admin/zgscdb/cdump/Dev/lv_dsg1 49.75 43.97 12% 8831 1%/dsg1Fjlt_zgsc_db02:/arch_log/zgsc_db02_arch 997.00 971.00 3% 34 1%/arch_log/zgsc_db02_arch The free space in the/arch_log mount point is close to 1 Tb. The target restores the archived log to/arch_log/restore. Firs

1. Landing Rman with Oracle usersrman>RMAN target/2. List and confirm the archive log pathrman>list archivelog all;3. Delete archived logs from 7 days agorman> DELETE ARCHIVELOG all completed before ' SYSDATE-7 ';DescriptionSYSDATA-7, which indicates that the current system time is 7 days ago, the Before keyword represents the

-X86_64NBSP;ERROR:NBSP;2: Nosuchfileordirectory additionalinformation:3 SQL>alterdatabaseopenresetlogs; --First Step alterdatabaseopenresetlogs* erroratline1: ORA-01139:RESETLOGSoptiononlyvalidafteranincomplete databaserecoverysql>recoverdatabaseusingbackupcontrolfile;-- Step Two ora-00279:change1384991generatedat05/22/201620:05:08needed forthread1ora-00289:suggestion:/ora/app/oracle/flash_recovery_area/orcl/archivelog/2016_05_22/o1_mf_1_12_%u_. arc

Oracle's database operations are recorded in the redo log for undo (rollback) or redo (redo) at the time of the database exception. Redo log is also divided into online (online log) and archive (archive log) two parts.Oracle has 3

View Archive sql> archive log list; Database log mode archive mode AutoArchive enable archive endpoint use_db_recovery_file_dest the oldest online log

Label:Recording Head (record header) format: typedefstructrh0 {uint32_t recordlen; uint8_t VLD; //directly determines the entire record head size uint8_t Unknown0; uint16_t Rhscnwrapper; uint32_t rhscnbase; uint16_t SUBSCN; }redo_rh0; typedefstructRh1 {uint8_t unknown1[Ten]; }redo_rh24; //VLD = 0x01, total size 24byte typedefstructRh5 {uint8_t unknown0[ -]; uint32_t Rhscntime;

Oracle Database error Ora-00257:archiver error. Connect internal only, until freed, how to solve it? This issue is located in the archive log full, the following is a summary of the specific solutions to share. Solution: Sql> select * from V$flash_recovery_area_usage; --View archived content usageFile_type percent_space_used percent_space_reclaimable Number_of_

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble,

Label:Sets the method for archiving. 1 sql> archive log list; #查看是不是归档方式 2 sql> alter system set LOG_ARCHIVE_START=TRUE Scope=spfile; #启用主动归档Sql> alter system set log_archive_dest= "Location=/oracle/ora9/oradata/arch" scope=spfile;#设置归档路径Sql> alter system set log_archive_dest_1= "Location=/oracle/ora9/oradata/arch1" sc

Tags: ora-19571First, use the following command to clean up the space:1. Cd/orabak 2.Find. -type f-mtime +30-exec rm-rf {} \;Second, then began to use the Rman backup script for backup, back to the last occurrence of the following error------------------------------------------------------------------------- ------------------archivelogfilename=/oralog/1_20800_812554797.dbfrecid=20799stamp= 839154512 archivelogfilename=/oralog/1_20801_812554797.dbfrecid=20800stamp=839154513 Releasedchannel:ch1 r

Tags: Oracle failed target Cleanup archive logCreating a script filevim/home/oracle/script/rmanclear.sh#!/bin/bashDate= ' Date ' +%y-%m-%d "'/u01/app/oracle/product/db/bin/rman Target sys/oracle Crosscheck Archivelog All;Delete noprompt expired archivelog all;Delete noprompt

to see if an Oracle database is in archive mode Sql> select Name,log_mode from V$database; NAME Log_mode ------------------ ------------------------ TEST Noarchivelog Sql> Archive Log List Database log mode No Archive mode Auto

Always feel that using Windows to run Oracle is not reliable thing, can this world there are always a lot of people like to do things like this, for the database more common two things: Rman and delete the DG Standby archive log, on the Linux/unix platform using shell implementation is very simple, But ran to win inside, became vexed, not because of the trouble,

Tags: Oracle monitor archive fullOracle Data monitoring hangs The restart method:--Monitoringlsnrctl Start-- A slight delay after startup to take effectLsnrctl statusLsnrctl stop--strong kill MonitorPs-ef|grep LsnrctlPs-ef|grep tnslsnr|grep-v "grep"kill-9 the number in frontOracle Database Archive Log full, delete

;ArchiveLoglist; #查看是否是归档方式2Sql> AlterSystemSetLog_archive_start=False scope=SPFile; #禁用自动归档3Sql> shutdownimmediate; 4Sql>startup Mount; #打开控制文件, do not open the data file5Sql> Alter DatabaseNoarchivelog; #将数据库切换为非归档模式6Sql> Alter Database Open; #将数据文件打开7Sql>ArchiveLogList #查看此时便处于非归档模式Three-Archive related commands Log stop; Log start;

Tags: before delete archivelogThis article is an original article,Reprint please indicate the sourcehttp://blog.csdn.net/msdnchina/article/details/41413313To delete an archive log, you need to confirm several points in advance:1. Whether it is a DG environment: if the DG Environment, you need to confirm that the archive log