Edited by: 842638 on Feb 14, 2013 7:38 PM
SQL> startup force nomount ORACLE instance started. Total System Global Area 313159680 bytes Fixed Size 2212936 bytes Variable Size 125832120 bytes Database Buffers 180355072 bytes Redo Buffers 4759552 bytes SQL> CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 '/u01/app/oracle/oradata/test/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/u01/app/oracle/oradata/test/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/u01/app/oracle/oradata/test/redo03.log' SIZE 50M BLOCKSIZE 512 -- STANDBY LOGFILE DATAFILE '/u01/app/oracle/oradata/test/system01.dbf', '/u01/app/oracle/oradata/test/sysaux01.dbf', '/u01/app/oracle/oradata/test/undotbs01.dbf', '/u01/app/oracle/oradata/test/users01.dbf', '/u01/app/oracle/oradata/test/example01.dbf' CHARACTER SET WE8MSWIN1252 ; 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS ARCHIVELOG * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-01565: error in identifying file '/u01/app/oracle/oradata/test/system01.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3
842638 wrote:Disaster Recovery word terminology can be any way. Usually If database is not available then suppose you are going to restore control file + database from the RMAN backups.
thanks for ur reply hemant, So you mean disaster recovery happened ? And for that we need to get the datafiles from somwhere and put them in their respective locations, right ? and also the redo log files ?? Now hemant i hope you mean that there is no way to rescue fromd isaster recovery, means to create controlfile you need datafiles , i was testing to see if i loose all files what should happen
to mount the database i need to create control fileTo MOUNT the database, you need to RESTORE the controlfile -- from a controlfile backup.
842638 wrote:You cannot have option to create control file, when you dont have anything with you. You have to restore only from Backups.
To restore datafiles from rman you need to mount the database, My datafiles are gone suppose, disk crashed lets say, to mount the database i need to create control file , to create the controlfile i need the datafiles on their respective locations,
, So CKPT :) what do you suggest should take image copies in future to avoid this situation ?? so that i can place them on their locations when i will create controlfile in case i loose all of them ...Either way, Taking image copies then create controlfile, which is time taking[lot of manual work]. Use RMAN backups to restore Control file + Data files, which makes your life simpler.