achampav
achampav
/ physical_to_logical.sql
Created
March 11, 2020 13:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alter database recover to logical standby testdg; | |
| shutdown | |
| startup mount | |
| alter system set log_archive_dest_1 = 'location=use_db_recovery_file_dest db_unique_name=testdg_dg02' scope = both; |
achampav
/ logical_db_build.sql
Created
March 11, 2020 13:16
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| exec dbms_logstdby.build |
achampav
/ recovery_cancel.sql
Created
March 11, 2020 13:15
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alter database recover managed standby database cancel; |
achampav
/ pk_fictives.sql
Created
March 11, 2020 13:14
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| alter table user1.table1 add primary key(colonne1) rely disable; |
achampav
/ tables_candidates_pk.sql
Created
March 11, 2020 13:13
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select owner,table_name from dba_logstdby_not_unique | |
| where (owner,table_name) not in | |
| (select distinct owner,table_name from dba_logstdby_unsupported) | |
| and bad_column = 'Y' |
achampav
/ ajout_physical_stdby_dg.sql
Created
March 11, 2020 13:12
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DGMGRL> add database testdg_dg02 as connect identifier is testdg_dg02 maintained as physical; | |
| Database "testdg_dg02" added | |
| DGMGRL> enable database testdg_dg02 | |
| Enabled. | |
| DGMGRL> show configuration | |
| Configuration - testdg | |
| Protection Mode: MaxPerformance | |
| Databases: |
achampav
/ create_stdby_rman.sql
Created
March 11, 2020 13:10
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@dataguard02 trace]$ rman target sys/xxxxxxx@testdg_dg01_dg auxiliary sys/xxxxxxx@testdg_dg02_dg | |
| Recovery Manager: Release 11.2.0.3.0 - Production on Wed Dec 7 11:24:57 2016 | |
| Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. | |
| connected to target database: TESTDG (DBID=2861418430) | |
| connected to auxiliary database: TESTDG (not mounted) | |
| RMAN> duplicate target database for standby from active database dorecover nofilenamecheck; |
achampav
/ startup_nomount_stdby.sql
Created
March 11, 2020 13:08
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [oracle@dataguard02 trace]$ sqlplus /nolog | |
| SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 7 11:23:26 2016 | |
| Copyright (c) 1982, 2011, Oracle. All rights reserved. | |
| SQL> connect / as sysdba | |
| Connected to an idle instance. | |
| SQL> startup nomount | |
| ORACLE instance started. |
achampav
/ create_spfile_for_stdby.sql
Created
March 11, 2020 13:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create spfile from pfile = '/tmp/initTESTDG.ora.forstdby'; |
achampav
/ init_pour_stdby.ora
Created
March 11, 2020 13:06
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| TESTDG.__db_cache_size=771751936 | |
| TESTDG.__java_pool_size=16777216 | |
| TESTDG.__large_pool_size=16777216 | |
| TESTDG.__oracle_base='/oracle'#ORACLE_BASE set from environment | |
| TESTDG.__pga_aggregate_target=369098752 | |
| TESTDG.__sga_target=1107296256 | |
| TESTDG.__shared_io_pool_size=0 | |
| TESTDG.__shared_pool_size=285212672 | |
| TESTDG.__streams_pool_size=0 | |
| *.archive_lag_target=0 |