OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » catalog

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

catalog [message #263077]

Wed, 29 August 2007 00:45

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

what is catalog? please explain..

thanks and regards,
Anamika

Report message to a moderator

Re: catalog [message #263079 is a reply to message #263077]

Wed, 29 August 2007 00:50

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Backup and Recovery Advanced User's Guide
Part I Recovery Manager Advanced Architecture and Concepts
Chapter 1 Recovery Manager Architecture
Section RMAN Repository

Regards
Michel

Report message to a moderator

Re: catalog [message #263085 is a reply to message #263077]

Wed, 29 August 2007 00:58

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Explain needs lots of word to talk. See Michel's link.

In one word catalog is a repository where information of backup,recovery , maintenance ,etc are stored.

Report message to a moderator

Re: catalog [message #263087 is a reply to message #263077]

Wed, 29 August 2007 01:00

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

thanks Michel and Arju.

1 more question.

what is the meaning of incremental level

meaning of levels..why the use of levels

Report message to a moderator

Re: catalog [message #263090 is a reply to message #263077]

Wed, 29 August 2007 01:05

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Incremental backup has 2 levels. (i am talking release after 10g)
Level0-complete backup
level1-incremental backup.
This of course come after level 0/complete backup.
That means after take complete backup few things are added to your database. So instead of backup up whole database just backup up the portion of database that are changed after taking complete backup.

Report message to a moderator

Re: catalog [message #263099 is a reply to message #263077]

Wed, 29 August 2007 01:21

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

catalog is a database used for storing RMAN backup and recovery information. If you dont use catalog database, this info is stored in the control file of the database. It is recommended to use a catalog database.

Report message to a moderator

Re: catalog [message #263100 is a reply to message #263077]

Wed, 29 August 2007 01:26

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

how to solve this problem..

RMAN> recover database;

Starting recover at 29-AUG-07
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/29/2007 11:46:32
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database reco
ver if needed
start
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\RND\SYSTEM01.DBF'

Report message to a moderator

Re: catalog [message #263101 is a reply to message #263077]

Wed, 29 August 2007 01:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

cannot recover data file 1 - file is in use or recovery

It usually make no sense you are using a file and you are performing media recovery. File that you need to perform media recovery must not be online.

Report message to a moderator

Re: catalog [message #263109 is a reply to message #263077]

Wed, 29 August 2007 01:49

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

how to solve this problem...

E:\>rman catalog=rman/rman@rnd target=dev/dev@rnd

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Aug 29 12:11:30 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: RND (DBID=1249640031)
connected to recovery catalog database

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 08/29/2007 12:12:00
RMAN-06428: recovery catalog is not installed

RMAN>

Report message to a moderator

Re: catalog [message #263111 is a reply to message #263100]

Wed, 29 August 2007 01:51

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please read Database Backup and Recovery Basics or at least Database Backup and Recovery Quick Start Guide.

Regards
Michel

Report message to a moderator

Re: catalog [message #263112 is a reply to message #263077]

Wed, 29 August 2007 01:51

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

It is recommended to use a catalog database.

Where? Oracle recommend or you?

Oracle!!! obviously not unless you need a long long history of backup.

Rather oracle recommends to proceed without it + backup controlfile autobakcup enable, dbid backup+backup logs.

Report message to a moderator

Re: catalog [message #263115 is a reply to message #263077]

Wed, 29 August 2007 01:55

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

thanks to all of you...

Report message to a moderator

Re: catalog [message #263156 is a reply to message #263112]

Wed, 29 August 2007 04:23

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

Arju...

Quote:

Quote:
It is recommended to use a catalog database.

Where? Oracle recommend or you?

Oracle!!! obviously not unless you need a long long history of backup.

Follow this metalink document 452529.1 and you will find "WHERE/WHO" recommends...read the first line atleast

[Updated on: Wed, 29 August 2007 04:24]

Report message to a moderator

Re: catalog [message #263170 is a reply to message #263077]

Wed, 29 August 2007 04:40

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I don't have account in metalink. I will try to get it.

Report message to a moderator

Previous Topic:	can i delete rman backups
Next Topic:	cron tab entry not succeeding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 16:07:16 CDT 2024