Home » Server Options » RAC & Failsafe » Questions about Backup, Recover ,RAC DB (10G RAC windows 2003)
Questions about Backup, Recover ,RAC DB [message #431720] Thu, 19 November 2009 04:22 Go to next message
mamingui
Messages: 83
Registered: July 2006
Member
Hi All,

I have some questions regarding RAC Backup and Recover:
I have 2 nodes; each node are in archivelog with differents destinations for the archive logs. each node cannot see where are the archive logs for the other node.
I'm using a Rman catalog and I have register Database name in this catalog. I mean, I don't register instance1 and instance2 but the global instance. So, my target is the global instance.
Here are my questions

1) Is it correct to register in the catalog global instance ?
2) In case of recover, I have to connect node after node to recover or only in one node (because archive logs are in separate destinations)
3) How to backup archived logs in a script for the both instances ?

Thank you in advance for your help

Regards


Re: Questions about Backup, Recover ,RAC DB [message #431733 is a reply to message #431720] Thu, 19 November 2009 05:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
RMAN behavior is same in single instance or RAC.
>>I have 2 nodes; each node are in archivelog with differents destinations for the archive logs. each node cannot see where are the archive logs for the other node.
Not recommended approach.
It better to make archivelog destination in a shared area or atleast cross mounted in both nodes.
The archivelog destination should be visible from both nodes.
During backup, you connect only to one of the instances and backup.
The archivelogs from both instances are backed up, provided they use a common area.
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/rmanops.htm#i472630
Re: Questions about Backup, Recover ,RAC DB [message #431805 is a reply to message #431720] Thu, 19 November 2009 10:59 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thanks Mahesh,

So I have to register to my catalog each instance one by one ? because you said that "During backup, you connect only to one of the instances and backup.
"
Please confirm.

Thanks in advance
Re: Questions about Backup, Recover ,RAC DB [message #431823 is a reply to message #431805] Thu, 19 November 2009 11:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You register the database. Not the instance.
You connect to a specific instance and backup the database.
RAC has several instances and one database.

>> because you said that "During backup, you connect only to one of the instances and backup.
That is with assumption that the archives are in a shared area.
Else
You can connect to all available instances and backup (use a separate single-instance mode tnsentry instead of RAC entry).

It is all said in the documentation link provided.
Also look into this discussion.
http://forums.oracle.com/forums/thread.jspa?threadID=537755
Re: Questions about Backup, Recover ,RAC DB [message #432023 is a reply to message #431720] Fri, 20 November 2009 08:03 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thx for your help

this settings in my init.ora doesn't work :

mvdbcg1.log_archive_dest_1='location=M:\Archives174\'
mvdbcg2.log_archive_dest_1='location=M:\Archives176\'

I got these errors :

LRM-00101 : unknown parameter name 'mvdbcg1.log_archive_dest_1'
LRM-00101 : unknown parameter name 'mvdbcg2.log_archive_dest_1'
ORA-01070 : failure in processing system parameters

What is wrong ? I want to be sure than each instance can see archived redo logs from other nodes because I'm using separate destination.

Thx aagain for your help
Re: Questions about Backup, Recover ,RAC DB [message #432052 is a reply to message #432023] Fri, 20 November 2009 12:56 Go to previous messageGo to next message
BlackSwan
Messages: 22902
Registered: January 2009
Senior Member
post results from following:

SQL> show parameter archive
Re: Questions about Backup, Recover ,RAC DB [message #432063 is a reply to message #431720] Fri, 20 November 2009 14:53 Go to previous messageGo to next message
mamingui
Messages: 83
Registered: July 2006
Member
Thank you BlackSwan but

SQL> show parameter archive;

I'm not connected !!
I just want to try the example I see in the documentation
"Example 7-1 Example Configuration for the initialization parameters file

sid1.log_archive_dest_1 = (location=/arc_dest_1)
sid2.log_archive_dest_1 = (location=/arc_dest_2)
sid3.log_archive_dest_1 = (location=/arc_dest_3)"
Re: Questions about Backup, Recover ,RAC DB [message #432066 is a reply to message #432023] Fri, 20 November 2009 17:26 Go to previous message
BlackSwan
Messages: 22902
Registered: January 2009
Senior Member
>What is wrong ?
oerr LRM 101
101, 0, "unknown parameter name '%.*s'"
// *Cause: The parameter name was misspelled.
// *Action: Spell the parameter name correctly.

I am confused about the ORA-01070 posted error - see below

SQL> !oerr ora 01070
01070, 00000, "Using an old version of Oracle for the server"
// *Cause: Using pre 7.0.10.1 version of oracle for server
// *Action: Upgrade server to post 7.0.10.1 version

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE	10.2.0.4.0	Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

[Updated on: Fri, 20 November 2009 17:38]

Report message to a moderator

Previous Topic: taking backup of control file
Next Topic: ORA-25408
Goto Forum:
  


Current Time: Wed Oct 22 18:23:26 CDT 2014

Total time taken to generate the page: 0.08877 seconds