V podstatě šlo všechno bez problému do chvíle, kdy jsem chtěl nastavit parameter LOG_ARCHIVE_DEST_1.
Dotazem do pohledu v$option zjistíte jaké feature máte povolené.select * from v$option;
Jelikož není možné kopírovat archívní logy online, musí se použít nástroj třetích stran, který zajistí přenos a následnou aplikaci archívních logu na standby databázi.
Já jsem našel produkt Dbvisit a pokusil se ho nainstalovat. je to jedno z řešení, které vám může pomoci v případech, že oželíte schopnosti a vlastnosti Oracle DataGuardu.Oracle DataGuard je totiž jen ve verzi Enterprise a ta stojí o pár dolarů více než standard edice.

1) První věcí co je potřeba mít nainstalované je vlastní databáze

Já jsem nainstaloval defaultní databázi ORCL na systému Windows Server 2008Postup je dobře popsán v dokumentaci a není na něm nic složitého. Spustíte nástroj DBCA a dáte vytvořit databázi

1.1) Samozřejmně musíte nainstaovat sw Oracle jak na primární tak sekundárním serveru

2) Musíte nainstalovat produkt Dbvisit

Daný program má velmi dobře zpracovanou dokumentaci. Klidně můžete jít podle ní krok po krokuJedine co musíte před instalaci mít zajištěné je konktivita mezi primárním a záložním serverem

3) Pomoc nástroje Dbvisit můžete vytvořít i Standby databázi

Přikládám postup, podle kterého jsem si vytvořil Standby databázi
=========================================================
http://www.dbvisit.com
=========================================================
=>dbvisit_setup.exe only needs to be run on the primary server.
http://www.dbvisit.com
Dbvisit Database setupDefault values will be shown in []
Options:1) New Dbvisit Database setup (combines options 2,3,4)1a) New Dbvisit RAC Instance setup (combines options 2,3,4)
2) New Dbvisit Database configuration (DDC) file setup3) New Dbvisit Archive Management Module (AMM) setup4) New Dbvisit Database repository (DDR) setup
5) Manage Dbvisit Database repository (DDR)6) Update Dbvisit Database configuration (DDC) file
7) Create Standby Database
9) Uninstall Dbvisit Database repository (DDR)E) Exit
=========================================================Please enter choice : 7=========================================================
Create Standby Database sub menu
Primary database will NOT be shutdown.Options:1) Create Standby Database (copy directly to standby server)2) Create Standby Database (using temporary location on prim_server)3) Create normal file system Standby Database from ASM primary database
r) Return to main menu
For slow networks or very large databases, the standby database may becreated manually. Please see the Dbvisit User Guide for information.
=========================================================Please enter choice : 1
——————————————————————————=>Creating Standby Database.For which primary database do you want to create a standby database?
The following Oracle database(s) have a Dbvisit Database configuration (DDC)file on this server:
SID===1) orcl2) Return to menu
Please enter choice : 1
Is this correct? [Yes]:Database orcl is up.
=>Please ensure directory C:/Program Files/Dbvisit exists on zal_server andhas the correct privileges, otherwise the next transfer step may fail.
Transferring dbv_functions.exe to host sek_server:dbv_functions.exeTransferring dbvisit.exe to host sek_server:dbvisit.exeTransferring dbvisit_setup.exe to host sek_server:dbvisit_setup.exeTransferring dbv_oraStartStop.exe to host sek_server:dbv_oraStartStop.exeTransferring dbv_orcl.env to host sek_server:dbv_orcl.envTransferring dbv_ORACLE_SID.env to host sek_server:dbv_ORACLE_SID.envTransferring README.txt to host sek_server:README.txtTransferring Dbvisit_UserGuide5.2.pdf to hostsek_server:Dbvisit_UserGuide5.2.pdfChecking Oracle installation on sek_server in C:\app\Administrator\product\11.2.0\dbhome_2\bin\oracle.exe…Total database size for orcl is 1.38GBChecking Windows service OracleServicestandby on sek_server…Service OracleServicestandby already exists on sek_server.Starting creation of standby database.
——————————————————————————-
Use ssh compression to compress the database files during transfer? [Yes]:Database files will be compressed during transfer: YesIs this correct? [Yes]:ADMIN locations on sek_server are required to exist for the standby database to startup.Checking ADMIN locations…audit_file_dest = C:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP not found on WIN-sek_server server.What would you like to do:1 – Ignore missing directory C:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP and continue anyway2 – Specify new location for audit_file_dest and continue3 – Terminate processing4 – Create missing directory on standby manually and continuePlease enter your choice [2]:
Please specify new FILESYSTEM location for audit_file_dest:[C:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP]: c:\app\Administrator\admin\standby\adumpNew location name is: c:\app\Administrator\admin\standby\adumpIs this correct? [Yes]:New location for audit_file_dest on standby is c:\app\Administrator\admin\standby\adump.
background_dump_dest = c:\app\administrator\diag\rdbms\standby\standby\trace found on sek_server server.core_dump_dest = c:\app\administrator\diag\rdbms\standby\standby\cdump found onsek_server server.user_dump_dest = c:\app\administrator\diag\rdbms\standby\standby\trace found onsek_server server.
ADMIN locations for the standby database on sek_server:
——————————————————————————-audit_file_dest c:\app\Administrator\admin\standby\adump
background_dump_dest c:\app\administrator\diag\rdbms\standby\standby\tracecore_dump_dest c:\app\administrator\diag\rdbms\standby\standby\cdumpuser_dump_dest c:\app\administrator\diag\rdbms\standby\standby\trace
——————————————————————————-
Continue with creating standby database? [Yes]:
Checking if CONTROLFILE locations exist on the standby server sek_server…
CONTROLFILE locations on sek_server are required to exist for the standby database to be created.=>Checking locations:C:\APP\ADMINISTRATOR\ORADATA\ORCLC:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL=>Checked OK.
CONTROLFILE remote locations on sek_server passed the check.
Checking if DATAFILE locations exist on the standby server sek_server…DATAFILE locations on sek_server are required to exist for the standby database to be created.=>Checking locations:C:\APP\ADMINISTRATOR\ORADATA\ORCL=>Checked OK.
DATAFILE remote locations on sek_server passed the check.
Checking if REDO locations exist on the standby server sek_server…REDO locations on sek_server are required to exist for the standby databaseto be switched to primary or to be activated.=>Checking locations:C:\APP\ADMINISTRATOR\ORADATA\ORCLC:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ONLINELOG=>Checked OK.
REDO remote locations on sek_server passed the check.
Checking if TEMPFILE locations exist on the standby server sek_server…TEMPFILE locations on sek_server are required to exist for the standby database to be switched to primary or to be activated.=>Checking locations:C:\APP\ADMINISTRATOR\ORADATA\ORCL=>Checked OK.
TEMPFILE remote locations on sek_server passed the check.
Creating standby database…Shutting down standby database standby on sek_server if required…Windows Service OracleServicestandby stopped.Standby database standby on sek_server shutdown.
Checking for standby database pfile/spfile…Spfile C:\app\Administrator\product\11.2.0\dbhome_2\database\spfilestandby.ora already exists on remote server.What would you like to do:1 – Replace standby database (s)pfile with Dbvisit created (s)pfile fromprimary database (strongly recommended)2 – Leave existing standby database (s)pfile and proceed with creationof standby database(ensure (s)pfile is located correctly on the standby server).Please enter your choice [1]:
Creating a standby pfile/spfile…Standby spfile C:\app\Administrator\product\11.2.0\dbhome_2\database\spfilestandby.ora backed up as C:\app\Administrator\product\11.2.0\dbhome_2\database\spfilestandby.ora.201005081121Pfile C:\temp\4340.dbvisit.201005081119.pfile_from_spfile.tmp created from spfile C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_2\DATABASE\SPFILEORCL.ORA for database orcl.Spfile C:\temp\4340.dbvisit.201005081119.spfilestandby.ora created from pfile C:\temp\4340.dbvisit.201005081119.pfile_from_spfile.tmp for database orcl.Creating standby controlfile…Transferring X.dbvisit.10010921.orcl.controlfile_loc.sql to hostsek_server:X.dbvisit.10010921.orcl.controlfile_loc.sqlTransferring X.dbvisit.10010921.orcl.standbycontrolfile.ctl to hostsek_server:X.dbvisit.10010921.orcl.standbycontrolfile.ctlDeleting file C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF on sek_server…Transferring SYSTEM01.DBF to host sek_server:SYSTEM01.DBFDeleting file C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF on sek_server…Transferring SYSAUX01.DBF to host sek_server:SYSAUX01.DBFDeleting file C:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF on sek_server…Transferring UNDOTBS01.DBF to host sek_server:UNDOTBS01.DBFDeleting file C:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF on sek_server…Transferring USERS01.DBF to host sek_server:USERS01.DBFDeleting file C:\APP\ADMINISTRATOR\ORADATA\ORCL\EXAMPLE01.DBF on sek_server…Transferring EXAMPLE01.DBF to host sek_server:EXAMPLE01.DBFPerforming Oracle Checkpoint.Waiting 3 seconds for checkpoint completion…Starting standby database on sek_server…
Creation of standby database completed.=>Archive destination is set to USE_DB_RECOVERY_FILE_DEST which cannot be verified on sek_server. Please ensure this location points to an existing directory on sek_server as this may cause failover and graceful switchover to fail.=========================================================Standby Database creation on sek_server completed.
Next steps:1) Exit out of dbvisit_setup.2) Run Dbvisit on this server with command:dbvisit orcl3) Run Dbvisit on standby server with command:(cd C:/Program Files/Dbvisit)dbvisit orcl
Once Dbvisit has been tested, schedule Dbvisit on primary and standby serversusing windows „Scheduled Task“ or other scheduling tool.=========================================================Please press to continue…



Komentáře