this gonna bother me for a long time. I had my database running for about 2months, with little activity. Today, figure I be a little bold, and ran the catproc, with archive log mode. so my archive sequence went from 76-743.
My question is:
when will this number stop? and if I don't have a need for this archived, can I just blow it off, and will it come back and bite me in the buttox?
for example, can I go through these archive logs and del all the ones for today?
O.k This is what you got to do now. What kind of backup you folks do at your shop?
Shutsown the database, take a cold backup of the database, control file and other required files. Then start you instance back. Now you are safe to delete all the archives that had happen before the shutdown.
This is just to respond to the comment above that you shouldn't re-reun catproc subsequent to the initial run after instance creation. I believe you do actually need to rerun it if you are doing replication on your database. This may have changed with latter versions of Oracle - as with the previous poster, do contradict me if this is wrong.