oracle createfile error 32 when trying set file time

#Oracle createfile error 32 when trying set file time software

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 if the primary database has 5 REDOLOG groups for each thread, then I should create 6 Standby REDOLOG groups for each thread. Standby REDOLOG groups should be same number as regular REDOLOG groups +1 for each thread. SQL> ALTER SYSTEM SET standby_file_management=auto

SQL> ALTER SYSTEM SET fal_client=’ orcl‘ SQL> ALTER SYSTEM SET fal_server=’ orcldr‘

SQL> ALTER SYSTEM SET remote_login_passwordfile=exclusive SCOPE=SPFILE SQL> ALTER SYSTEM SET log_archive_dest_state_2=enable Here you should use service names which you already configured earlier in tnsnames.ora: SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE= orcldr NOAFFIRM LGWR ASYNC delay=0 VALID_FOR=(all_logfiles,PRIMARY_ROLE) max_failure=0 reopen=300 net_timeout=90 DB_UNIQUE_NAME= orcldr‘ SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG=’DG_CONFIG=( orcl, orcldr)’ Here you should use the DB_UNIQUE_NAME of each of primary and standby: Make sure below 2 parameters are well configured to reflict the database name: Step 5: Make sure the Primary DB is in ARCHIVELOG & FORCE LOGGING modes: * Do a TNSPING from both Primary and Standby nodes and make sure it’s working. (SID_DESC = (GLOBAL_DBNAME = orcldr) (ORACLE_HOME = /u01/oracle/19c) (SID_NAME = orcldr1)) Statically register the local instance SID: (SID_DESC = (GLOBAL_DBNAME = orcl2) (ORACLE_HOME = /u01/oracle/19c) (SID_NAME = orcl2)) (SID_DESC = (GLOBAL_DBNAME = orcl1) (ORACLE_HOME = /u01/oracle/19c) (SID_NAME = orcl1)) # vi /u01/grid/19c/network/admin/listener.ora To statically register the local instance SID: Note: You can also Specify (UR=A) option next to service_name to connect to an instance in NOMOUNT mode: # vi /u01/oracle/19c/network/admin/tnsnames.ora This is to add two tnsentries, one for Primary DB “ORCL” and another for the Standby DB “ORCLDR”.

#Oracle createfile error 32 when trying set file time software

Ģ- TEMPFILES will be created automatically whenStandby DB get opened in OPEN mode.īefore we start please pay attention to the following details of both Primary and Standby environments EnvironmentĪs a matter of fact, Grid Infrastructure 19c should be already installed on both standby nodes, database software installation should be installed as well, you don’t have to create a database. Creation of a standby database in 19c is pretty simliar to 11g except of two points:ġ- Using the compressed feature in the Duplicate command “USING COMPRESSED BACKUPSET” can speed up the whole process by 200%.