cpDbfFiles.txt
09-08-2001 Bikle
------------------

This file demonstrates how to copy data files from the primary
database to the standby database.  Since both databases are on the same host,
this step is very simple.  This task would be much more elaborate if the
databases resided on different hosts.

sf49er.bikle.com 2 % cd /u2/oracle
/u2/oracle
sf49er.bikle.com 3 % ls
./       817/     BBIKLE@  data/    jre/
../      ABIKLE@  admin/   exp/
sf49er.bikle.com 4 % cd data
/u2/oracle/data
sf49er.bikle.com 5 % ls
./       ../      ABIKLE/  BBIKLE/
sf49er.bikle.com 6 % ls ABIKLE
./                      ABIKLE_tools_01.dbf     redo02.log
../                     ABIKLE_users_01.dbf     redo03.log
ABIKLE_gendata_01.dbf   arch/                   system01.dbf
ABIKLE_rbs_01.dbf       control01.ctl
ABIKLE_temp_01.dbf      redo01.log
sf49er.bikle.com 7 % sqi

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Sep 8 14:35:43 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

14:35:43 SQL> select 'alter tablespace '||tablespace_name||' begin backup;' from dba_tablespaces;

'ALTERTABLESPACE'||TABLESPAC
----------------------------------------------------------------------------------------------
alter tablespace SYSTEM begin backup;
alter tablespace RBS begin backup;
alter tablespace TEMP begin backup;
alter tablespace TOOLS begin backup;
alter tablespace USERS begin backup;
alter tablespace GENDATA begin backup;

6 rows selected.

14:36:31 SQL> alter tablespace SYSTEM begin backup;

Tablespace altered.

14:36:52 SQL> alter tablespace RBS begin backup;

Tablespace altered.

14:36:58 SQL> alter tablespace TEMP begin backup;
alter tablespace TEMP begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE


14:37:04 SQL> alter tablespace TOOLS begin backup;

Tablespace altered.

14:37:11 SQL> alter tablespace USERS begin backup;

Tablespace altered.

14:37:18 SQL> alter tablespace GENDATA begin backup;

Tablespace altered.

14:37:23 SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
sf49er.bikle.com 8 % cp ABIKLE/*dbf BBIKLE
sf49er.bikle.com 9 % rm BBIKLE/ABIKLE_temp_01.dbf
sf49er.bikle.com 10 % cp ABIKLE/*log BBIKLE
sf49er.bikle.com 11 % sqi

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Sep 8 15:02:34 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

15:02:35 SQL> alter tablespace SYSTEM end backup;

Tablespace altered.

15:03:02 SQL> alter tablespace RBS end backup;

Tablespace altered.

15:03:14 SQL> alter tablespace TOOLS end backup;

Tablespace altered.

15:03:28 SQL> alter tablespace USERS end backup;

Tablespace altered.

15:03:38 SQL> alter tablespace GENDATA end backup;

Tablespace altered.

15:03:48 SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production