Тёмный

RMAN Duplicate Database to Same SID 

DBA Genesis
Подписаться 37 тыс.
Просмотров 11 тыс.
50% 1

We will be using #RMAN duplicate from active #database to copy prod database on clone #server while keeping the #SID same. Full Article: www.support.dbagenesis.com/po...
03:32 - Configure listener on clone
04:57 - Configure a TNS entries on prod
07:31 - Copy Password file & pfile to clone
09:50 - Create all the location on clone
10:56 - Take clone database to nomount stage
16:24 - Duplicate the database via RMAN duplicate
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука

Опубликовано:

 

23 мар 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 41   
@parasharampakhari1583
@parasharampakhari1583 Год назад
The way you explain is fantastic i am really injoy your all videos while watching. Thanks for fabulous topic.
@dbagenesis
@dbagenesis Год назад
It's my pleasure
@karthibanvenkatachalam5803
@karthibanvenkatachalam5803 3 года назад
Hi Arun, Such an awesome explanation!!even iam getting job as oracle DBA position by watching your RU-vid playlists only.As you said those playlists are simple straight forward keep posting more videos regarding dba tasks. Thanks!!
@durgavenkatesh2114
@durgavenkatesh2114 3 года назад
Thanks Arun ! Your a tourch barer of DBAs
@tariqislam918
@tariqislam918 2 года назад
Well explained step by step RMAN cloning procedure! Thanks for sharing.
@dbagenesis
@dbagenesis 2 года назад
Thank you Keep Watching!
@sagarreddy4768
@sagarreddy4768 3 года назад
Excellently explained. So easy to understand the concept with live explanation. Thank you Arun..
@dbagenesis
@dbagenesis 3 года назад
Keep watching
@arungupta5528
@arungupta5528 Год назад
@@dbagenesis bhaiya aapke paas complete dba video hai?
@shadowtruth6102
@shadowtruth6102 3 года назад
Arun Thank you. you are definitely a master and this video is a masterpiece.
@dbagenesis
@dbagenesis 3 года назад
You are very welcome buddy!
@hebert2s
@hebert2s Год назад
Amazing!!! Excellent!!! Thanks for share your Knowledge
@dbagenesis
@dbagenesis Год назад
Glad you liked it!
@pankajsingh-qi8rh
@pankajsingh-qi8rh 3 года назад
Thanks for starting again👍... Please cover oracle licensing....so company may aware of it.. oracle hardly do audit... When do DBA are not aware.
@pythiasdebrakins8936
@pythiasdebrakins8936 3 года назад
Job well done Arun!
@dbagenesis
@dbagenesis 3 года назад
Thanks man!
@manukapoor7811
@manukapoor7811 2 года назад
Brilliant !! 👍🏻
@dbagenesis
@dbagenesis 2 года назад
Thank You Keep Watching!!
@albertogonzalez5114
@albertogonzalez5114 3 года назад
thanks!
@Rajesh_Bandi
@Rajesh_Bandi 3 года назад
Excellent
@dbagenesis
@dbagenesis 3 года назад
Thanks
@RadeckiRadzik
@RadeckiRadzik 2 года назад
SUPER ! THX
@dbagenesis
@dbagenesis 2 года назад
Thank you too!
@sainandakuruba9579
@sainandakuruba9579 2 года назад
TQ sir please make more videos in oracle DBA ❤️
@dbagenesis
@dbagenesis 2 года назад
Sure I will
@vrushalijwalesh1901
@vrushalijwalesh1901 3 года назад
Nice explanation Arun. Thank you. As you said this method is for only small DB's,, so can you please tell appx size of DB.
@MrEnrique2k
@MrEnrique2k 3 года назад
isnt safer to do the duplicate from test ? what is the point of running duplicate from the source and not the target ? is it the Rman push feature ?
@josemontemayor8590
@josemontemayor8590 2 года назад
Thank you. Could you advice me if I can do the same RMAN Duplicate steps to same SID from source DB 12c but the target server has 19c installed. I am planning to to cloning(migration) and upgrade to 19c at the same time.
@dbagenesis
@dbagenesis Год назад
Kindly post your query on forum.dbagenesis.com
@pratyakshdwivedi3298
@pratyakshdwivedi3298 3 года назад
What in case if the source database is in no archive log mode...??
@chinnawatw
@chinnawatw 3 года назад
Can I run this script in cron to take backup every hour ? Will rman replace/handle old data in auxiliary database automatically on next run ?
@emmalottotv2529
@emmalottotv2529 2 года назад
thnaks Arun, can we connect to RMAN catalog and run the duplicate command
@pratyakshdwivedi3298
@pratyakshdwivedi3298 3 года назад
Could we clone the DB then also drom active source db
@rajatsanwal9919
@rajatsanwal9919 2 года назад
Arun sir, our target db is in nomount mode, how can we even connect to it from source ?
@dbagenesis
@dbagenesis 2 года назад
The TNS entries will connect to target listener and listener will connect to DB instance which is not mounted. Thats how the RMAN DUPLICATE works.
@DeviL_07s
@DeviL_07s 2 года назад
When performing dublicate command it give error which shows no backup or directory file for control file
@dbagenesis
@dbagenesis 2 года назад
You must have taken a DB backup before starting duplicate command
@DeviL_07s
@DeviL_07s 2 года назад
@@dbagenesis yes i have a backup
@oracledemo7027
@oracledemo7027 2 года назад
i think you have not created the directory structure for control file
@tcereghini
@tcereghini 3 года назад
Doesn't it get confusing in RMAN when using the same SID?? "PROD" "PROD"
Далее
Types of RMAN backups and RMAN components
20:31
Просмотров 71 тыс.
Why Rebuild Indexes? | #dailyDBA 20
30:50
Просмотров 25 тыс.
Oracle Database 19c REFRESH using RMAN and DATA PUMP
49:28
Oracle Data Guard Client Connectivity TNS Entries
34:42
Oracle Database: ACTIVE Database DUPLICATION using RMAN
38:37
Подключил AirPods к Xbox
0:45
Просмотров 27 тыс.