| Recovery - NOARCHIVELOG [message #351396] |
Tue, 30 September 2008 11:23  |
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 #351409 is a reply to message #351401] |
Tue, 30 September 2008 14:00  |
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 #351415 is a reply to message #351413] |
Tue, 30 September 2008 14:31 |
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 |
 |
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 |
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 #351420 is a reply to message #351418] |
Tue, 30 September 2008 14:46 |
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
