MODE 150,300
ECHO ON
set ORACLE_SID=o920
H:
cd \Oracle\Admin\msora920\AdHoc
H:\Oracle\9.2.0\bin\sqlplus /nolog @o920shutdown.sql
COPY /V /Y /B H:\Oracle\Admin\msora920\PFile\*o920.ora H:\Oracle\Admin\msora920\PFile\Backup
COPY /V /Y /B I:\Oracle\OraData\msora920\*.* E:\Oracle\OraData\msora920\Backup
COPY /V /Y /B J:\Oracle\OraData\msora920\*.* F:\Oracle\OraData\msora920\Backup
COPY /V /Y /B K:\Oracle\OraData\msora920\*.* G:\Oracle\OraData\msora920\Backup
H:\Oracle\9.2.0\bin\sqlplus /nolog @o920startup.sql
PAUSE
o920shutdown.sql file: spool H:\Oracle\Admin\msora920\AdHoc\o920shutdown set echo off connect / as SYSDBA set echo on set trimspool on set pagesize 1000 set linesize 150 SELECT * FROM v$controlfile; SELECT * FROM v$logfile; SELECT * FROM v$datafile; SHUTDOWN NORMAL spool off exit
o920startup.sql file:
spool H:\Oracle\Admin\msora920\AdHoc\o920startup
set echo off
connect / as SYSDBA
set echo on
STARTUP MOUNT PFILE=H:\Oracle\9.2.0\database\inito920.ora
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
ALTER DATABASE BACKUP CONTROLFILE TO 'H:\Oracle\Admin\msora920\Control\Backup01o920.ctl' REUSE;
ARCHIVE LOG LIST
SHOW PARAMETER ARC
ALTER DATABASE OPEN;
spool off
exit
Note: the listener does not have to be shut down for a cold backup.
Have Fun :)
mike mon wrote:
Does anyone has NT cold backup script for ORACLE that
I can reference?
The script I need include :
shutdown listener shutdown service service shutdown DB backup files startup DB startup Service startup listener
Thanks.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
