SQL BackTrack and Streams
571456Apr 16 2008 — edited Sep 23 2008We use SQL BackTrack for backing up all our databases. For our streams implementation we need to keep 7 days of archive logs on disk. SQL BackTrack will either delete or rename them. Setting rename_or_delete_logs keeps the archive logs for all instances on the host. The host is currently running multiple instances of Oracle where only one db is using streams.
My question: We need to keep the archive logs for 1 instance (the one using streams), and allow dtoarchmon to backup and delete the archive logs for the non-streams databases. Is this possible or must that database be on a separate host?