Home » RDBMS Server » Backup & Recovery » Recovery Catalog RMAN (Oracle 10g Enterprise Edition Release 10.2.0.1.0 - RHEL 4)
Recovery Catalog RMAN [message #405911] Sun, 31 May 2009 11:18 Go to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Hi,
Here i am describing my current procedure that how to connect to recovery catalog and target database to start backup and recovery through RMAN.

1. ssh oracle@192.168.1.37 ----> This is recovery catalog database.
2.[oracle@recovery_catalog oracle]$ rman catalog rmanbkp/rmanbkp
Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to recovery catalog database
3. connect target sys/oracle@target_database
connected to target database: ORCL (DBID=1203460058)
RMAN> From here i start backup and all these things

But i found in one of known oracle Press book like this

1. ssh oracle@192.168.1.20 --> This is the target databsae
2.[oracle@target_database oracle]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sun May 31 21:39:02 2009

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

connected to target database: ORCL (DBID=1203460058)
RMAN> rman catalog rmanbkp/rmanbkp@catdb
connect to recovery catalog database
RMAN>

Here i am confused whether both procedure is same or different. If same which should be adopted.
With regds
rajnish
Re: Recovery Catalog RMAN [message #405914 is a reply to message #405911] Sun, 31 May 2009 13:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Invoke RMAN and perform backup from the target machine.
Re: Recovery Catalog RMAN [message #405915 is a reply to message #405911] Sun, 31 May 2009 13:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The first one connect locally to rman catalog and remotely to target datase.
The second one do the opposite.
You can also remotely connect to both.

In the end, if you backup on disk, connect from the server that owns the backup disks.

Regards
Michel
Re: Recovery Catalog RMAN [message #406220 is a reply to message #405915] Tue, 02 June 2009 22:38 Go to previous messageGo to next message
fairdaus
Messages: 14
Registered: May 2009
Location: KL
Junior Member
yup fisrt u connect rman using internal mean rman read from your control file

connect target sys/oracle@target_database

second type u connect rman using other db mean rman connect db using catalog

rman target / catalog rman/abc123@test

example server A and server B

your db in server A and rman catalog in server B

but for connect using catalog u need register your db in rman catalog first

tq


Re: Recovery Catalog RMAN [message #406222 is a reply to message #405911] Tue, 02 June 2009 22:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
fairdaus,

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Recovery Catalog RMAN [message #406229 is a reply to message #405911] Tue, 02 June 2009 23:06 Go to previous message
fairdaus
Messages: 14
Registered: May 2009
Location: KL
Junior Member
example: fisrt method

server A : db name st2xxxx

you login rman direct to server

$rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jun 3 11:58:50 2009

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

connected to target database: ST2xxx (DBID=239983360)

RMAN>exit


example: second method

you have 2 database server A db name= ST2xxx and server B catalog rman=ufpxxx

login rman using catalog

$ rman target / catalog rman/password@ufpxxx

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jun 3 12:03:10 2009

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

connected to target database: ST2xxx (DBID=239983360)
connected to recovery catalog database

RMAN>

[Updated on: Tue, 02 June 2009 23:14]

Report message to a moderator

Previous Topic: ora-1194 and ora-1110
Next Topic: Recover from missing files(redo log file/control file)
Goto Forum:
  


Current Time: Fri Nov 22 07:57:35 CST 2024