Home » RDBMS Server » Backup & Recovery » Recovery Scenario
Recovery Scenario [message #184141] Tue, 25 July 2006 09:02 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi,please see this scenario .

I have a database running in NOARCHIVELOG mode.i am taking offline backup of database every sunday night,other than that there is no backup on weekdays.
Issue:One data file is missing on tuesday after DB startup .i understand i have to use last sundays offline backup files.

Questions is :What if the backup control file is missing for last sunday ?is it possible to recover without control file?
Re: Recovery Scenario [message #184176 is a reply to message #184141] Tue, 25 July 2006 11:21 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may need to consider a better backup plan, unless you don't mind loosing data.

First and foremost, make sure you use a COPY of you backup from Sunday in case something goes wrong during recovery.

You can recover from Sunday's backup, but you'll have to recreate the controlfile from scratch if you don't have a backup of one and then recreate the controlfile once you have the database in NOMOUNT mode.

Within SQLPlus, you can run the following:
STARTUP NOMOUNT;

-- Sample create controlfile command
-- you'll need to modify to your environment

CREATE CONTROLFILE REUSE DATABASE "<DBSID>" RESETLOGS
  MAXLOGFILES 32
  MAXLOGMEMBERS 2
  MAXDATAFILES 254
  MAXINSTANCES 1
  MAXLOGHISTORY 449
LOGFILE
  GROUP 1 '/oracle/oradata/database/redo01.ora'  SIZE 1M,
  GROUP 2 '/oracle/oradata/database/redo02.ora'  SIZE 1M
DATAFILE
  '/oracle/oradata/database/system01.ora' SIZE 100M,
  '/oracle/oradata/database/rbs01.ora' SIZE 40M,
  '/oracle/oradata/database/user01.ora' SIZE 25M,
  '/oracle/oradata/database/indx01.ora' SIZE 25M,
  '/oracle/oradata/database/tools01.ora' SIZE 10M;

ALTER DATABASE OPEN RESETLOGS;
Previous Topic: Export using UTF8 character set
Next Topic: Problem in Starting Database
Goto Forum:
  


Current Time: Fri Dec 09 02:09:56 CST 2016

Total time taken to generate the page: 0.07977 seconds