on 01-26-2010 9:35 AM
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.
Find it, because in one system PSAPTEMP is marked as temporary and in the secon not.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.