Home » RDBMS Server » Backup & Recovery » Recovery - NOARCHIVELOG (10.2.0.3, RHEL)
Recovery - NOARCHIVELOG [message #351396] Tue, 30 September 2008 11:23 Go to next message
andydba
Messages: 34
Registered: September 2008
Member

Hi,

I have following situation:

1.Database is running in NOARCHIVELOG mode.
2. CONTROLFILE AUTOBACKUP is set to OFF
3. Databaase is using text based init.ora. No SPFILE is being used.
4. 1 week old consistent backup is available. This backup was taken using RMAN.

I lost:
1. Control Files
2. Data Files
3. Redo Logs
4. init.ora file

I was able to get DBID using strings command at command prompt and I have the DBID.

How do I restore the database?

-Andy
Re: Recovery - NOARCHIVELOG [message #351401 is a reply to message #351396] Tue, 30 September 2008 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Create the control file using CREATE CONTROLFILE
2. Restore data files using RMAN
3. Open resetlogs will recreate the redo logs

Regards
Michel
Re: Recovery - NOARCHIVELOG [message #351409 is a reply to message #351401] Tue, 30 September 2008 14:00 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

I am sure that one of my backupset will have control file in it. I am saying this because as per oracle, whenever we take backup of datafile 1, rman automatically takes backup of controlfile and spfile. Autobackup configuration does not impact this.

In my case there was no SPFILE but control file must be in one of the backupset.

Re: Recovery - NOARCHIVELOG [message #351413 is a reply to message #351409] Tue, 30 September 2008 14:23 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I assume you don't maintain backup logs with the backups?

Nevertheless, you can just try the different backuppieces until you find the right one.
Re: Recovery - NOARCHIVELOG [message #351415 is a reply to message #351413] Tue, 30 September 2008 14:31 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

I don't have init.ora file. How do I start the instance.

I did following
RMAN> STARTUP NOMOUNT;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initTSH3.ora'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area 159383552 bytes

Fixed Size 1260624 bytes
Variable Size 58721200 bytes
Database Buffers 92274688 bytes
Redo Buffers 7127040 bytes

RMAN> restore controlfile from '/u01/app/oracle/flash_recover_area/TSH3/backupset/2008_09_30/o1_mf_nnnd1_TAG20080930T095740_4g4d2nyy_.bkp';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/30/2008 15:18:45
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


I know that control file is in this backup piece.

How do I restore the controlfile without actual init.ora file?
Re: Recovery - NOARCHIVELOG [message #351416 is a reply to message #351415] Tue, 30 September 2008 14:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How do you know that piece has the controlfile? It will not hurt to try the other pieces.

The piece that has the controlfile should also have the spfile.

Sorry, forgot you mentioned that you were using an init file. You should be able to use your alert log to reconstruct your init file.

[Updated on: Tue, 30 September 2008 14:37]

Report message to a moderator

Re: Recovery - NOARCHIVELOG [message #351417 is a reply to message #351416] Tue, 30 September 2008 14:37 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

I know that because I had restored the database once when I had original init.ora file.

SPFILE was never created and I was using text based init.ora file which is gone now.

Can I restore a controlfile without restoring original init.ora (in my case) or witout SPFILE (in general).
Re: Recovery - NOARCHIVELOG [message #351418 is a reply to message #351417] Tue, 30 September 2008 14:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
As you see, it will use the "dummy" spfile until you restore the original one, which in your case you don't have. Therefore, you should shutdown the instance and create a init file using the parameters from your alert log. If you don't have a copy of the alert log, then you'll have to make one up with appropriate parameters.
Re: Recovery - NOARCHIVELOG [message #351420 is a reply to message #351418] Tue, 30 September 2008 14:46 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

dummy init.ora gives SGA and minimum settings which are not helpful if you try to restore the controlfile.
What are the mandatory parameters that are required to restore the control file from the backup piece?
Re: Recovery - NOARCHIVELOG [message #351430 is a reply to message #351420] Tue, 30 September 2008 16:25 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Look in $ORACLE_HOME/dbs for a sample init file.
Re: Recovery - NOARCHIVELOG [message #351433 is a reply to message #351430] Tue, 30 September 2008 17:15 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

from which location oracle reads dummy init.ora file?
Re: Recovery - NOARCHIVELOG [message #351435 is a reply to message #351433] Tue, 30 September 2008 18:15 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It isn't actually a file. It's just a default configuration that RMAN can use to start the instance.
Previous Topic: alert.log > Bad header found during deleting archived log
Next Topic: Recover Tablespace - RMAN
Goto Forum:
  


Current Time: Wed Dec 07 02:41:58 CST 2016

Total time taken to generate the page: 0.24496 seconds