temp tablespace generation

Location : /u01/home/oracle/admin/XEROXDEV/udump

CREATE CONTROLFILE REUSE DATABASE "XEROXDEV" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 256
MAXINSTANCES 1
MAXLOGHISTORY 10890
LOGFILE
GROUP 5 (
'/u01/oradata/XEROXDEV/redo05a.log',
'/u01/oradata/XEROXDEVredo05b.log'
) SIZE 10M,
GROUP 6 (
'/u01/oradata/XEROXDEV/redo06a.log',
'/u01/oradata/XEROXDEVredo06b.log'
) SIZE 10M,
GROUP 7 (
'/u01/oradata/XEROXDEV/redo07a.log',
'/u01/oradata/XEROXDEVredo07b.log'
) SIZE 10M,
GROUP 8 (
'/u01/oradata/XEROXDEV/redo08a.log',
'/u01/oradata/XEROXDEVredo08b.log'
) SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'/u01/oradata/XEROXDEV/system01.dbf',
'/u01/oradata/XEROXDEV/general_data01.dbf',
'/u01/oradata/XEROXDEV/xerox_cc01.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414.dbf',
'/u01/oradata/XEROXDEV/ext414.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_02.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_03.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_04.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_05.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_06.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_07.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_08.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_09.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_10.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_11.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_12.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_13.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_14.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_15.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_16.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_17.dbf',
'/u01/oradata/XEROXDEV/xerox_ext414_18.dbf',
'/u01/oradata/XEROXDEV/users01.dbf',
'/u01/oradata/XEROXDEV/TSAP2.idx',
'/u01/oradata/XEROXDEV/undotbs2_01.dbf',
'/u01/oradata/XEROXDEV/general_index01.dbf',
'/u01/oradata/XEROXDEV/inventory_data01.dbf',
'/u01/oradata/XEROXDEV/inventory_index01.dbf',
'/u01/oradata/XEROXDEV/order_data01.dbf',
'/u01/oradata/XEROXDEV/order_index01.dbf',
'/u01/oradata/XEROXDEV/pbe_data01.dbf',
'/u01/oradata/XEROXDEV/pbe_index01.dbf',
'/u01/oradata/XEROXDEV/security_data01.dbf',
'/u01/oradata/XEROXDEV/security_index01.dbf',
'/u01/oradata/XEROXDEV/tp_data01.dbf',
'/u01/oradata/XEROXDEV/tp_index01.dbf',
'/u01/oradata/XEROXDEV/trx_log_data_part01.dbf',
'/u01/oradata/XEROXDEV/trx_log_data_part02.dbf',
'/u01/oradata/XEROXDEV/trx_log_data_part03.dbf',
'/u01/oradata/XEROXDEV/trx_log_data_part04.dbf',
'/u01/oradata/XEROXDEV/trx_log_index_part01.dbf',
'/u01/oradata/XEROXDEV/trx_log_index_part02.dbf',
'/u01/oradata/XEROXDEV/trx_log_index_part03.dbf',
'/u01/oradata/XEROXDEV/trx_log_index_part04.dbf',
'/u01/oradata/XEROXDEV/trx_log_data01.dbf',
'/u01/oradata/XEROXDEV/trx_log_index01.dbf',
'/u01/oradata/XEROXDEV/utility_data01.dbf',
'/u01/oradata/XEROXDEV/utility_index01.dbf',
'/u01/oradata/XEROXDEV/wc_data01.dbf',
'/u01/oradata/XEROXDEV/wc_index01.dbf',
'/u01/oradata/XEROXDEV/extranet_data01.dbf',
'/u01/oradata/XEROXDEV/extranet_index01.dbf',
'/u01/oradata/XEROXDEV/ARCHIVE_data01.dbf',
'/u01/oradata/XEROXDEV/ARCHIVE_index01.dbf'
CHARACTER SET WE8ISO8859P1
;

From: gln_sarma [mailto:gln_sarma@iss-global.com] Sent: Saturday, September 01, 2007 6:45 AMTo: 'gln_sarma'; 'Raj Mohabe'Cc: ccdba@iss-global.comSubject: RE: Task completed pl. look into this control, log, temp files moved

Raj,

How to check further the dependency of /u02 ?


Controlfile

Copied the controlfile to /u01 and started db

Logfile : created new 4 groups and logfiles
Droped existing

temp file

SQL> CREATE TEMPORARY TABLESPACE TEMP_01 TEMPFILE
'/u01/oradata/XEROXDEV/temp_01.dbf' SIZE 3000M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
2 3
Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp_01;

Database altered.

SQL> DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/temp_01.dbf
From: gln_sarma [mailto:gln_sarma@iss-global.com] Sent: Friday, August 31, 2007 11:33 PMTo: 'Raj Mohabe'Cc: ccdba@iss-global.comSubject: Task completed pl. look into this

Raj,

I am thru with this exercise. I checked from my side. Check and you can inform back.


Sever
192.168.202.52
oracle/c@rp00l
Sid
XEROXDEV

Task
Moving all the 52 datafiles from /u02 to /u01

Requirement
1 Shutdown immediate
‘ cp /u01/oradata/XEROXDEV
cp /u02/oradata/XEROXDEV/*.idx .
cp /u02/oradata/XEROXDEV/*.dbf .
preparation of movement statement
execution



13 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_10.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_10.dbf';
14 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_11.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_11.dbf';
15 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_12.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_12.dbf';
16 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_13.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_13.dbf';
17 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_14.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_14.dbf';
18 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_15.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_15.dbf';
19 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_16.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_16.dbf';
20 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_17.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_17.dbf';
21 alter database rename file '/u02/oradata/XEROXDEV/xerox_ext414_18.dbf' to '/u01/oradata/XEROXDEV/xerox_ext414_18.dbf';
22 alter database rename file '/u02/oradata/XEROXDEV/users01.dbf' to '/u01/oradata/XEROXDEV/users01.dbf';

23 alter database rename file '/u02/oradata/XEROXDEV/general_index01.dbf' to '/u01/oradata/XEROXDEV/general_index01.dbf';
24 alter database rename file '/u02/oradata/XEROXDEV/inventory_data01.dbf' to '/u01/oradata/XEROXDEV/inventory_data01.dbf';
25 alter database rename file '/u02/oradata/XEROXDEV/inventory_index01.dbf' to '/u01/oradata/XEROXDEV/inventory_index01.dbf';
26 alter database rename file '/u02/oradata/XEROXDEV/order_data01.dbf' to '/u01/oradata/XEROXDEV/order_data01.dbf';
27 alter database rename file '/u02/oradata/XEROXDEV/order_index01.dbf' to '/u01/oradata/XEROXDEV/order_index01.dbf';
28 alter database rename file '/u02/oradata/XEROXDEV/pbe_data01.dbf' to '/u01/oradata/XEROXDEV/pbe_data01.dbf';
29 alter database rename file '/u02/oradata/XEROXDEV/pbe_index01.dbf' to '/u01/oradata/XEROXDEV/pbe_index01.dbf';
30 alter database rename file '/u02/oradata/XEROXDEV/security_data01.dbf' to '/u01/oradata/XEROXDEV/security_data01.dbf';
31 alter database rename file '/u02/oradata/XEROXDEV/security_index01.dbf' to '/u01/oradata/XEROXDEV/security_index01.dbf';
32 alter database rename file '/u02/oradata/XEROXDEV/tp_data01.dbf' to '/u01/oradata/XEROXDEV/tp_data01.dbf';
33 alter database rename file '/u02/oradata/XEROXDEV/tp_index01.dbf' to '/u01/oradata/XEROXDEV/tp_index01.dbf';
34 alter database rename file '/u02/oradata/XEROXDEV/trx_log_data_part01.dbf' to

'/u01/oradata/XEROXDEV/trx_log_data_part01.dbf';
35 alter database rename file '/u02/oradata/XEROXDEV/trx_log_data_part02.dbf' to

'/u01/oradata/XEROXDEV/trx_log_data_part02.dbf';
36 alter database rename file '/u02/oradata/XEROXDEV/trx_log_data_part03.dbf' to

'/u01/oradata/XEROXDEV/trx_log_data_part03.dbf';
37 alter database rename file '/u02/oradata/XEROXDEV/trx_log_data_part04.dbf' to

'/u01/oradata/XEROXDEV/trx_log_data_part04.dbf';
38 alter database rename file '/u02/oradata/XEROXDEV/trx_log_index_part01.dbf' to

'/u01/oradata/XEROXDEV/trx_log_index_part01.dbf';
39 alter database rename file '/u02/oradata/XEROXDEV/trx_log_index_part02.dbf' to

'/u01/oradata/XEROXDEV/trx_log_index_part02.dbf';
40 alter database rename file '/u02/oradata/XEROXDEV/trx_log_index_part03.dbf' to

'/u01/oradata/XEROXDEV/trx_log_index_part03.dbf';
41 alter database rename file '/u02/oradata/XEROXDEV/trx_log_index_part04.dbf' to

'/u01/oradata/XEROXDEV/trx_log_index_part04.dbf';
42 alter database rename file '/u02/oradata/XEROXDEV/trx_log_data01.dbf' to '/u01/oradata/XEROXDEV/trx_log_data01.dbf';
43 alter database rename file '/u02/oradata/XEROXDEV/trx_log_index01.dbf' to '/u01/oradata/XEROXDEV/trx_log_index01.dbf';
44 alter database rename file '/u02/oradata/XEROXDEV/utility_data01.dbf' to '/u01/oradata/XEROXDEV/utility_data01.dbf';

45 alter database rename file '/u02/oradata/XEROXDEV/utility_index01.dbf' to '/u01/oradata/XEROXDEV/utility_index01.dbf';
46 alter database rename file '/u02/oradata/XEROXDEV/wc_data01.dbf' to '/u01/oradata/XEROXDEV/wc_data01.dbf';
47 alter database rename file '/u02/oradata/XEROXDEV/wc_index01.dbf' to '/u01/oradata/XEROXDEV/wc_index01.dbf';
48 alter database rename file '/u02/oradata/XEROXDEV/extranet_data01.dbf' to '/u01/oradata/XEROXDEV/extranet_data01.dbf';
49 alter database rename file '/u02/oradata/XEROXDEV/extranet_index01.dbf' to '/u01/oradata/XEROXDEV/extranet_index01.dbf';
50 alter database rename file '/u02/oradata/XEROXDEV/ARCHIVE_data01.dbf' to '/u01/oradata/XEROXDEV/ARCHIVE_data01.dbf';
51 alter database rename file '/u02/oradata/XEROXDEV/ARCHIVE_index01.dbf' to '/u01/oradata/XEROXDEV/ARCHIVE_index01.dbf'
;
52 alter database rename file '/u02/oradata/XEROXDEV/TSAP2.idx' to '/u01/oradata/XEROXDEV/TSAP2.idx';
52 executed

SQL> alter database open;

Database altered.


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/system01.dbf
/u01/oradata/XEROXDEV/general_data01.dbf
/u01/oradata/XEROXDEV/xerox_cc01.dbf
/u01/oradata/XEROXDEV/xerox_ext414.dbf
/u01/oradata/XEROXDEV/ext414.dbf
/u01/oradata/XEROXDEV/xerox_ext414_02.dbf
/u01/oradata/XEROXDEV/xerox_ext414_03.dbf
/u01/oradata/XEROXDEV/xerox_ext414_04.dbf
/u01/oradata/XEROXDEV/xerox_ext414_05.dbf
/u01/oradata/XEROXDEV/xerox_ext414_06.dbf
/u01/oradata/XEROXDEV/xerox_ext414_07.dbf

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/xerox_ext414_08.dbf
/u01/oradata/XEROXDEV/xerox_ext414_09.dbf
/u01/oradata/XEROXDEV/xerox_ext414_10.dbf
/u01/oradata/XEROXDEV/xerox_ext414_11.dbf
/u01/oradata/XEROXDEV/xerox_ext414_12.dbf
/u01/oradata/XEROXDEV/xerox_ext414_13.dbf
/u01/oradata/XEROXDEV/xerox_ext414_14.dbf
/u01/oradata/XEROXDEV/xerox_ext414_15.dbf
/u01/oradata/XEROXDEV/xerox_ext414_16.dbf
/u01/oradata/XEROXDEV/xerox_ext414_17.dbf
/u01/oradata/XEROXDEV/xerox_ext414_18.dbf

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/users01.dbf
/u01/oradata/XEROXDEV/TSAP2.idx
/u01/oradata/XEROXDEV/undotbs2_01.dbf
/u01/oradata/XEROXDEV/general_index01.dbf
/u01/oradata/XEROXDEV/inventory_data01.dbf
/u01/oradata/XEROXDEV/inventory_index01.dbf
/u01/oradata/XEROXDEV/order_data01.dbf
/u01/oradata/XEROXDEV/order_index01.dbf
/u01/oradata/XEROXDEV/pbe_data01.dbf
/u01/oradata/XEROXDEV/pbe_index01.dbf
/u01/oradata/XEROXDEV/security_data01.dbf

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/security_index01.dbf
/u01/oradata/XEROXDEV/tp_data01.dbf
/u01/oradata/XEROXDEV/tp_index01.dbf
/u01/oradata/XEROXDEV/trx_log_data_part01.dbf
/u01/oradata/XEROXDEV/trx_log_data_part02.dbf
/u01/oradata/XEROXDEV/trx_log_data_part03.dbf
/u01/oradata/XEROXDEV/trx_log_data_part04.dbf
/u01/oradata/XEROXDEV/trx_log_index_part01.dbf
/u01/oradata/XEROXDEV/trx_log_index_part02.dbf
/u01/oradata/XEROXDEV/trx_log_index_part03.dbf
/u01/oradata/XEROXDEV/trx_log_index_part04.dbf

NAME
--------------------------------------------------------------------------------
/u01/oradata/XEROXDEV/trx_log_data01.dbf
/u01/oradata/XEROXDEV/trx_log_index01.dbf
/u01/oradata/XEROXDEV/utility_data01.dbf
/u01/oradata/XEROXDEV/utility_index01.dbf
/u01/oradata/XEROXDEV/wc_data01.dbf
/u01/oradata/XEROXDEV/wc_index01.dbf
/u01/oradata/XEROXDEV/extranet_data01.dbf
/u01/oradata/XEROXDEV/extranet_index01.dbf
/u01/oradata/XEROXDEV/ARCHIVE_data01.dbf
/u01/oradata/XEROXDEV/ARCHIVE_index01.dbf

54 rows selected.

No /u02
SQL> select name from v$datafile where name like '/u02%';

no rows selected

Db started
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1108416700 bytes
Fixed Size 452796 bytes
Variable Size 268435456 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.