Before proceed we need to know while restoring data in noarchivelog mode that,
1)Only cold backups (that is, backups created when the database was shut down normally) can be used in restoring a database in NOARCHIVELOG mode.
2)Media recovery is not possible, because there are no archived logs.
3)If we exclude any tablespace except read-only or offline from taking database backup then those tablespaces will be lost.
In this scenario I have lost all the data files, control files, redo log file and spfile. I have also forgot DBID of the database. The procedure of restore and recovery of database in noarchivelog mode in as below.
A) Find the DBID of the Database from Backup Piece.
bash-3.00$ strings /oradata2/flash_recovery_area/DBASE1/backupset/2008_05_06/o1_mf_nnndf_TAG20080506T111057_420x821v_.bkp |grep MAXVALUE,
3386862614, MAXVALUE,
We got DBID here 3386862614.
B) Connect to target database with RMAN
bash-3.00$ rman target /
C) Set the DBID.
RMAN> set dbid 3386862614
D) Start the database in nomount stage with dummy Parameter.
RMAN> startup force nomount
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.2.0/db_1/dbs/initdbase1.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
E) Restore spfile
RMAN> restore spfile from '/oradata2/flash_recovery_area/DBASE1/autobackup/2008_05_06/o1_mf_s_653998009_420shstm_.bkp';
F) Mount the Database.
RMAN> startup force nomount;
G) Restore controlfile.
RMAN> restore controlfile from autobackup;
RMAN> alter database mount;
I) Restore Database.
J) Recover Database:
RMAN> recover database;
RMAN> alter database open resetlogs;
database opened.
This entry was posted
on Tuesday, January 11, 2011
at 10:07 AM
and is filed under
RMAN
. You can follow any responses to this entry through the
comments feed
.
Contributors
- Mawahid
Pages
Powered by Blogger.
Blog Archive
-
▼
2011
(26)
-
▼
January
(14)
- Changing DBID and DB name
- Restore and Recover database in Noarchivelog Mode
- What happens during oracle database hot backup
- Database Duplication Fails Missing Log RMAN-06053 ...
- Restore and Recover database to a new host
- ORA-01548: active rollback segment '_SYSSMU1$' fou...
- User Managed hot backup of oracle database
- Shutdown fails with ORA-24324, ORA-24323, ORA-01090
- How undo Space Allocation Works
- How to restore an Spfile from autobackup older tha...
- How to skip a tablespace from restore operation
- How to Discover DBID
- About Oracle Database Incarnations
- RMAN duplicate fails with RMAN-10006, ORA-03113, O...
-
▼
January
(14)