Re: [Q] anyone has ORACLE cold backup script for NT?

From: Chip <ocp-dba_at_earthlink.net>
Date: Thu, 14 Aug 2003 21:24:22 -0800
Message-ID: <F001.005CAC02.20030814212422@fatcity.com>

cold_backup_o920.cmd file (manually executed after verifying no users/jobs in database):
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: ocp-dba_at_earthlink.net

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: ListGuru_at_fatcity.com (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).

Received on Fri Aug 15 2003 - 00:24:22 CDT