STARTUP NOMOUNT CREATE CONTROLFILE SET DATABASE "TST" LOGFILE GROUP 1 '/tst/redo/log1tst.dbf' SIZE 60M, GROUP 2 '/tst/redo/log2tst.dbf' SIZE 60M, GROUP 3 '/tst/redo/log3tst.dbf' SIZE 60M, GROUP 4 '/tst/redo/log4tst.dbf' SIZE 60M, GROUP 5 '/tst/redo/log5tst.dbf' SIZE 60M, GROUP 6 '/tst/redo/log6tst.dbf' SIZE 60M resetlogs DATAFILE '/tst/indice/auxind01.dbf', '/tst/indice/auxind02.dbf', '/tst/dados/auxtab01.dbf', '/tst/indice/geoind01.dbf', '/tst/indice/geoind02.dbf', '/tst/dados/geotab01.dbf', '/tst/dados/migracao01.dbf', '/tst/indice/perfind01.dbf', '/tst/dados/perftab01.dbf', '/tst/indice/ppvind01.dbf', '/tst/dados/ppvtab01.dbf', '/tst/dados/ppvtab02.dbf', '/tst/rollback/rbstst.dbf', '/tst/rollback/rbstst02.dbf', '/tst/rollback/rbstst03.dbf', '/tst/indice/rec01.dbf', '/tst/dados/sditab01.dbf', '/u21/oracle8s/tst/sigmaib03.dbf', '/tst/indice/sigmaib05.dbf', '/u21/oracle8s/tst/sigmaib06.dbf', '/tst/indice/sigmaib04.dbf', '/tst/indice/sigmaib02.dbf', '/tst/indice/sigmaib01.dbf', '/tst/indice/sigmais01.dbf', '/tst/indice/sigmais02.dbf', '/tst/dados/sigmatb02.dbf', '/tst/dados/sigmatb01.dbf', '/tst/dados/sigmatb03.dbf', '/u21/oracle8s/tst/sigmatb04.dbf', '/u11/oracle8s/dbs1/tst/sigmats01.dbf', '/tst/dados/systtst01.dbf', '/tst/dados/systtst02.dbf', '/tst/dados/usrtst.dbf', '/tst/dados/usrtst1.dbf' CHARACTER SET WE8ISO8859P1 MAXLOGFILES 16 MAXLOGMEMBERS 2 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226 NOARCHIVELOG ; ALTER DATABASE OPEN resetlogs; alter database backup controlfile to trace noresetlogs; ALTER TABLESPACE TEMP ADD TEMPFILE '/tst/temp/temptst.dbf' REUSE;