Home » RDBMS Server » Backup & Recovery » catalog
catalog [message #263077] Wed, 29 August 2007 00:45 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
what is catalog? please explain..

thanks and regards,
Anamika
Re: catalog [message #263079 is a reply to message #263077] Wed, 29 August 2007 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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

Re: catalog [message #263085 is a reply to message #263077] Wed, 29 August 2007 00:58 Go to previous messageGo to next message
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.
Re: catalog [message #263087 is a reply to message #263077] Wed, 29 August 2007 01:00 Go to previous messageGo to next message
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
Re: catalog [message #263090 is a reply to message #263077] Wed, 29 August 2007 01:05 Go to previous messageGo to next message
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.
Re: catalog [message #263099 is a reply to message #263077] Wed, 29 August 2007 01:21 Go to previous messageGo to next message
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.
Re: catalog [message #263100 is a reply to message #263077] Wed, 29 August 2007 01:26 Go to previous messageGo to next message
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'
Re: catalog [message #263101 is a reply to message #263077] Wed, 29 August 2007 01:29 Go to previous messageGo to next message
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.
Re: catalog [message #263109 is a reply to message #263077] Wed, 29 August 2007 01:49 Go to previous messageGo to next message
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>
Re: catalog [message #263111 is a reply to message #263100] Wed, 29 August 2007 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: catalog [message #263112 is a reply to message #263077] Wed, 29 August 2007 01:51 Go to previous messageGo to next message
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.
Re: catalog [message #263115 is a reply to message #263077] Wed, 29 August 2007 01:55 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks to all of you...
Re: catalog [message #263156 is a reply to message #263112] Wed, 29 August 2007 04:23 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: can i delete rman backups
Next Topic: cron tab entry not succeeding
Goto Forum:
  


Current Time: Sat Dec 10 04:51:31 CST 2016

Total time taken to generate the page: 0.08679 seconds