EBSR12.2 cloning

[Roshan]

Hello Erman,

I used to do cloning of EBSR12.2 by putting the system and database down to perform the backup of database and copy it to target. but clients are making complaints because of this. So I am planning to do online backup.

i am reviewing your post on EBSR12.2 cloning
http://ermanarslan.blogspot.com/2014/07/ebs-122-cloning-real-life-example.html

I have a few questions on RMAN backup for the database.

1. In section Backing up to database online (with rman) :
what does the line below do? which part do I need to specify the directory?
backup device type disk format '/yedek/Bck_For_Clone/%d_full_%s_%p.bck' database plus archivelog;

piece handle=/yedek/Bck_For_Clone/DBERP_full_10_1.bck tag=TAG20140702T110301 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-JUL-14

2. Duplicating/ Opening the cloned database on the Target Database Server:


"Connect to target , modify your pfile according to your needs, create an spfile and startup nomount your database with the new name on the target server.
Also set your db_file_name_convert, log_file_name_convert parameters before duplicating the db.
db_file_name_convert=(+DATA,/+DATAERMAN)
log_file_name_convert=(+DATA,+DATAERMAN)"

what do I need to modify in the pfile?
how do I set set your db_file_name_convert, log_file_name_convert parameters ?

Thanks and Regards,
Roshan

[ErmanArslansOracleBlog]

Hi Roshan,
Your questions are based on problems. You are asking rman backup syntax and requesting  basic information line by line it is not the purpose of my blog or my forum.

You want to understand the process and learn the commands i guess.
That 's why, I suggest you to read; Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

Follow this document and read by blog posts in addition to that document.

[Roshan]

Hi,

ok. no problem. I am new to RMAN. so no problem. I will manage.

Thanks
Roshan

[Roshan]

Hello,

in section Duplicating/ Opening the cloned database on the Target Database Server:

I have modified the pfile and included the path directories of the target system.

i have created the spfile and when I am doing startup nomount it says:
ORA-00845: MEMORY_TARGET not supported on this system


I did df -h it gives me:

[oracle@erpvision dbs]$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda5        15G  3.9G   11G  28% /
tmpfs            16G  2.4M   16G   1% /dev/shm
/dev/sda1       3.0G  138M  2.7G   5% /boot
/dev/sda2        20G  175M   19G   1% /tmp
/dev/sda6       538G  205G  306G  41% /u01

Thanks and Regards
Roshan

[ErmanArslansOracleBlog]

İt s normal. Yolu need to configure your OS for this. Read the manuals. You
need to confugure dev shm , tmpfs first.

[ErmanArslansOracleBlog]

As a root user,
mount -t tmpfs shmfs -o size="SIZE OF YOUR MEMORY TARGET IN GIBABYTES" /dev/shm

to make it persistent across reboot ad the following in your fstab;

shmfs /dev/shm tmpfs size="SIZE OF YOUR MEMORY TARGET IN GIGABYTES" 0

Error:

ORA-00845: MEMORY_TARGET not supported on this system.
The cause of this error is an insufficient /dev/shm allocation. The total memory size of the SGA and PGA, which sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory file system (/dev/shm) on your operating system.

[Roshan]

can you please advise to what value I set it?

[root@erpvision appsutil]# free
             total       used       free     shared    buffers     cached
Mem:      32872496   32267644     604852          0    1233640   23945028
-/+ buffers/cache:    7088976   25783520
Swap:     16777208         56   16777152

now I am getting SQL> startup nomount
ORA-27102: out of memory
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 1
Additional information: 1245192
Additional information: 8

[ErmanArslansOracleBlog]

Set it equal or a little higher than your memory target value

[Roshan]

thanks.

now when I do

 startup nomount pfile='/u01/clone/db/11.2.0/dbs/initPREPROD.ora'
LRM-00109: could not open parameter file '/u01/clone/db/11.2.0/dbs/initPREPROD.ora'
ORA-01078: failure in processing system parameters

[ErmanArslansOracleBlog]

You need to have this file in place:
/u01/clone/db/11.2.0/dbs/initPREPROD.ora

[ErmanArslansOracleBlog]

For ORA-27102: out of memory , you need to adjust the kernel limits.
Please read the manuals. Read the Oracle Documents for this. (shmmax, shmni and etc..)

Oracle Kernel Parameters For Several Instances On Linux (Doc ID 948578.1)

You really need to read and follow documents.

[Roshan]

Thanks