Restore 9iRAC on standalone server

[Benoît]

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

[D Block 2]

You might want to seek help with:
http://metalink.oracle.com

[Yogeeraj_1]

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

[Benoît]

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 · Accepted solution]

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]

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

Thanks a lot.