| Questions about Backup, Recover ,RAC DB [message #431720] |
Thu, 19 November 2009 04:22  |
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 #432023 is a reply to message #431720] |
Fri, 20 November 2009 08:03  |
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 #432063 is a reply to message #431720] |
Fri, 20 November 2009 14:53 |
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 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
|
|
|
] 
Search
Help
Members
Register
Login
Home
