rman backing up standby DB

All:

If you see below I am using rman to connect to stdby db but rman thinks it is connected to primary db.


From tnsnames.ora

STDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.3.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stdby)
)
)


$ rman target sys/sys@stdby CATALOG rman/rman@CATalog
Recovery Manager: Release 10.2.0.1.0 - Production on Sat May 9 17:42:41 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PRI (DBID=615014014)
connected to recovery catalog database

As you can this connects me to my primary database. Is it possible to use
rman to backup a standby DB.

DUH! You are OK, the db name and dbid are the SAME as the primary.
:rolleyes:
PS:
To be more sure, just type:

rman target / CATALOG rman/rman@CATalog
.

So are you saying that I can't use RMAN to backup the standby database? If this is a case, how does one backup the standy by database?

Same commands as you would the primary!
:p

Quote:

---

Originally Posted by PaulH

So are you saying that I can't use RMAN to backup the standby database? If this is a case, how does one backup the standy by database?

---

In order to backup a database with rman, the database either needs to be mounted or open. So if a standby is actie, then it is mounted, hence it should work. Although if you really want to know whether or not it works, you should try to restore that backup elsewhere.

Quote:

---

Originally Posted by LKBrwn_DBA

DUH! You are OK, the db name and dbid are the SAME as the primary.
:rolleyes:
PS:
To be more sure, just type:

rman target / CATALOG rman/rman@CATalog
.

---

Any suggestions??

$ echo $ORACLE_SID
stdby


$ rman target / CATALOG rman/rman@CATalog

Recovery Manager: Release 10.2.0.1.0 - Production on Mon May 11 18:51:13 2009

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

connected to target database: PRI (DBID=615014014)
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 05/11/2009 18:51:58
RMAN-08040: full resync skipped, control file is not current or backup

If primary is registered, then standby is also registered.
If primary is NOT registered, then you need to register the primary.
;)