This content has been marked as final. Show 12 replies
You have no copies of the control file from the original database and no backups? Please confirm that statement.
... and everyone else here knows exactly what I'm thinking so I won't say it. You don't have a problem creating a copy ... you have a problem with the original database and you'd best address that first.
983292 wrote:just make a new one by doing as below
i want to ADD that in my Pfile (init.ora which i started database) i didnt define of controlfile ,because i didnt have it
STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/home/oracle/app/oracle/oradata/orcl/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/home/oracle/app/oracle/oradata/orcl/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/home/oracle/app/oracle/oradata/orcl/redo03.log' SIZE 50M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '/home/oracle/app/oracle/oradata/orcl/system01.dbf', '/home/oracle/app/oracle/oradata/orcl/sysaux01.dbf', '/home/oracle/app/oracle/oradata/orcl/undotbs01.dbf', '/home/oracle/app/oracle/oradata/orcl/users01.dbf', '/home/oracle/app/oracle/oradata/orcl/example01.dbf', '/home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf' CHARACTER SET AL32UTF8 ; -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk. Any one log file from each branch can be used to -- re-create incarnation records. -- ALTER DATABASE REGISTER LOGFILE '/home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2013_03_01/o1_mf_1_1_%u_.arc'; -- ALTER DATABASE REGISTER LOGFILE '/home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2013_03_01/o1_mf_1_1_%u_.arc'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate. RECOVER DATABASE -- Database can now be opened normally. ALTER DATABASE OPEN; -- Commands to add tempfiles to temporary tablespaces. -- Online tempfiles have complete space information. -- Other tempfiles may require adjustment. ALTER TABLESPACE TEMP ADD TEMPFILE '/home/oracle/app/oracle/oradata/orcl/temp01.dbf' SIZE 165675008 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions.
YEs i dnt have , ( i can have it if i want, BUT i am confused that will that controlfile will work for this newly created database? because older controlfiles can have older destinations of folders&files)
but i am wondering if this kind of failure comes in future ...
I can describe more in Detail :-
1.I have a database running IN system A which contains folders (oracle\product\10.2.0\db_1,flash_area,oradata,admin),
2.Now, i just copied Entire Oracle Folder as it is TO system B ( for make a copy of Database like system A) except (controlfiles , pfile,spfile - because i thot these 3 files is unique for database)
3.used Oradim , instance created .
4.modified that Pfile from system A and and startup with pfile , den created SPfile , and then again created Pfile from sp(so i can have my own sp and Pfiles) ---[in my Pfile i didnt define controlfiles]
5.now its giving error of controlfile.
6. i can have that control file of system"A" but will it work .
7.what in case lost of control file and u can have a copy of controlfile
8.i DONT have Backup in FRA
win 7 ultimate
If you are worried about the control file, you can restore it from the original system's A backup. If you are worried about the information inside the control file....do not worry
You can still restore the control file and then mount your database ...after mount you can change the location of the datafiles and logfiles before start actual datafile rstore or recovery.
1) Give the right(valid path) path of control file in your pile.
2) Startup nomount
3) restore the control file from system's A backup
4) Mount the database
5) Change location of datafiles and logfiles if you want to restore these files in different location.
6) Restore database
7) Recover database
Moreover you should read
Which are the necessary parameters in Pfile if im Making Pfile manually ( that atleast we need these parameters to start the Datbase )1) Nomrally just to start the instance you need db_name and control file parameter.
2) You can go to your system A database and run the following query and save it. It will give you all the parameters
SELECT name, value
WHERE isdefault = 'FALSE'
ORDER BY 1;
3) This is the list of sample parameters in example file
processes = 150
# You may want to ensure that control files are created on separate physical
control_files = (ora_control1, ora_control2)