Oracle-L: HOT BACKUPS

From: Charlie Mengler <charliem_at_mwh.com>
Date: Thu, 07 Mar 2002 11:34:11 -0800
Message-ID: <F001.004225A9.20020307113411@fatcity.com>

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_at_pandora:/db02/oracle/oradata/CCC:263> svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

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: charliem_at_mwh.com

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: 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 Thu Mar 07 2002 - 13:34:11 CST