SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
version 2798
SQL> shutdown abort;
ORACLE instance shut down.
sQL>create pfile='c:/initnew.ora' from spfile;
File created.
SQL>shutdown abort;
-----Edit the pfile and delete the controlfile 02 and controlfile 03 from controlfiles parameter
-----Then boot the system from newly created pfile
SQL> startup nomount pfile='c:/initnew.ora';
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
SQL>
SQL>
SQL>
SQL>
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:15:50 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: johnson (not mounted)
RMAN>
RMAN> restore controlfile from autobackup;
Starting restore at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: D:\oracle\product\10.2.0/flash_recovery_area
database name (or database unique name) used for search: JOHNSON
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AR
EA\JOHNSON\AUTOBACKUP\2011_04_29\O1_MF_N_749732909_6VNMPQVT_.BKP
channel ORA_DISK_1: control file restore from autobackup complete
output filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL
Finished restore at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> create spfile from pfile='c:/initnew.ora';
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:17:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: JOHNSON (DBID=2710984504, not open)
RMAN> run{
2> recover database;
3> }
Starting recover at 29-APR-11
Starting implicit crosscheck backup at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 29-APR-11
Starting implicit crosscheck copy at 29-APR-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-APR-11
searching for all files in the recovery area
cataloging files...
cataloging done
.
.
.
.
.
.
.
.
.
media recovery complete, elapsed time: 00:00:04
Finished recover at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
----For cross check whether your database was recovered successfully or not, shut it down and start
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 176163716 bytes
Database Buffers 427819008 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
version 2798
SQL> shutdown abort;
ORACLE instance shut down.
sQL>create pfile='c:/initnew.ora' from spfile;
File created.
SQL>shutdown abort;
-----Edit the pfile and delete the controlfile 02 and controlfile 03 from controlfiles parameter
-----Then boot the system from newly created pfile
SQL> startup nomount pfile='c:/initnew.ora';
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
SQL>
SQL>
SQL>
SQL>
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:15:50 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: johnson (not mounted)
RMAN>
RMAN> restore controlfile from autobackup;
Starting restore at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
recovery area destination: D:\oracle\product\10.2.0/flash_recovery_area
database name (or database unique name) used for search: JOHNSON
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AR
EA\JOHNSON\AUTOBACKUP\2011_04_29\O1_MF_N_749732909_6VNMPQVT_.BKP
channel ORA_DISK_1: control file restore from autobackup complete
output filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL
Finished restore at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> create spfile from pfile='c:/initnew.ora';
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> ho rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 29 11:17:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: JOHNSON (DBID=2710984504, not open)
RMAN> run{
2> recover database;
3> }
Starting recover at 29-APR-11
Starting implicit crosscheck backup at 29-APR-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 29-APR-11
Starting implicit crosscheck copy at 29-APR-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-APR-11
searching for all files in the recovery area
cataloging files...
cataloging done
.
.
.
.
.
.
.
.
.
media recovery complete, elapsed time: 00:00:04
Finished recover at 29-APR-11
RMAN> quit
Recovery Manager complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
----For cross check whether your database was recovered successfully or not, shut it down and start
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 176163716 bytes
Database Buffers 427819008 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>
This comment has been removed by the author.
ReplyDelete