Originally posted by mickykt
Hai ,thanks for the responce.
But when i check the archive destination it always shows no file..When i check the v$archived_log file i get a whole list of files that have been archived.
actually where are these files archived to.
Daily i have a backup that archive the archive log files and deletes them.But what about the archive files created after the backup and the next backup.they should be there.
I am a bit confused
I supouse you have check that your instance is runnign in archivelog mode, aren't you? (check v$instance or V$database)
If your database is running in archivelog mode, You can test this and check where the archive logs are:
-show parameter archivelog_dest
Force a change of active redo logfile:
- alter system switch logfile;
Lock at the archivelog primary destination becouse the archivelog must be there.