The Oracle Instructor
A nice Oracle Database 12c New Feature enhances the multisection backup, introduced in 11g: You can use it now for image copies also!
RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name PRIMA List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 347 SYSTEM YES /u01/app/oracle/oradata/prima/system01.dbf 2 235 SYSAUX NO /u01/app/oracle/oradata/prima/sysaux01.dbf 3 241 UNDOTBS1 YES /u01/app/oracle/oradata/prima/undotbs01.dbf 4 602 USERS NO /u01/app/oracle/oradata/prima/users01.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 40 TEMP 32767 /u01/app/oracle/oradata/prima/temp01.dbt RMAN> configure device type disk parallelism 2; new RMAN configuration parameters: CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; new RMAN configuration parameters are successfully stored RMAN> backup section size 301m as copy datafile 4; Starting backup at 29-JUN-15 using channel ORA_DISK_1 using channel ORA_DISK_2 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/oradata/prima/users01.dbf backing up blocks 1 through 38528 channel ORA_DISK_2: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/oradata/prima/users01.dbf backing up blocks 38529 through 77056 output file name=/u02/fra/PRIMA/datafile/o1_mf_users_bs2v934z_.dbf tag=TAG20150629T180658 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15 output file name=/u02/fra/PRIMA/datafile/o1_mf_users_bs2v934z_.dbf tag=TAG20150629T180658 channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:15 Finished backup at 29-JUN-15 RMAN> host 'ls -rtl /u02/fra/PRIMA/datafile/'; total 616468 -rw-r-----. 1 oracle oinstall 631250944 Jun 29 18:07 o1_mf_users_bs2v934z_.dbf host command complete
We use that by default now especially also upon the DUPLICATE DATABASE command.
Tagged: 12c New Features, Backup & Recovery, RMAN
In 12c, we have introduced online datafile movement as a new feature. Now does that impact an existing standby database? I got asked that yesterday during an online webinar. My answer was that I expect no impact at all on the standby database since redo apply doesn’t care about the physical placement of the datafile on the primary. But I added also that this is just an educated guess because I didn’t test that yet. Now I did:
You know, I like to practice what I preach: Don’t believe it, test it! :-)
Tagged: 12c New Features, Data Guard
Tired of boring slide-shows? Join me for free to see Oracle core technology live in action!
Live demonstrations have always been a key part of my classes, because I consider them one of the best ways to teach.
This is your opportunity to have a glimpse into my classroom and watch a demo just as I have delivered it there.
Apparently, not many speakers are keen to do things live, so the term Demonar (Demonstration + Seminar) waited for me to be invented :-)
A positive effect towards your attitude about LVC and Oracle University Streams with its live webinars is intended, since the setting and platform is very similar there.
I get often asked by customers about my schedule, so they can book a class with me. This page now shows my scheduled Live Virtual Classes. I deliver most of my public classes in that format and you can attend from all over the world :-)
The Oracle Certified Master Exam is among the highest rated exams in the IT industry for a good reason: It is extremely hard to pass!
Unlike most other IT exams that are done as multiple choice tests, the OCM exam means two days of hands-on practical tasks. No chance you can pass it by just reading books or brain dumps and learning by heart without deep understanding. Without years of practical experience with Oracle database administration – don’t even think about it. Even as a seasoned DBA, you won’t find it easy to pass the OCM exam. Why is that so?The tested topics have a very broad range and some of them are likely outside your comfort zone
Your usual tools (e.g. scripts and google) are not available
There is very limited time to complete the tasks
The exam is exhausting, so after a while oversights become a severe danger
To help you prepare for the exam, we offer a quite useful class: Oracle Database 11g: OCM Exam Preparation Workshop Ed 2
I delivered it many times and it is probably the best preparation you can get – but also expensive, I admit.
I use to give following guidance to the attendees of the workshop – and the last two paragraphs may help you even if you don’t attend it:During the OCM Preparation Workshop:
Go beyond your comfort zone and put additional focus on the topics you are not yet so familiar with
Notify the pages in the documentation that you can copy from to resolve the tasks and memorize them
Check if & how the Enterprise Manager can help doing things more efficiently than manual procedures
Make sure that you are ABLE to do things manually in the absence of GUIs, though After the Workshop:
Create a sandbox environment (e.g. VirtualBox on your notebook)
Practice using only the Documentation!
Practice the things that you felt not so comfortable with during the workshop in the first place
Practice things from inside your comfort zone also, but with a (short!) time limit for the task During the Exam:
Read the tasks carefully and make sure that you understand them exactly BEFORE you begin working
If the order of tasks is not relevant, do the things first that you feel most comfortable about
Don’t waste too much time on a problematic task if other things can be done instead
You don’t need 100% to pass – so keep up your confidence even if you couldn’t complete all tasks
It is of course possible to prepare also without the workshop. See here for an impressive description about it. Good luck with your journey to become an OCM and I hope you find this little article helpful :-)
Many thanks to the board for organizing this event, I really enjoyed being there! Actually, the Broker demonstration went not so smoothly – always dangerous to do things live – but I managed to get out of the mess in time and without losing too much of the message I wanted to get through. At least that’s what I hope ;-)
I took the opportunity to do some sightseeing in New York as well: