WordPress.com



Trace file C:\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_29100.trcOracle Database 18c Express Edition Release 18.0.0.0.0 - ProductionVersion 18.4.0.0.0Build label: RDBMS_18.4.0.0.0DBRU_WINDOWS.X64_190202.XEWindows NT Version V6.2 ORACLE_HOME = C:\Oracle\dbhomeXENode name : MACHINE1CPU : 8 - type 8664, 4 Physical CoresProcess Affinity : 0x0x0000000000000000Memory (Avail/Total): Ph:8465M/16243M, Ph+PgF:8136M/18675M Instance name: xeRedo thread mounted by this instance: 0 <none>Oracle process number: 27Windows thread id: 29100, image: ORACLE.EXE (SHAD)*** 2020-03-26T11:32:56.573376+05:30 (CDB$ROOT(1))*** SESSION ID:(296.12590) 2020-03-26T11:32:56.573376+05:30*** CLIENT ID:() 2020-03-26T11:32:56.573376+05:30*** SERVICE NAME:() 2020-03-26T11:32:56.573376+05:30*** MODULE NAME:(sqlplus.exe) 2020-03-26T11:32:56.573376+05:30*** ACTION NAME:() 2020-03-26T11:32:56.573376+05:30*** CLIENT DRIVER:(SQL*PLUS) 2020-03-26T11:32:56.573376+05:30*** CONTAINER ID:(1) 2020-03-26T11:32:56.573376+05:30 2020-03-26 11:32:56.562 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:32:56.574 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2*** 2020-03-26T11:33:00.637197+05:30 (CDB$ROOT(1))*** 2020-03-26 11:33:00.637197 [krsh.c:6083]Redo network throttle feature is disabled at mount time2020-03-26 11:33:00.696 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:00.696 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:00.697 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:00.697 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:00.697 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:00.697 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2krsd_cb_role_change: role 1krsd_dest32_eval: Using STANDBY_ARCHIVE_DEST parameter default value as C:\oracle\archive [krsd.c:17717]*** 2020-03-26T11:33:07.447168+05:30 (CDB$ROOT(1))2020-03-26 11:33:07.447 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:07.447 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2*** 2020-03-26T11:33:07.874530+05:30 (CDB$ROOT(1))2020-03-26 11:33:07.874 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:07.875 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2Thread 1 checkpoint: logseq 508, block 2, scn 0x000000000075e422kctdrsrt: on-disk rba 508.66.0 cache-low rba: logseq 508, block 3 on-disk rba: logseq 508, block 66, scn 0x000000000075e469Synchronized sync destination connectivity mask for thread 1 is 0x0Using largest hash table of 262144 entries (2Mb), htbl_size = 2097232, max_alloc = 2147467264*** 2020-03-26T11:33:07.936401+05:30 (CDB$ROOT(1))Started writing zeroblks thread 1 seq 508 blocks 66-73*** 2020-03-26T11:33:07.941353+05:30 (CDB$ROOT(1))Completed writing zeroblks thread 1 seq 508==== Redo read statistics for thread 1 ====Total physical reads (from disk and memory): 4096Kb-- Redo read_disk statistics --Read rate (ASYNC): 31Kb in 0.07s => 0.44 Mb/secLongest record: 0Kb, moves: 0/101 (0%)Longest LWN: 3Kb, moves: 0/27 (0%), moved: 0MbLast redo scn: 0x000000000075e468 (7726184)--------------------------------------------------- Recovery Hash Table Statistics ---------Hash table buckets = 262144Longest hash chain = 1Average hash chain = 24/24 = 1.0Max compares per lookup = 1Avg compares per lookup = 147/171 = 0.9----------------------------------------------*** 2020-03-26T11:33:07.967281+05:30 (CDB$ROOT(1))KCRA: start recovery claims for 24 data blocks*** 2020-03-26T11:33:07.968278+05:30 (CDB$ROOT(1))KCRA: blocks processed = 24/24, claimed = 24, eliminated = 0*** 2020-03-26T11:33:08.006177+05:30 (CDB$ROOT(1))Recovery of Online Redo Log: Thread 1 Group 3 Seq 508 Reading mem 0*** 2020-03-26T11:33:08.020143+05:30 (CDB$ROOT(1))Completed redo application of 0.02MB*** 2020-03-26T11:33:08.031111+05:30 (CDB$ROOT(1))Completed recovery checkpoint2020-03-26 11:33:08.032 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:08.032 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2----- Recovery Hash Table Statistics ---------Hash table buckets = 262144Longest hash chain = 1Average hash chain = 24/24 = 1.0Max compares per lookup = 1Avg compares per lookup = 171/171 = 1.0----------------------------------------------Recovery sets nab of thread 1 seq 508 to 66 with 8 zeroblks*** 2020-03-26T11:33:09.367659+05:30 (CDB$ROOT(1))2020-03-26 11:33:09.367 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:09.367 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2*** 2020-03-26T11:33:10.104372+05:30 (CDB$ROOT(1))Count of ofsmtab$: 0 entrieskzedcencred: Setting of SGA variable to enforce dictionary credential encryption failed as encryption key was not found*** 2020-03-26T11:33:13.482558+05:30 (CDB$ROOT(1))2020-03-26 11:33:13.482 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:13.482 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:13.482 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:13.483 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:13.568 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:13.569 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:13.569 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:13.569 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 22020-03-26 11:33:13.569 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\olr cannot be opened. error 22020-03-26 11:33:13.569 : [ default][ default]ut_read_reg:2:ocr registry key SOFTWARE\Oracle\ocr cannot be opened. error 2*** 2020-03-26T11:33:14.371728+05:30 (PDB$SEED(2))17655855F0474AD7AE0D923E87E6C87D*** 2020-03-26T11:33:15.515155+05:30 (XEPDB1(3))17655855F0474AD7AE0D923E87E6C87D*** 2020-03-26T12:30:03.361518+05:30 (CDB$ROOT(1))-- The following are current System-scope REDO Log Archival related-- parameters and can be included in the database initialization file.---- LOG_ARCHIVE_DEST=''-- LOG_ARCHIVE_DUPLEX_DEST=''---- LOG_ARCHIVE_FORMAT=ARC%S_%R.%T---- DB_UNIQUE_NAME="XE"---- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'-- LOG_ARCHIVE_MAX_PROCESSES=4-- ARCHIVE_LAG_TARGET=900-- STANDBY_FILE_MANAGEMENT=MANUAL-- FAL_CLIENT=''-- FAL_SERVER=''---- LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\archive'-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOVERIFY SYNC'-- LOG_ARCHIVE_DEST_1='REGISTER'-- LOG_ARCHIVE_DEST_1='NOALTERNATE'-- LOG_ARCHIVE_DEST_1='NODEPENDENCY'-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'-- LOG_ARCHIVE_DEST_STATE_1=ENABLE---- Below are two sets of SQL statements, each of which creates a new-- control file and uses it to open the database. The first set opens-- the database with the NORESETLOGS option and should be used only if-- the current versions of all online logs are available. The second-- set opens the database with the RESETLOGS option and should be used-- if online logs are unavailable.-- The appropriate set of statements can be copied from the trace into-- a script file, edited as necessary, and executed when there is a-- need to re-create the control file.---- Set #1. NORESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- Additional logs may be required for media recovery of offline-- Use this only if the current versions of all online logs are-- available.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE-- All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;-- Database can now be opened normally.ALTER DATABASE OPEN;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.---- Set #2. RESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- The contents of online logs will be lost and all backups will-- be invalidated. Use this only if online logs are damaged.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE USING BACKUP CONTROLFILE-- Database can now be opened zeroing the online logs.ALTER DATABASE OPEN RESETLOGS;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.--*** 2020-03-26T13:52:55.358025+05:30 (CDB$ROOT(1))-- The following are current System-scope REDO Log Archival related-- parameters and can be included in the database initialization file.---- LOG_ARCHIVE_DEST=''-- LOG_ARCHIVE_DUPLEX_DEST=''---- LOG_ARCHIVE_FORMAT=ARC%S_%R.%T---- DB_UNIQUE_NAME="XE"---- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'-- LOG_ARCHIVE_MAX_PROCESSES=4-- ARCHIVE_LAG_TARGET=900-- STANDBY_FILE_MANAGEMENT=MANUAL-- FAL_CLIENT=''-- FAL_SERVER=''---- LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\archive'-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOVERIFY SYNC'-- LOG_ARCHIVE_DEST_1='REGISTER'-- LOG_ARCHIVE_DEST_1='NOALTERNATE'-- LOG_ARCHIVE_DEST_1='NODEPENDENCY'-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'-- LOG_ARCHIVE_DEST_STATE_1=ENABLE---- Below are two sets of SQL statements, each of which creates a new-- control file and uses it to open the database. The first set opens-- the database with the NORESETLOGS option and should be used only if-- the current versions of all online logs are available. The second-- set opens the database with the RESETLOGS option and should be used-- if online logs are unavailable.-- The appropriate set of statements can be copied from the trace into-- a script file, edited as necessary, and executed when there is a-- need to re-create the control file.---- Set #1. NORESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- Additional logs may be required for media recovery of offline-- Use this only if the current versions of all online logs are-- available.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE-- All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;-- Database can now be opened normally.ALTER DATABASE OPEN;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.---- Set #2. RESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- The contents of online logs will be lost and all backups will-- be invalidated. Use this only if online logs are damaged.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE USING BACKUP CONTROLFILE-- Database can now be opened zeroing the online logs.ALTER DATABASE OPEN RESETLOGS;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.--*** 2020-03-26T13:54:16.699873+05:30 (CDB$ROOT(1))-- The following are current System-scope REDO Log Archival related-- parameters and can be included in the database initialization file.---- LOG_ARCHIVE_DEST=''-- LOG_ARCHIVE_DUPLEX_DEST=''---- LOG_ARCHIVE_FORMAT=ARC%S_%R.%T---- DB_UNIQUE_NAME="XE"---- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'-- LOG_ARCHIVE_MAX_PROCESSES=4-- ARCHIVE_LAG_TARGET=900-- STANDBY_FILE_MANAGEMENT=MANUAL-- FAL_CLIENT=''-- FAL_SERVER=''---- LOG_ARCHIVE_DEST_1='LOCATION=C:\oracle\archive'-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOVERIFY SYNC'-- LOG_ARCHIVE_DEST_1='REGISTER'-- LOG_ARCHIVE_DEST_1='NOALTERNATE'-- LOG_ARCHIVE_DEST_1='NODEPENDENCY'-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'-- LOG_ARCHIVE_DEST_STATE_1=ENABLE---- Below are two sets of SQL statements, each of which creates a new-- control file and uses it to open the database. The first set opens-- the database with the NORESETLOGS option and should be used only if-- the current versions of all online logs are available. The second-- set opens the database with the RESETLOGS option and should be used-- if online logs are unavailable.-- The appropriate set of statements can be copied from the trace into-- a script file, edited as necessary, and executed when there is a-- need to re-create the control file.---- Set #1. NORESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- Additional logs may be required for media recovery of offline-- Use this only if the current versions of all online logs are-- available.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE-- All logs need archiving and a log switch is needed.ALTER SYSTEM ARCHIVE LOG ALL;-- Database can now be opened normally.ALTER DATABASE OPEN;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.---- Set #2. RESETLOGS case---- The following commands will create a new control file and use it-- to open the database.-- Data used by Recovery Manager will be lost.-- The contents of online logs will be lost and all backups will-- be invalidated. Use this only if online logs are damaged.-- After mounting the created controlfile, the following SQL-- statement will place the database in the appropriate-- protection mode:-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCESTARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "XE" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 8 MAXLOGHISTORY 292LOGFILE GROUP 1 'C:\ORACLE\ORADATA\XE\REDO01.LOG' SIZE 200M BLOCKSIZE 512, GROUP 2 'C:\ORACLE\ORADATA\XE\REDO02.LOG' SIZE 200M BLOCKSIZE 512, GROUP 3 'C:\ORACLE\ORADATA\XE\REDO03.LOG' SIZE 200M BLOCKSIZE 512, GROUP 4 'C:\ORACLE\ORADATA\XE\REDO04.LOG' SIZE 200M BLOCKSIZE 512-- STANDBY LOGFILEDATAFILE 'C:\ORACLE\ORADATA\XE\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDBSEED\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\XEPDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB1\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSTEM01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\SYSAUX01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\UNDOTBS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\USERS01.DBF', 'C:\ORACLE\ORADATA\XE\PDB2\TEST_TB01.DBF'CHARACTER SET AL32UTF8;-- Commands to re-create incarnation table-- Below log names MUST be changed to existing filenames on-- disk. Any one log file from each branch can be used to-- re-create incarnation records.-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_0999319476.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1019317005.0001';-- ALTER DATABASE REGISTER LOGFILE 'C:\ORACLE\ARCHIVE\ARC0000000001_1020770292.0001';-- Recovery is required if any of the datafiles are restored backups,-- or if the last shutdown was not normal or immediate.RECOVER DATABASE USING BACKUP CONTROLFILE-- Database can now be opened zeroing the online logs.ALTER DATABASE OPEN RESETLOGS;-- Open all the PDBs.ALTER PLUGGABLE DATABASE ALL OPEN;-- Commands to add tempfiles to temporary tablespaces.-- Online tempfiles have complete space information.-- Other tempfiles may require adjustment.ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB$SEED;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDBSEED\TEMP012019-09-18_15-38-03-475-PM.DBF' SIZE 65011712 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = XEPDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\XEPDB1\TEMP01.DBF' SIZE 135266304 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;ALTER SESSION SET CONTAINER = PDB1;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB1\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = PDB2;ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\ORADATA\XE\PDB2\TEMP012019-09-18_15-38-03-475-PM.DBF' REUSE;ALTER SESSION SET CONTAINER = CDB$ROOT;-- End of tempfile additions.-- ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download