-
pls...tell me how to create control file
i already import the data....now i'm stuck on creating control file..........don't know how to get .DAT ext....
-
I am not sure I understand your question properly.
There are many ways to create a control file :
If your database is up and running then you can execute the following command
from server manager or from sqlplus with a dba role :
SQL> alter database backup controlfile to trace;
the above command would create a text file in your user dump dest directory.
you can modify that file and use it to recreate your controlfile. otherwise you have
to create a script file like the following (your file names and parameters may vary):
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "DEV1" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'/oradata/ANP1/vg01_01/log01a.dbf',
'/oradata/ANP1/vg01_01/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/oradata/ANP1/vg01_01/log02a.dbf',
'/oradata/ANP1/vg01_01/log02b.dbf'
) SIZE 10M
DATAFILE
'/oradata/ANP1/vg01_01/system01.dbf',
'/oradata/ANP1/vg01_01/rbs01.dbf',
'/oradata/ANP1/vg01_01/temp01.dbf',
'/oradata/ANP1/vg01_01/akx01.dbf',
'/oradata/ANP1/vg01_01/akd01.dbf',
'/oradata/ANP1/vg01_01/alrx01.dbf',
'/oradata/ANP1/vg01_01/ctxd01.dbf'
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
once you have done this. start server manager (svrmgrl) and execute the
script.
Hope this helps
-
Hi!
You have imported your data into the database. Which means the database is up and running. Which further means your control file fit and fine and you don't need to create another control file. What you can do is to backup your current control file using the command
ALTER DATABSE backup control file to TRACE;
Which creates a text file for creating a control file
OR you can use
ALTER DATABASE backup control fiel to <FILENAME>;
Which just duplicates your current control file to the name you specify.
Regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|