Here is what worked for me this morning. + sqlplus -s + 0<< sys/syss set pause off feedback off pages 0 echo off spool CCC_begin_hot_backups.sql SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' BEGIN BACKUP;' FROM DBA_TABLESPACES;
SPOOL OFF @CCC_begin_hot_backups.sql EXIT ALTER TABLESPACE SYSTEM BEGIN BACKUP; ALTER TABLESPACE TOOLS BEGIN BACKUP; ALTER TABLESPACE TEMP BEGIN BACKUP; ALTER TABLESPACE DATA BEGIN BACKUP; ALTER TABLESPACE USERS BEGIN BACKUP; ALTER TABLESPACE INDX BEGIN BACKUP; ALTER TABLESPACE RBS1 BEGIN BACKUP; ALTER TABLESPACE RBS BEGIN BACKUP; + exit + date Thu Mar 7 07:05:05 PST 2002 + rcp /db01/oracle/oradata/CCC/data01.dbf pandora:/db01/oracle/oradata/CCC/data01.dbf + rcp /db01/oracle/oradata/CCC/rbs01.dbf pandora:/db01/oracle/oradata/CCC/rbs01.dbf + rcp /db01/oracle/oradata/CCC/system01.dbf +pandora:/db01/oracle/oradata/CCC/system01.dbf + rcp /db01/oracle/oradata/CCC/temp01.dbf pandora:/db01/oracle/oradata/CCC/temp01.dbf + rcp /db01/oracle/oradata/CCC/tools01.dbf pandora:/db01/oracle/oradata/CCC/tools01.dbf + rcp /db01/oracle/oradata/CCC/users01.dbf pandora:/db01/oracle/oradata/CCC/users01.dbf + rcp /db02/oracle/oradata/CCC/rbs.dbf pandora:/db02/oracle/oradata/CCC/rbs.dbf + rcp /db02/oracle/oradata/CCC/redo04.log pandora:/db02/oracle/oradata/CCC/redo04.log + rcp /db02/oracle/oradata/CCC/redo05.log pandora:/db02/oracle/oradata/CCC/redo05.log + rcp /db02/oracle/oradata/CCC/redo06.log pandora:/db02/oracle/oradata/CCC/redo06.log + rcp /db02/oracle/oradata/CCC/temp02.dbf pandora:/db02/oracle/oradata/CCC/temp02.dbf + rcp /db02/oracle/oradata/CCC/users02.dbf pandora:/db02/oracle/oradata/CCC/users02.dbf + rcp /u01/app/oracle/oradata/CCC/control01.ctl +pandora:/u01/app/oracle/oradata/CCC/control01.ctl + rcp /u01/app/oracle/oradata/CCC/control02.ctl +pandora:/u01/app/oracle/oradata/CCC/control02.ctl + rcp /u01/app/oracle/oradata/CCC/control03.ctl +pandora:/u01/app/oracle/oradata/CCC/control03.ctl + rcp /db02/oracle/oradata/CCC/indx01.dbf pandora:/db02/oracle/oradata/CCC/indx01.dbf + date Thu Mar 7 07:53:58 PST 2002 + sqlplus -s + 0<< username/password set pause off feedback off pages 0 echo off spool CCC_end_hot_backups.sql SELECT 'ALTER TABLESPACE ' || TABLESPACE_NAME || ' END BACKUP;' FROM DBA_TABLESPACES; SPOOL OFF @CCC_end_hot_backups.sql ALTER SYSTEM CHECKPOINT; HOST sleep 8 EXIT ALTER TABLESPACE SYSTEM END BACKUP; ALTER TABLESPACE TOOLS END BACKUP; ALTER TABLESPACE TEMP END BACKUP; ALTER TABLESPACE DATA END BACKUP; ALTER TABLESPACE USERS END BACKUP; ALTER TABLESPACE INDX END BACKUP; ALTER TABLESPACE RBS1 END BACKUP; ALTER TABLESPACE RBS END BACKUP; + date Thu Mar 7 07:56:13 PST 2002 + rcp /db02/oracle/oradata/CCC/redo04.log pandora:/db02/oracle/oradata/CCC/redo04.log + rcp /db02/oracle/oradata/CCC/redo05.log pandora:/db02/oracle/oradata/CCC/redo05.log + rcp /db02/oracle/oradata/CCC/redo06.log pandora:/db02/oracle/oradata/CCC/redo06.log + date Thu Mar 7 07:58:25 PST 2002 + exit <oracle@pandora:/db02/oracle/oradata/CCC:263> svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production With the Partitioning option JServer Release 8.1.6.3.0 - Production SVRMGR> connect internal Connected. SVRMGR> startup ORACLE instance started. Total System Global Area 374050496 bytes Fixed Size 69312 bytes Variable Size 105267200 bytes Database Buffers 268435456 bytes Redo Buffers 278528 bytes Database mounted. ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/db01/oracle/oradata/CCC/system01.dbf' SVRMGR> alter database recover; Statement processed. SVRMGR> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SVRMGR> startup ORACLE instance started. Total System Global Area 374050496 bytes Fixed Size 69312 bytes Variable Size 105267200 bytes Database Buffers 268435456 bytes Redo Buffers 278528 bytes Database mounted. Database opened. SVRMGR> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).