How to clone a 10g DATABASE

[4iappsDBA]

Dear DBA Brother,

Give some Idea to clone a small database.
Please give me step by step process before and till make the database online !

[stecal]

RMAN

duplicate database

[gandolf989]

If you want more detail, then here is the rman command:

RUN {
  ALLOCATE CHANNEL C1 DEVICE TYPE 
    DISK format '/oracle/rman/idm/bck_20100303';
  RESTORE DATABASE;
  RECOVER DATABASE;
}

Of course you need to make sure that you have your environment setup, a pfile or spfille, a good backup, if you are changing directory names when you clone then you can specify the following in your pfile/spfile:

db_file_name_convert=(${SOURCE_SID},${TARGET_SID})
log_file_name_convert=(${SOURCE_SID},${TARGET_SID})

I suppose you could always check out the documentation online at http://tahiti.oracle.com if you get desperate!

[4iappsDBA]

Thank u very much my dear brother,,

i hope it will helpful for everyone.

thank u very much again,,