NetApp - Databases

NetApp - I love this company!

Hi All,

This is neto from Brazil

How are you?

I am thrilled to announce that NetApp is ranked #1 on FORTUNE Magazine’s 2009 list of “100 Best Companies to Work for”.

http://money.cnn.com/magazines/fortune/bestcompanies/2009/index.html

Video: http://money.cnn.com/video/ft/#/video/fortune/2009/01/21/fortune-bctwf-netapp.fortune

Thank you NetApp for giving me the opportunity, pleasure and honor to be part of this family. Also, thanks for trust on my job.

On January, 29th, will be my NetApp Birthday, I will complete 8 years in a wonderful place; the best place to live!

On my prayers, I already said one thing to “Papai do Céu”:

“Papai do Céu", Thank You for all good things that you gave to me. I am grateful for what I have. “Papai do Céu”, you already gave to me one the best things that I have received… be part of NetApp Family. Thank You. I wish to be at NetApp for all my life.

I am humbled.

All the best

neto

NetApp - #1 Place to Work - I love this company!

Remote Connection using SnapDrive for Windows (SMO 2.2 Snapshots) to be used for TAPE Backups

Hi All,

This is neto from Brazil

How are you?

Here you go an example about remote connection using SnapDrive for Windows installed on Backup Server to connect consistent snapshots from SnapManager for Oracle 2.2 to be used for TAPE Backups.

Thank you very much my friends Ederson and Kleber for the pleasure and all support on this work.

Script to Connect

REM ##############################################################

@echo off

REM
REM CREATED BY Ederson Crippa (BSH CONTINENTAL), neto from Brazil (NetApp) and Kleber Silva (Columbia Storage)
REM

echo *** Setting Global Variables ***
echo ********************************
SET FILER=HORNA002
SET BACKUPSERVER=HORWNW01
SET CLUSTER=HORWDBCL01
SET VIRTUALSERVER=HORWDBCL01VS01

echo.
echo *** Mapping DATAFILES for Backup ***
echo ************************************
SET VOL=/vol/gfadata/.snapshot
SET LUN=GFADATA.lun
SET DEST_MAP=G:\HORPGFA\HORPGFA
SET DEST_SNAP=G:\HORPGFA
SET FILE=GF_RECENT_DATA.TXT

sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%

FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%

echo.
echo *** Mapping LOGS for Backup  ***
echo ********************************
SET VOL=/vol/gfalogs/.snapshot
SET LUN=GFALOGS.lun
SET DEST_MAP=G:\HORPGFA\ORALOGS
SET DEST_SNAP=G:\HORPGFA\ORALOGS
SET FILE=GF_RECENT_LOGS.TXT

sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%

FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%

echo.
echo *** Mapping ARCHIVES for Backup  ***
echo ************************************
SET VOL=/vol/gfaarch/.snapshot
SET LUN=GFAARCH.lun
SET DEST_MAP=G:\HORPGFA\ORAARCH
SET DEST_SNAP=G:\HORPGFA\ORAARCH
SET FILE=GF_RECENT_ARCH.TXT

sdcli snap list -m %VIRTUALSERVER% -d %DEST_SNAP% | GREP "Consistent snapshot copy" | head -1 | awk "{ print $1}" > %FILE%

FOR /F " tokens=*" %%A IN ('type %FILE%') DO SET label=%%A
sdcli disk connect -p %FILER%:%VOL%/%LABEL%/%LUN% -d %DEST_MAP% -IG %BACKUPSERVER% %BACKUPSERVER% -dtype dedicated -c %CLUSTER%

REM ##############################################################

 

Script to Disconnect

REM ##############################################################

@echo off

REM
REM CREATED BY Ederson Crippa (BSH CONTINENTAL), neto from Brazil (NetApp) and Kleber Silva (Columbia Storage)
REM

echo *** Disconnecting DATAFILES ***
echo *******************************

sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\HORPGFA\

echo.
echo *** Disconnecting LOGS ***
echo **************************
sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\ORALOGS\

echo.
echo *** Disconnecting ARCHIVES ***
echo ******************************
sdcli disk disconnect -m %BACKUPSERVER% -d G:\HORPGFA\ORAARCH\

REM ##############################################################

All the best

neto

NetApp - I love this company!

Oracle FailSafe – Part XVI – SMO Restore

Hi All,    

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – SMO Restore.

Restoring the database on REFRIGERATOR, originally backed up from OVEN.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

All the best

neto

NetApp – I love this company!

SMO – I love this product!

Oracle FailSafe – Part XV – SMO Clone

Hi All,    

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – SMO Clone.

Note: Executing a clone from a different node - Refrigerator

 

Moving resources... (REPO will keep located in Oven and PROD will be moved to Refrigerator)

 

 

Executing a clone from Refrigerator machine... (where is locate the PROD database)

 

 

 

 

 

Note: Needed to change the clone destination to a local disk (ie C:\ or D:\)

 

 

Saving XML for future Clones...

 

 

 

 

 

 

 

 

 

In my next post I will explain about Oracle FailSafe – SMO Restore

All the best

neto

SMO – I love this product!

Oracle FailSafe – Part XIV – SMO Backup

Hi All,    

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – SMO Backup.

 

 

 

 

 

 

In my next post I will explain about Oracle FailSafe – SMO Clone

All the best

neto

SMO – I love this product!

Oracle FailSafe – Part XIII – Configuring SMO Profile

Hi All,    

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – Configuring SMO Profile

 

 

Please use netapp1 as the password

 

 

Please use the virtual name for the Host (changing physical location to "virtual") :-)

 

 

 

Please use netapp1 as the password

 

 

Please use oracle as the password

 

 

 

 

 

 

In my next post I will explain about Oracle FailSafe – SMO Backup

All the best

neto

SMO – I love this product!

Oracle FailSafe – Part XII – Configuring SMO Repo

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – Configuring SMO Repo.

Using virtual name (virtual-repo), hence there is no need to point to a specific node.

 

 

 

 

 

 

 

 

 

 

In my next post I will explain about Oracle FailSafe – Configuring SMO Profile

All the best

neto

SMO – I love this product!

Oracle FailSafe – Part XI – Testing Oracle FailSafe

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – Testing Oracle FailSafe.

 

 

 

Connecting from oven...

 

 

Moving PROD Group to Refrigerator...

 

 

 

Connecting from refrigerator...

 

In my next post I will explain about Oracle FailSafe – Configuring SMO Repository

All the best

neto

NetApp – I love this company!

Oracle FailSafe – Part X – Configuring Oracle FailSafe

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – Configuring Oracle FailSafe.

 

 

 

Note: First, we need to make sure about some steps:

 

spfile on a shared disk

 

 

log_archive_dest_1='LOCATION=S:\repo\arch\'

log_archive_format=ARC%S_%R.%T

db_block_size=8192

db_file_multiblock_read_count=16

open_cursors=300

db_domain=""

db_name=repo

background_dump_dest=D:\oracle\product\10.2.0\admin\repo\bdump

core_dump_dest=D:\oracle\product\10.2.0\admin\repo\cdump

user_dump_dest=D:\oracle\product\10.2.0\admin\repo\udump

control_files=("S:\repo\control\control01.ctl", "S:\repo\control\control02.ctl", "S:\repo\control\control03.ctl")

job_queue_processes=10

compatible=10.2.0.3.0

processes=150

sga_target=385875968

audit_file_dest=D:\oracle\product\10.2.0\admin\repo\adump

remote_login_passwordfile=EXCLUSIVE

dispatchers="(PROTOCOL=TCP) (SERVICE=repoXDB)"

pga_aggregate_target=127926272

undo_management=AUTO

undo_tablespace=UNDOTBS1

 

Changing to attend Oracle FailSafe requirements

 

log_archive_dest_1='LOCATION=S:\repo\arch\'

log_archive_format=ARC%S_%R.%T

db_block_size=8192

db_file_multiblock_read_count=16

open_cursors=300

db_domain=""

db_name=repo

background_dump_dest=R:\repo\bdump

core_dump_dest=R:\repo\cdump

user_dump_dest=R:\repo\udump

control_files=("S:\repo\control\control01.ctl", "S:\repo\control\control02.ctl", "S:\repo\control\control03.ctl")

job_queue_processes=10

compatible=10.2.0.3.0

processes=150

sga_target=385875968

audit_file_dest=R:\repo\adump

remote_login_passwordfile=EXCLUSIVE

dispatchers="(PROTOCOL=TCP) (SERVICE=repoXDB)"

pga_aggregate_target=127926272

undo_management=AUTO

undo_tablespace=UNDOTBS1

 

 

 

 

adump, bdump, cdump and udump on a shared disk

 

 

 

 

 

 

Configuring Virtual IP for Oracle FailSafe

 

 

 

Note: Please execute the same procedure on both nodes

 

 

Executing Oracle FailSafe

 

 

 

 

 

 

 

 

 

 

Note: Copy initrepo.ora (default location) to shared disk

 

 

 

Please use smorepo as the password

 

 

 

 

 

 

Please execute the same procedure for all databases that needed to be included in MSCS environment.

 

Final configuration:

 

 

 

In my next post I will explain about Oracle FailSafe – Testing Oracle FailSafe.

All the best

neto

NetApp – I love this company!

Oracle FailSafe – Part IX – Installing Oracle FailSafe

Hi All,

This is neto from Brazil

How are you?

On this post, I would like to introduce and explain a little bit about Oracle Fail Safe – Installing Oracle FailSafe.

 

 

 

 

 

 

 

 

 

 

 

Using oracle as the password

 

 

 

 

Note: Please use the above procedure on Refrigerator node.

 

Please reboot Oven and Refrigerator.

 

In my next post I will explain about Oracle FailSafe – Configuring Oracle FailSafe.

All the best

neto

NetApp – I love this company!