sql statement: alter system reset? db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area? ? 238034944 bytes

Fixed Size? ? ? ? ? ? ? ? ? ? 2227136 bytes

Variable Size? ? ? ? ? ? ? ? 180356160 bytes

Database Buffers? ? ? ? ? ? ? 50331648 bytes

Redo Buffers? ? ? ? ? ? ? ? ? 5120000 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORADU" RESETLOGS ARCHIVELOG

MAXLOGFILES? ? 16

MAXLOGMEMBERS? ? ? 3

MAXDATAFILES? ? ? 100

MAXINSTANCES? ? 8

MAXLOGHISTORY? ? ? 292

?LOGFILE

GROUP? 1 ( '/u01/app/oracle/oradata/oradu/redo01.log', '/u01/app/oracle/oradata/oradu/redo01_01.log' ) SIZE 100 M? REUSE,

GROUP? 2 ( '/u01/app/oracle/oradata/oradu/redo02.log', '/u01/app/oracle/oradata/oradu/redo02_01.log' ) SIZE 100 M? REUSE,

GROUP? 3 ( '/u01/app/oracle/oradata/oradu/redo03.log', '/u01/app/oracle/oradata/oradu/redo03_01.log' ) SIZE 100 M? REUSE,

GROUP? 4 ( '/u01/app/oracle/oradata/oradu/redo04.log', '/u01/app/oracle/oradata/oradu/redo04_01.log' ) SIZE 100 M? REUSE

?DATAFILE

'/u01/app/oracle/oradata/oradu/system01.dbf'

?CHARACTER SET ZHS16GBK

contents of Memory Script:

{

? set newname for tempfile? 1 to

?"/u01/app/oracle/oradata/oradu/temp01.dbf";

? switch clone tempfile all;

? catalog clone datafilecopy? "/u01/app/oracle/oradata/oradu/sysaux01.dbf",

?"/u01/app/oracle/oradata/oradu/undotbs01.dbf",

?"/u01/app/oracle/oradata/oradu/users01.dbf",

?"/u01/app/oracle/oradata/oradu/test.dbf",

?"/u01/app/oracle/oradata/oradu/store_01.dbf",

?"/u01/app/oracle/oradata/oradu/store_02.dbf",

?"/u01/app/oracle/oradata/oradu/pitr01.dbf";

? switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/oradu/temp01.dbf in control file

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/sysaux01.dbf RECID=1 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/undotbs01.dbf RECID=2 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/users01.dbf RECID=3 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/test.dbf RECID=4 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/store_01.dbf RECID=5 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/store_02.dbf RECID=6 STAMP=906989800

cataloged datafile copy

datafile copy file name=/u01/app/oracle/oradata/oradu/pitr01.dbf RECID=7 STAMP=906989800

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=906989800 file name=/u01/app/oracle/oradata/oradu/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=906989800 file name=/u01/app/oracle/oradata/oradu/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=906989800 file name=/u01/app/oracle/oradata/oradu/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=906989800 file name=/u01/app/oracle/oradata/oradu/test.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=5 STAMP=906989800 file name=/u01/app/oracle/oradata/oradu/store_01.dbf