alter database backup controlfile to trace (Question for tempfiles)

[Ganimede-Dignan]

Hi

in a system a "alter database backup controlfile to trace" produce this:

CREATE CONTROLFILE REUSE DATABASE "SID" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 738

MAXINSTANCES 50

MAXLOGHISTORY 36517

LOGFILE

GROUP 11 (

'/oracle/SID/origlogA/log_g11m1.dbf',

'/oracle/SID/mirrlogA/log_g11m2.dbf'

) SIZE 200M,

GROUP 12 (

'/oracle/SID/origlogB/log_g12m1.dbf',

'/oracle/SID/mirrlogB/log_g12m2.dbf'

) SIZE 200M,

GROUP 13 (

'/oracle/SID/origlogA/log_g13m1.dbf',

'/oracle/SID/mirrlogA/log_g13m2.dbf'

) SIZE 200M,

GROUP 14 (

'/oracle/SID/origlogB/log_g14m1.dbf',

'/oracle/SID/mirrlogB/log_g14m2.dbf'

) SIZE 200M

-- STANDBY LOGFILE

DATAFILE

'/oracle/SID/sapdata1/temp_1/temp.data1',

'/oracle/SID/sapdata1/temp_2/temp.data2',

....

On other system tempfiles are not included into CREATE CONTROLFILE REUSE... statement but as:

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SID/sapdata15/temp_4/temp.data4'

SIZE 10000M REUSE AUTOEXTEND OFF;

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SID/sapdata14/temp_3/temp.data3'

SIZE 10000M REUSE AUTOEXTEND OFF;

Why there is this difference?

Regards.

[Ganimede-Dignan]

Find it, because in one system PSAPTEMP is marked as temporary and in the secon not.

Regards.

[JPReyes]

I don't understand your question... the first statement is to create a dump of your controlfile settings , the second one is an statement to add a datafile to psaptemp...

Whats the question again?

Regards

Juan