Lost of Recovery catalog & Control file [message #201441] |
Sat, 04 November 2006 04:43 |
it_me24
Messages: 167 Registered: March 2006 Location: delhi
|
Senior Member |
|
|
Hello Everyone!
I have a database named prod which is in Archivelog mode.
I took a complete backup of the DB using RMAN including current
control file & Archive files.I am using Recovery Catalog as DB Control file.
After the Backup was successful.
I removed the control files from their original Location.
And when i tried to restart the DB, it did not Mount as Control file was missing.
I ran RMAN Utility & tried to recover the lost control files from the recent backup i have taken using RMAN.
I am not getting connected to the Recovery Catalog as I am using Control file as Recovery Catalog & in my Scenario control file is missing.
??????gettting ERROR Database Start/Shutdown in Progress.
My Ques here is:
is there any possibility that I can recover the lost control file which is also the Recovery Catalog from the backup which I have taken.
Oracle 9.2.0.1.0
Win xp
Thanks In Advance
|
|
|
|
|
Re: Lost of Recovery catalog & Control file [message #201448 is a reply to message #201441] |
Sat, 04 November 2006 06:47 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
Hi.
The following procedure assumes that you do not have more than one target database registered in the catalog with the same name. If multiple target databases are registered with the same name, then you must specify the DBID with the SET DBID command so that RMAN knows which control file to restore. The DBID is the unique numerical identifier for a database.
*****************
Database 10.1.0.2.0
Archivelog mode.
status open
through rman took complete bkp with below cmd.
rman>run
{
allocate channel c1 type disk format 'c:\datapump\data\%u';
backup database;
backup current controlfile;
}
*****
after that i was delete all controlfile from original location.
*****************
and i was perform restore or recovery operation with recovery catalog.
*******************************
C:\>rman target=sys@orcl catalog=rman/rman@catdb
Recovery Manager: Release 10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
target database Password:
connected to target database: orcl (not mounted)
connected to recovery catalog database
RMAN> startup nomount;
database is already started
RMAN> restore controlfile;
Starting restore at 04-NOV-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\DATAPUMP\DATA\1JI1IIGS tag=TAG20061104T163228
channel ORA_DISK_1: restore complete
output filename=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01.CTL
output filename=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL02.CTL
output filename=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL03.CTL
Finished restore at 04-NOV-06
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 04-NOV-06
Starting implicit crosscheck backup at 04-NOV-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 04-NOV-06
Starting implicit crosscheck copy at 04-NOV-06
using channel ORA_DISK_1
Finished implicit crosscheck copy at 04-NOV-06
searching for all files in the recovery area
cataloging files...
cataloging done
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SYSAUX01.DBF
restoring datafile 00004 to D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\USERS01.DBF
restoring datafile 00005 to D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DBF
restoring datafile 00006 to C:\DATAPUMP\DATA\RMAN01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=C:\DATAPUMP\DATA\1HI1IIDO tag=TAG20061104T163048
channel ORA_DISK_1: restore complete
Finished restore at 04-NOV-06
RMAN> recover database;
Starting recover at 04-NOV-06
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 4 is already on disk as file D:\ORACLE\PRODUCT\10.
1.0\ORADATA\ORCL\REDO01.LOG
archive log filename=D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG thread=1 s
equence=4
media recovery complete
Finished recover at 04-NOV-06
RMAN> alter database open resetlogs;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
After that it is recommended to take complete bkp of ur database.
SHUTDOWN IMMEDIATE
STARTUP MOUNT
BACKUP DATABASE;
ALTER DATABASE OPEN;
Hope this helps
Mohammad Taj.
PS>Performing Recovery with a Backup Control File and Recovery Catalog
Go through mention by "Mahesh" and check above bold line.
[Updated on: Sat, 04 November 2006 06:49] Report message to a moderator
|
|
|
|
|