-
there are three questions
1)what are the steps involved in cloning a database
2)I have cold backup 0f 8.1.5 database which i want to clone in a 8.1.6 environment
3)what are the steps involved in migrating from 8.1.5 to 8.1.6
in solaris 2.8 environment
-
1.take a backup of control file binary.
alter database backup controlfile to trace;
2.Look at the user_dump_dest for the trace file created at the time the command was executed the above command.
3.This controlfile will contain a sql script for create a new database.
4.Then in the new database after installing the oracle binary.
start the database in nomount stage.
5.execute the script got for above controlfile.If you want to change the drive name or datafile name you can do it.
6.Once the command is executed.
7.Restore the datafile of your source database to the new clone database.
8.execute the command, 'recover database';
9.You will have a new database,an exact clone of you old database.
regards
anandkl
anandkl
-
Hi,
Cloning a database means creating a copy of production database onto another machine which can act as a standby database if incase your primary database fails ,your standby database can act as your primary database.See standby database manual to create a standby database.
In order to migrate from 8.1.5 to 8.1.6 in Solaris 2.8 enviroment you can clone in 2 different ways
Way 1:Take a cold database backup of datafiles.controlfiles,logfiles .Unistall Oracle 8.1.5 .Install Oracle 8.1.6 in different ORACLE_HOME and restore the cold backup.
Way 2:Take an full export of the database.Uninstall Oracle 8.1.5 ,Install Oracle 8.1.6 software and import the full database export.
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
oracle-support@indiatimes.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|