No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
How to Restore RAC RMAN backup to stand alone
| Message |
Score |
Author |
Date |
   Hi All,
Do someone having any doc for "Restore ...... |
|
Mohit Jain |
Aug 09, 2012, 10:24 |
|
Yes, there is no problem restoring RAC to standa...... |
|
Michel Cadot |
Aug 09, 2012, 10:38 |
| Thanks Michel,
and after this RMAN restore can ...... |
|
Mohit Jain |
Aug 09, 2012, 10:41 |
|
Yes until you open this database.
If you open ...... |
  |
Michel Cadot |
Aug 09, 2012, 11:00 |
| Hi,
I had done this few times in past and prepare...... |
|
Farooq Khalid |
Aug 13, 2012, 16:24 |
| Subject: |
How to Restore RAC RMAN backup to stand alone |
| Author: |
Mohit Jain, India |
| Date: |
Aug 09, 2012, 10:24, 3950 days ago |
| Os info: |
Oracle Redhat Linux 5.6 |
| Oracle info: |
11.1.0.7 |
| Message: |
Hi All,
Do someone having any doc for "Restore RAC 2 node DB RMAN backup to stand alone DB"
and after creating the standalone DB can we keep on applying the archieve log on this DB |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: How to Restore RAC RMAN backup to stand alone |
| Author: |
Michel Cadot, France |
| Date: |
Aug 09, 2012, 10:38, 3950 days ago |
| Message: |
Yes, there is no problem restoring RAC to standalone.
The only thing to think is after restoring the spfile (if this is your case) you have to create an init.ora file and change all RAC parameters to standalone one, for instance "cluster_database" to FALSE, "cluster_database_instances" to 1, "instance_number" to 0... and restart the instance with this init.ora file before going on with the recovery.
Regards
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: How to Restore RAC RMAN backup to stand alone |
| Author: |
Mohit Jain, India |
| Date: |
Aug 09, 2012, 10:41, 3950 days ago |
| Message: |
Thanks Michel,
and after this RMAN restore can we keep on applying the archieve log on this DB generated on the RAC DB ?
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: How to Restore RAC RMAN backup to stand alone |
| Author: |
Michel Cadot, France |
| Date: |
Aug 09, 2012, 11:00, 3950 days ago |
| Score: |
|
| Message: |
Yes until you open this database.
If you open it you lose the link with the original database, it becomes a new and independent incarnation that is a new database.
Regards
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: How to Restore RAC RMAN backup to stand alone |
| Author: |
Farooq Khalid, United States |
| Date: |
Aug 13, 2012, 16:24, 3946 days ago |
| Message: |
Hi,
I had done this few times in past and prepared a quick documentation reference.
check this link.
http://farooqkhalid.blogspot.com/2010/03/convert-oracle-rac-database-to-single.html
Hope this help. |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|