Hello friends,
I have just realised that 2 databases that I have inhereted has a srcipt that is used to shut the database down everyday with the abort option.
I have asked everybody but no one seems to be able to tell me why the abort option is being used? The dba that I inhereted the database from was a pretty good one so I can't imagine why the abort option is being used insted of the immediate option. I am thinking about changing the script but I am wondering if it's going to have a negative impact since I don't know why the abort option was chosen instead of the immediate option.

Question 1 .I know this is "crazy" question but can anybody imagine why the abort option is used instead of immediate for every day shut down?

Question 2. Can any body tell me the disadvantges involved in shutting down the database with an abort option before a backup is done? 2 of the databases are in archive log mode and 2 are in no achive log mode.

NOTE: I have tried to contact the old DBA but with no success.

thanks,
charity