Differences

This shows you the differences between two versions of the page.

--- tools:oracle [2024/02/26 06:08]
darron [Oracle DB Archive log]
+++ tools:oracle [2024/02/28 04:29] (current)
darron [Miscellaneous]
@@ Line 441: / Line 441: @@
 To enable backups with RMAN turn on archivelog mode.
-==Login==
-<code>
-[oracle@vm3 ~]$ sqlplus sys as sysdba
-SQL*Plus: Release 23.0.0.0.0 - Production on Fri Feb 23 14:57:06 2024
-Version 23.3.0.23.09
-Copyright (c) 1982, 2023, Oracle.  All rights reserved.
-Enter password:
-Connected to:
-Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
-Version 23.3.0.23.09
-</code>
 ==Enable==
@@ Line 497: / Line 482: @@
 Next log sequence to archive   68
 Current log sequence           67
+</code>
+==List==
+<code>
+RMAN> list archivelog all;
+list archivelog all;
+List of Archived Log Copies for database with db_unique_name FREE
+=====================================================================
+Key     Thrd Seq     S Low Time
+------- ---- ------- - ---------
+       1    61      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_61_1160003622.dbf
+       1    62      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_62_1160003622.dbf
+       1    63      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_63_1160003622.dbf
+       1    64      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_64_1160003622.dbf
+       1    65      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_65_1160003622.dbf
+       1    66      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_66_1160003622.dbf
+       1    67      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_67_1160003622.dbf
+       1    68      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_68_1160003622.dbf
+RMAN>
+</code>
+==Disable==
+<code>
+SQL> shutdown immediate;
+Database closed.
+Database dismounted.
+ORACLE instance shut down.
+SQL> startup mount
+ORACLE instance started.
+Total System Global Area 1603679416 bytes
+Fixed Size                  5313720 bytes
+Variable Size             973078528 bytes
+Database Buffers          620756992 bytes
+Redo Buffers                4530176 bytes
+Database mounted.
+SQL> alter database noarchivelog;
+Database altered.
+SQL> alter database open;
+Database altered.
+SQL> archive log list;
+Database log mode              No Archive Mode
+Automatic archival             Disabled
+Archive destination            /opt/oracle/product/23c/dbhomeFree/dbs/arch
+Oldest online log sequence     69
+Current log sequence           68
+</code>
+==Delete==
+<code>
+RMAN> delete archivelog all;
+delete archivelog all;
+released channel: ORA_DISK_1
+allocated channel: ORA_DISK_1
+channel ORA_DISK_1: SID=50 device type=DISK
+List of Archived Log Copies for database with db_unique_name FREE
+=====================================================================
+Key     Thrd Seq     S Low Time
+------- ---- ------- - ---------
+       1    61      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_61_1160003622.dbf
+       1    62      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_62_1160003622.dbf
+       1    63      A 23-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_63_1160003622.dbf
+       1    64      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_64_1160003622.dbf
+       1    65      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_65_1160003622.dbf
+       1    66      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_66_1160003622.dbf
+       1    67      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_67_1160003622.dbf
+       1    68      A 25-FEB-24
+        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_68_1160003622.dbf
+Do you really want to delete the above objects (enter YES or NO)? yes
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_61_1160003622.dbf RECID=1 STAMP=1161701923
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_62_1160003622.dbf RECID=2 STAMP=1161727348
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_63_1160003622.dbf RECID=3 STAMP=1161841884
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_64_1160003622.dbf RECID=4 STAMP=1161846158
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_65_1160003622.dbf RECID=5 STAMP=1161871223
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_66_1160003622.dbf RECID=6 STAMP=1161885796
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_67_1160003622.dbf RECID=7 STAMP=1161900306
+deleted archived log
+archived log file name=/opt/oracle/product/23c/dbhomeFree/dbs/arch1_68_1160003622.dbf RECID=8 STAMP=1161929059
+Deleted 8 objects
+RMAN>
 </code>
 ===Oracle PDB===
@@ Line 562: / Line 680: @@
 ==User==
-Create a user which can connect to the server and operated on the PDB tablespace.
+Create a user which can connect to the server and operate on the PDB tablespace.
 <code>
@@ Line 583: / Line 701: @@
 ===Miscellaneous===
-==Tablespaces==
+==Path==
-Not specifying a file path will create a tablespace file in this directory for 23c.
+Not specifying a file path will create a tablespace file and archive logs in this directory for 23c.
 <code>
@@ Line 591: / Line 709: @@
 </code>
-To remove the tablespace file various options are required when dropping a tablespace.
+==Tablespace==
+__Drop__
+To remove a tablespace file various options are required when dropping it.
 <code>

Differences

start

tools

advertisement

Toolbox