Oracle OpenWorld 2009; Are you Attending?

Oracle OpenWorld, the world's largest information technology event.

If you have plan for it; San Francisco: Oct 11-15 2009. oracle.com/openworld

Oracle OpenWorld offers:
- More than 1,800 sessions
- Hundreds of Oracle product demos
- Hands-on experience with full breadth of Oracle Technology
- Previews of what's coming next from Oracle and it's partners
- Networking opportunities with peers and thought leaders from around the world
- Keynotes from visionary leaders in business and technology

Oracle OpenWorld gives anything what for you?
Exactly! It gives the chance to improve your skills, and get the information and meet it's partners and meet with oracle product experts and improve your career and (get some stuffs from partner exhibits).

By the way, If you have free times at there; don't forgot to visit OTN Lounge. You'll find oracle guru (say 'Hi' with them), and enjoy with redbull ;)

One thing... don't forgot to do from this event. Connection ;)

Oracle OpenWorld Blog
Twitter
LinkedIn
Oracle Mix
Oracle Wiki
FaceBook

Read about Oracle OpenWorld Preview at Oracle Magazine.

If you're going to attend it... I wish you enjoy and hope to here your experience;)

(dd command) Voting Disk backup 11g; Cannot be done online

I read ... to improve skills and ideas on Oracle database 11g RAC Administration presentation.

I found... many things different idea 10gR2 RAC.

About "Back Up and Recover Your Voting Disks"...
That's sure we can backup by "dd" command ("ocopy" on windows)... & the block size for the dd command should be at least 4 KB and it's recommended to use symbolic links.

When Read... more! I found something different.

On 10gR2 RAC used "Can be done online" words ;)
A backup taken via the dd command can be a hot backup, which means that the Oracle Clusterware daemons do not need to be stopped in order to take this backup.

On 11g RAC used "Cannot be done online" words ;)
Before backing up your voting disk with the dd command, make sure that you stopped Oracle Clusterware on all nodes.

I don't know yet... why? or just recommend... But one thing, after install oracle clusterware, add node or delete node...on 11g RAC.
I won't forgot to backup voting disk. Cuz, I don't want to stop all nodes ;)

DB_FILES... think??? determine???

DB_FILES initialization parameter... why i should to think about it?

When starting Oracle database instance, DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and maximum number of datafiles that can be created for the instance.
Anyway we can change... (but we have to shutdown/startup)

So, if value of DB_FILES is too low, we cannot add datafiles beyond the DB_FILES limit, so we have to shutdown+startup database for changing DB_FILES value.
if value of DB_FILES is too high, memory is unnecessarily consumed.

SQL> create tablespace a01 datafile '+DATA1' size 20M;
create tablespace a01 datafile '+DATA1' size 20M
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

We have to change DB_FILES (if use spfile):

SQL> show parameter db_files

NAME TYPE VALUE
---------------------------------------------------------
db_files integer 200

SQL> alter system set set db_files=500 scope=spfile;

SQL> shutdown immediate

SQL> startup

RAC... How?

We have to shutdown all nodes and startup them.
Because, we may find Error: ORA 1174
Text: DB_FILES is aaa but needs to be bbb to be compatible

Just think and determine about number of datafile... if don't want to maintenance to change it.

By the way, Determine DB_FILES initialization parameter... so don't need to interest MAXDATAFILES parameter specifies on control file.

If we attempt to add a new file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, the control file will expand automatically so that the datafiles section can accommodate more files.