Ora-00257:archiver error. Connect internal only. Until freed

1,PLSQ Login Error

Ora-00257:archiver error. Connect internalonly. Until freed

2, Background alert log error:

[Email protected] ~]$ TAIL-FN 200/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.log

Tue APR 28 10:00:56 2015

Errors in FILE/ORACLE/APP/ORACLE/DIAG/RDBMS/PDUNQ/POWERDES/TRACE/POWERDES_ARC9_30051.TRC:

Ora-19815:warning:db_recovery_file_dest_size of 19327352832 bytes is 100.00% used, and have 0remaining bytes available.

************************************************************************

You have the following choices to free up spacefrom recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

Then consider changing RMAN ARCHIVELOG deletion POLICY.

2. Back up files to tertiary device such astape using RMAN

BACKUP RECOVERY Area Command.

3. ADD disk space and increasedb_recovery_file_dest_size parameter to

reflect the new space.

4. Delete unnecessary files using rmandelete command. If an operating

System command was used to the delete files, then use RMAN crosscheck and

DELETE EXPIRED Commands.

************************************************************************

Errors in FILE/ORACLE/APP/ORACLE/DIAG/RDBMS/PDUNQ/POWERDES/TRACE/POWERDES_ARC9_30051.TRC:

Ora-19809:limit exceeded for Recoveryfiles

Ora-19804:cannot Reclaim 31602688 Bytesdisk space from 19327352832 limit

Arc9:error 19809 Creating Archive log fileto '/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_28/o1_ Mf_1_75_%u_.arc '

--------------------------------------------------------------------------------------------------------------- -
< copyright, the article allows reprint, but must be linked to the source address, otherwise investigate legal liability!>
Original Blog Address: http://blog.csdn.net/mchdba/article/details/45332505
Hara Douglas Fir (MCHDBA)
--------------------------------------------------------------------------------------------------------------- -

3. View Archive logs

Rman> crosscheck Archivelog All; --First check the

...

Validation succeeded for archived log

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_72_bmkbwfrg_. arcrecid=63633 stamp=877796493

Validation succeeded for archived log

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_73_bmkyqplx_. arcrecid=63634 stamp=877816822

Validation succeeded for archived log

Archived log file NAME=/ORACLE/APP/ORACLE/FLASH_RECOVERY_AREA/PDUNQ/ARCHIVELOG/2015_04_23/O1_MF_1_74_BMKYSYSC_. arcrecid=63635 stamp=877816895

Crosschecked 1635 objects

See there are a lot of archived logs that are applied to sendary Library above.

4, here to delete the redundant archive log to operate, view the expired archive log

[[email protected] ~]$ Rman target/

rman> Delete expired Archivelog all;

Released Channel:ora_disk_1

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=787 Devicetype=disk

Specification does not match no archivedlog in the repository

Rman>

5. Delete the expired archive log

Delete Expired Archivelog all;

rman> Delete expired Archivelog all;

Released Channel:ora_disk_1

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=787 Devicetype=disk

Specification does not match no archivedlog in the repository

Rman>

See archived logs with no expiration

6, see there is no expiration, enough we can delete the specified time to the specific, so also make room to

Rman>delete Archivelog until Time "to_date (' 2015-04-27 13:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')";

The partial execution process is as follows:

rman-08137:warning:archived log notdeleted, needed for standby or upstream capture process

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_70_bmjfsm48_. Arcthread=1 sequence=70

rman-08137:warning:archived log notdeleted, needed for standby or upstream capture process

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_71_bmjk1mvp_. Arcthread=1 sequence=71

rman-08137:warning:archived log notdeleted, needed for standby or upstream capture process

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_72_bmkbwfrg_. Arcthread=1 sequence=72

rman-08137:warning:archived log notdeleted, needed for standby or upstream capture process

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_73_bmkyqplx_. Arcthread=1 sequence=73

rman-08137:warning:archived log notdeleted, needed for standby or upstream capture process

Archived log filename=/oracle/app/oracle/flash_recovery_area/pdunq/archivelog/2015_04_23/o1_mf_1_74_bmkysysc_. Arcthread=1 sequence=74

Rman>

SELECT * from V$flash_recovery_area_usage;

7, then go to see the use of space

sql> SELECT * Fromv$flash_recovery_area_usage;

File_type percent_space_usedpercent_space_reclaimable

-------------------- -------------------------------------------

Number_of_files

---------------

CONTROL FILE 0 0

0

REDO LOG 0 0

0

Archived LOG 74.36 0

1635

File_type percent_space_usedpercent_space_reclaimable

-------------------- -------------------------------------------

Number_of_files

---------------

BACKUP PIECE 25.5 0

7

IMAGE COPY 0 0

0

FLASHBACK LOG 0 0

0

File_type percent_space_usedpercent_space_reclaimable

-------------------- -------------------------------------------

Number_of_files

---------------

FOREIGN archived LOG 0 0

0

7 rows selected.

Sql>

OK, see the Archive log space using 74%, there is enough space, so you can log in use.

Re-login Plsql , or to report the same mistake.

8. Restart the Oracle service so that you can

sql> Shutdown Abort

ORACLE instance shut down.

Sql>

Sql> Startup

ORACLE instance started.

Total System Global area 3373858816 bytes

Fixed Size 2218032 bytes

Variable Size 1694500816 bytes

Database buffers 1660944384 bytes

Redo buffers 16195584 bytes

Database mounted.

Database opened.

Sql>

9, then log in using Plsql, and now you can log in normally.

Summary, because Oracle's Dataguard interrupted, so the primary on the archive log has been accumulated, resulting in a full archive of the space, so the database can not log in remotely, this time to use the common method may have the following 2:1): Delete the expired archive log according to the point of time ; 2) Increase the value of the db_recovery_file_dest_size.

Ora-00257:archiver error. Connect internal only. Until freed