Home » RDBMS Server » Backup & Recovery » Lost of Recovery catalog & Control file
Lost of Recovery catalog & Control file [message #201441] Sat, 04 November 2006 04:43 Go to next message
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 #201442 is a reply to message #201441] Sat, 04 November 2006 04:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007319
Re: Lost of Recovery catalog & Control file [message #201447 is a reply to message #201441] Sat, 04 November 2006 06:26 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Laughing Thanks a lot....I will Just Chk it. Laughing
Re: Lost of Recovery catalog & Control file [message #201448 is a reply to message #201441] Sat, 04 November 2006 06:47 Go to previous messageGo to next message
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

Re: Lost of Recovery catalog & Control file [message #201518 is a reply to message #201441] Sun, 05 November 2006 08:47 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Thanks a lot to both of U.
I got the logic.

Cheers!
Re: Lost of Recovery catalog & Control file [message #201524 is a reply to message #201518] Sun, 05 November 2006 09:40 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're welcome
Previous Topic: Unable to import .DMP file.
Next Topic: rman backup is taking more time
Goto Forum:
  


Current Time: Thu May 02 16:09:47 CDT 2024