RE: Automate startup -- archive/noarchivelog

Hi,

Essentially just run a sql script that does the job. My example is for NT but the same principle would apply for UNIX. You might choose to use an OPS$ account instead of hardcoding the password in the file

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

turn_off_archive.bat

echo.|time
set oracle_sid=abcd
svrmgrl @turn_off_archive.sql
echo.|time

turn_off_archive.sql

spool turn_off_archive.spool;
connect sys/pwd as sysdba;
shutdown immediate;
startup mount;
alter database noarchivelog;
archive log list;
alter database open;
spool off;

turn_on_archive.bat

echo.|time
set oracle_sid=abcd
svrmgrl @turn_on_archive.sql
echo.|time

turn_on_archive.sql

spool turn_on_archive.spool;
connect sys/abcd as sysdba;
shutdown immediate;
startup mount;
alter database archivelog;
archive log list;
alter database open;
spool off;

-----Original Message-----
From: cemail_at_sprintmail.com [mailto:cemail_at_sprintmail.com] Sent: Wednesday, 29 November 2000 11:01

Oracle 8.0.5/HPUX. I have a script that runs in cron that shuts down and starts up the database for backup. Does anybody have any scripts that will start it up, but in noarchivelog mode for data loads? Then after the load is done and the database has been shutdown again, is there anyway to have another script to start it up back in archivelog mode again? Is is possible to Received on Tue Nov 28 2000 - 18:12:31 CST