Re: ORACLE Backups

From: RSCary <rscary_at_aol.com>
Date: 18 Aug 1994 02:09:02 -0400
Message-ID: <32uttu$5h_at_search01.news.aol.com>

I'm not sure if I've seen all the messages in this thread but I haven't seen a suggestion for using the IDLE_TIME timeout parameter in the profile. You can set an idle time timeout to disconnect users after 1 or 2 hours of inactivity and have your backup at an appropriate time after the last users are expected to quit working. Of course this will not work if you have night owls on your database.

I haven't tried this but it might work. Set your IDLE_TIME parameter in all profiles to 1 hour. Execute a shutdown normal which will keep new users from connecting. See if the shutdown completes 1 hour after the last user is active on the database. If this works it might be a solution for some cases to start backups after midnight.

Scott Cary Received on Thu Aug 18 1994 - 08:09:02 CEST

This message: [ Message body ]
Next message: wareing pti: "Re: Is this stuff really SQL 92 compliant"
Previous message: B C Zygmunt: "Re: ORACLE Backups"
Maybe in reply to: Jim Gehl: "ORACLE Backups"
Next in thread: wareing pti: "Re: Is this stuff really SQL 92 compliant"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message