An Oracle database connection is prompted with a ora-00257 error that indicates that the database archive log archive failed

Turn http://jingyan.baidu.com/article/425e69e6b142d1be15fc16dc.html

• Microsoft Windows [version 6.1.7600]
  Copyright (c) Microsoft Corporation. All rights reserved.

  C:\users\administrator>tnsping

  TNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 1 September-August-
  2017 11:52:53

  Copyright (c) 1997, 2005, Oracle. All rights reserved.

  TNS-03502: Insufficient parameters. Usage: tnsping <address> [<count>]

  C:\users\administrator>tnsping HZXM

  TNS Ping Utility for 32-bit windows:version 10.2.0.1.0-production on 1 September-August-
  2017 11:53:07

  Copyright (c) 1997, 2005, Oracle. All rights reserved.

  Used parameter file:
  D:\oracle\10.2.0\db_1\network\admin\sqlnet.ora

  
  Used the TNSNames adapter to resolve aliases
  Attempting to contact (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP)
  (HOST = 192.168.254.11) (PORT = 1521))) (Connect_data = (SERVER = dedicated) (SER
  Vice_name = HZXM)))
  OK (30 milliseconds)

  C:\users\administrator>set
  Allusersprofile=c:\programdata
  Appdata=c:\users\administrator\appdata\roaming
  Classpath=.; C:\Program Files\java\jdk1.6.0_43\lib\dt.jar; C:\Program files\java\j
  Dk1.6.0_43\lib\tools.jar;
  Clientname=m490_2
  Commonprogramfiles=c:\program Files\Common Files
  CommonProgramFiles (x86) =c:\program files (x86) \common files
  Commonprogramw6432=c:\program Files\Common Files
  Computername=dbserver2
  Comspec=c:\windows\system32\cmd.exe
  Fp_no_host_check=no
  Homedrive=c:
  Homepath=\users\administrator
  Java_home=c:\program files\java\jdk1.6.0_43
  Localappdata=c:\users\administrator\appdata\local
  Logonserver=\\dbserver2
  Number_of_processors=32
  Oracle_home=d:\oracle\10.2.0\db_1
  Oracle_sid=hzxm
  Os=windows_nt
  Path=d:\oracle\10.2.0\client_2\bin;d:\oracle\10.2.0\db_1\bin; C:\Program Files\ja
  Va\jdk1.6.0_43\bin; C:\Windows\system32; C:\Windows; C:\Windows\System32\Wbem; C:\Wi
  Ndows\system32\windowspowershell\v1.0\
  pathext=.com;. EXE;. BAT;. CMD;. VBS;. VBE;. JS;. JSE;. WSF;. WSH;. MSC
  Perl5lib=d:\oracle\10.2.0\db_1\perl\5.8.3\lib\mswin32-x86;d:\oracle\10.2.0\db_1\
  perl\5.8.3\lib;d:\oracle\10.2.0\db_1\perl\5.8.3\lib\mswin32-x86;d:\oracle\10.2.0
  \db_1\perl\site\5.8.3;d:\oracle\10.2.0\db_1\perl\site\5.8.3\lib;d:\oracle\10.2.0
  \db_1\sysman\admin\scripts;
  Processor_architecture=amd64
  Processor_identifier=intel64 Family 6 Model stepping 2, Genuineintel
  Processor_level=6
  Processor_revision=3f02
  Programdata=c:\programdata
  Programfiles=c:\program Files
  ProgramFiles (x86) =c:\program Files (x86)
  Programw6432=c:\program Files
  prompt= $P $g
  Psmodulepath=c:\windows\system32\windowspowershell\v1.0\modules\
  Public=c:\users\public
  Sessionname=rdp-tcp#0
  Systemdrive=c:
  Systemroot=c:\windows
  Temp=c:\users\admini~1\appdata\local\temp\2
  Tmp=c:\users\admini~1\appdata\local\temp\2
  Userdomain=dbserver2
  Username=administrator
  Userprofile=c:\users\administrator
  Windir=c:\windows

  C:\users\administrator>sqlplus/nolog

  Sql*plus:release 10.2.0.1.0-production on Saturday August 19 11:53:56 2017

  Copyright (c) 1982, 2005, Oracle. All rights reserved.

  Sql> Connect/as SYSDBA
  is connected.
  Sql> SELECT * from V$flass_recovery_area_usage
  2;
  SELECT * FROM V$flass_recovery_area_usage
  *
  An error occurred on line 1th:
  ORA-00942: Table or view does not exist

  
  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 99.93 0 913
  Backuppiece 0 0 0
  Imagecopy 0 0 0
  Flashbacklog 0 0 0

  6 rows have been selected.

  sql> select sum (percent_space_used) *3/100 from V$flash_recovery_area_usage;

  SUM (percent_space_used) *3/100
  -----------------------------
  2.9979

  Sql> show parameter recover;

  NAME TYPE VALUE
  ------------------------------------ ----------- ------------------------------
  Db_recovery_file_dest string D:\oracle\10.2.0\flash_recover
  Y_area
  Db_recovery_file_dest_size Big Integer 40G
  Recovery_parallelism integer 0
  sql> Rman Target Sys/pass
  sp2-0734: Unknown command at the beginning of "Rman targe ..."-Ignores the remaining lines.
  sql> Rman Target sys/pass/
  sp2-0734: Unknown command at the beginning of "Rman targe ..."-Ignores the remaining lines.
  sql> Rman Target Sys/pass;
  sp2-0734: Unknown command at the beginning of "Rman targe ..."-Ignores the remaining lines.
  Sql> Rman
  sp2-0042: Unknown Command "Rman"-the remaining rows are ignored.
  sp2-0044: To get a list of known commands, enter help;
  Enter Exit to exit.
  Sql> RMAN;
  sp2-0042: Unknown Command "RMAN"-the remaining rows are ignored.
  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. 33 0 3
  Backuppiece 0 0 0
  Imagecopy 0 0 0
  Flashbacklog 0 0 0

  6 rows have been selected.

  Sql>

• Delete the useless archivelog. Enter Rman, commands such as: See how many useless log files, commands such as: delete action!

• My this action is even today's log will be deleted, to delete when the log or to see the system itself.

• Deletion of expired log! The command is to delete the expired log, without specifying a date.

After deletion, only 0.33% of the occupied space is displayed,

An Oracle database connection is prompted with a ora-00257 error that indicates that the database archive log archive failed