possible to clone a database with cold backup across diff unix platform ?

[ngwh]

hmm...instead of us OS pipe(as in NFS??) wouldn't it be better to us exp via oracle network ??

[sambavan]

Why all these hassels? do the following and it will all be easier.

Use RMAN.

1. Make sure that the Target DB uses the remote_login_password_file=exclusive and there is a passwordfile for it.

2. Create a user account with the SYSDBA & SYSOPER roles

3. Take an RMAN cold backup on the target database.
(Remember to specify the backup directory in the format)

4. Copy all those backups to the HP system, under the same directory location, where it was backed up

5. Copy the controlfile, change the DBname, and other parameters

6. Connect to target and auxillary through rman

7. Issue the database duplication command. (This will change the DBID for the new database)

8. You are done.


This would be a clean approach.

Thanx,
Sam

[gandolf989]

Originally posted by sambavan
Why all these hassels? do the following and it will all be easier.

Use RMAN.

1. Make sure that the Target DB uses the remote_login_password_file=exclusive and there is a passwordfile for it.

2. Create a user account with the SYSDBA & SYSOPER roles

3. Take an RMAN cold backup on the target database.
(Remember to specify the backup directory in the format)

4. Copy all those backups to the HP system, under the same directory location, where it was backed up

5. Copy the controlfile, change the DBname, and other parameters

6. Connect to target and auxillary through rman

7. Issue the database duplication command. (This will change the DBID for the new database)

8. You are done.


This would be a clean approach.

Thanx,
Sam

I agree with you Sam. However, not everyone uses rman. It is good for mainting test databases, which is what I used it for. We had a couple of shell scripts one to backup, one to restore, one to create a stand by database and one to clone a database.

[marist89]

Originally posted by sambavan
Why all these hassels? do the following and it will all be easier.

Use RMAN.

We're talking across platforms here. Rman (up to 9.2 anyway) won't work cross platforms.

[gandolf989]

Originally posted by marist89
We're talking across platforms here. Rman (up to 9.2 anyway) won't work cross platforms.

Whoops. Leave it to a Super-Genius to point out the obvious.

[sambavan]

Hi all,

I have split the thread, so that the topics does not interfear with the original post.

Ref http://www.dbasupport.com/forums/sho...threadid=44011

Thanx,
Sam