- 论坛徽章:
- 59
|
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 20
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 200
5 MAXINSTANCES 1
6 MAXLOGHISTORY 1361
7 LOGFILE
8 GROUP 1 '/opt/oracle/db02/oradata/redo01.log' SIZE 64M,
9 GROUP 2 '/opt/oracle/db03/oradata/ORCL/redo02.log' SIZE 64M,
10 GROUP 3 '/opt/oracle/db04/oradata/ORCL/redo03.log' SIZE 64M,
11 GROUP 4 '/opt/oracle/db02/oradata/redo04.log' SIZE 64M
12 DATAFILE
13 '/opt/oracle/db02/oradata/system01.dbf',
14 '/opt/oracle/db02/oradata/indx01.dbf',
15 '/opt/oracle/db02/oradata/RBS.dbf',
16 '/opt/oracle/db02/oradata/tools01.dbf',
17 '/opt/oracle/db02/oradata/users01.dbf',
18 '/opt/oracle/db02/oradata/drsys01.dbf',
19 '/opt/oracle/db02/oradata/temp01.dbf',
20 '/opt/oracle/db02/oradata/nms.dbf',
21 &nb |
|