You are here: start » tools » oracle

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
tools:oracle [2024/02/26 06:43]
darron [Oracle DB Archive log] 		tools:oracle [2024/02/28 04:29] (current)
darron [Miscellaneous]
Line 553: Line 553:
 Oldest online log sequence     69 Oldest online log sequence     69
 Current log sequence           68 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       1    61      A 23-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_61_1160003622.dbf
 +
 +2       1    62      A 23-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_62_1160003622.dbf
 +
 +3       1    63      A 23-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_63_1160003622.dbf
 +
 +4       1    64      A 25-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_64_1160003622.dbf
 +
 +5       1    65      A 25-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_65_1160003622.dbf
 +
 +6       1    66      A 25-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_66_1160003622.dbf
 +
 +7       1    67      A 25-FEB-24
 +        Name: /opt/oracle/product/23c/dbhomeFree/dbs/arch1_67_1160003622.dbf
 +
 +8       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> </code>
 ===Oracle PDB=== ===Oracle PDB===
Line 618: Line 680:
 ==User== ==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> <code>
Line 639: Line 701:
 ===Miscellaneous=== ===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> <code>
Line 647: Line 709:
 </code> </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> <code>