Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Restore 9iRAC on standalone server

SOLVED
Go to solution
Benoît
Regular Advisor

Restore 9iRAC on standalone server

Hi,

Is it possible to restore 9iRac database on a single standalone server?
9iRac Cluster is 2 node rp8400/HPUX11
Standalone server would be rp8400/HPUX11

If possible, what is the procedure?

Thanks

Ben
5 REPLIES
D Block 2
Respected Contributor

Re: Restore 9iRAC on standalone server

You might want to seek help with:
http://metalink.oracle.com
Golf is a Good Walk Spoiled, Mark Twain.
Yogeeraj_1
Honored Contributor

Re: Restore 9iRAC on standalone server

hi,

Detailed instructions on configuring RAC on a single node are provided on Metalink, however this configuration is not certified or supported by Oracle Support Services - they are provided for evaluation/educational purposes only.

see metalink note 241114.1 for some guidelines on the procedure.

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Benoît
Regular Advisor

Re: Restore 9iRAC on standalone server

Thanks for your answers guys.

Maybe I should be more precise...

I don't want to have a single node 9iRac database.
I just want replicate this database for a test platform. So on destination server I won't have 9iRac structure.
I've tried to restore my raw devices on this test platform, but then I never succeed to start the database on this platform.
I guess something is missing ...
Ariel Cary
Frequent Advisor
Solution

Re: Restore 9iRAC on standalone server

Hi Benoit,

That's pretty straightforward. Follow these general steps:

1. Take cold/hot backup of source database. dd on raws works fine or a 3rd party backup tool such as Data Protector which integrates with RMAN
(with this, you can restore your db on file system and forget about configuring raw devs on the target node)

2. Restore backup to raw devices or file system on the target system. Previously, you
have to install oracle binaries single instance or make a backup or source binaries and
recompile oracle without rac option.

3. Configure an initSID.ora file for the target system.
You can generate a pfile init.ora on the source system adn take it as baseline. But make
sure you comment out the cluster_database parameter or put it to false.
As minimum, you should configure
- instance_name = rac1
- instance_number = 1
- db_name = ttb
- db_block_size = 8192 # or your standard db_block_size
- cluster_database = false

Also, there should not be any instance specific parameter.

4. Startup mount the target instance.

5. Make appropiate changes to controlfile, e.g. to reflect new locations of raw devices/files on the target system.

6. If using Hot Backups, recover database with appropriate options,
e.g. sql> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
(you need archive logs)

7. Open database resetlogs
sql> ALTER DATABASE OPEN RESETLOGS;

HTH,

ARC
Benoît
Regular Advisor

Re: Restore 9iRAC on standalone server

It worked almost this way.
It was not necessary to recompile oracle because it's an entreprise version on both servers.

Thanks a lot.