Posts tagged 11g

How to duplicate database for standby

5 months ago in , (0 comments)

This is not the first scratchpad sample of duplicating a database for standby you’ve seen, and by no means comes close to the official Oracle documentation.  Its intention is simply for those that don’t use this process often and need a quick reference.

1. You need to startup nomount the standby instance with the bare minimum requirements

DB_NAME=’dbstdby’
DB_UNIQUE_NAME=’dbstdby’
DB_CREATE_FILE_DEST=’C:\Oracle\dbdata\’

2. Connect to rman (in this case with nocatalog)

rman TARGET sys/pwd@db1 AUXILIARY sys/pwd@dbstdby

3. Run your duplicate script (make any other necessary changes for your environment)

RUN {
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name='dbstdby'
set db_file_name_convert='C:\Oracle\dbdata\db1\DATAFILE','C:\Oracle\dbdata\dbstdby\DATAFILE'
set log_file_name_convert='C:\Oracle\dbdata\db1\ONLINELOG','C:\Oracle\dbdata\dbstdby\ONLINELOG'
set control_files='C:\Oracle\dbdata\dbstdby\stby_control01.ctl'; }

Need help?  Free development help, leave a comment or contact us to see how we can help your organization with Oracle database management and support.

automated statistics gathering

2 years ago in (0 comments)

If you are looking for the GATHER_STATS_JOB in Oracle 11g, then stop looking.  In 11g, this job is part of the daily Oracle Maintenance window, but it is executed as an autotask.  Take a look at this Oracle link.

To check if it exists and enabled, use this simple SQL.

select * from dba_autotask_client where client_name = ‘auto optimizer stats collection’;

Or, to check the log:

select count(*) from dba_scheduler_job_log where additional_info like ‘%GATHER_STATS_PROG%’;

I hope this will save you some [research] time.

Oracle OpenWorld 2007

4 years ago in (0 comments)

I am spending the week in San Francisco at Oracle’s OpenWorld. This is the “premier” Oracle event. Oracle takes the opportunity to talk about progress (over the years), introduce new products, and discuss its road-map. This years’ event attracted over 43,000 attendees.

San Francisco is a great city to see (that’s later in the week), but my purpose here is to come up to speed on Oracle’s flagship product, their Database, and see how it can be applied/managed better for our customers. The new Oracle Database 11g has a handful of new features including things that stood out in the crowd – at least for me: Database Replay (change management), Fault Diagnosability Infrastructure (similar to the OFA idea), RMAN improvements (such as active database duplication), DataPump enhancements (additional encryption support, AES), tablespace encryption, and statistics improvements to mention a few.

Since I work quite a bit with embedded Oracle installations, I was disappointed to see that Oracle hasn’t made any changes to the way it’s embedded database technology works – besides introducing OracleLite. Well, I take that back. One thing that they’ve done is to update the Embedded Database Readme and Installation docs… Here is one major problem I have with the current process, and it just irks me:

  • Ability to deliver the just the install files necessary to support the customer environment, and not the the entire 1.76GB folder!

This is a huge disadvantage if you ever consider delivering the application over the FTP. Besides this “minor” drawback, the embedded database works pretty well – as long as you have all your database maintenance schedules in place.

For today, I’m checking out. Let’s see what tomorrow holds at the Moscone Center… Ciao.

Go to Top