Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tools:oracle [2024/02/26 06:42] darron [Oracle DB Archive log] |
tools:oracle [2024/02/28 04:29] (current) darron [Miscellaneous] |
||
---|---|---|---|
Line 517: | Line 517: | ||
8 | 8 | ||
Name: / | Name: / | ||
+ | |||
+ | |||
+ | |||
+ | RMAN> | ||
+ | </ | ||
==Disable== | ==Disable== | ||
Line 548: | Line 553: | ||
Oldest online log sequence | Oldest online log sequence | ||
Current log sequence | Current log sequence | ||
+ | </ | ||
+ | |||
+ | ==Delete== | ||
+ | |||
+ | < | ||
+ | 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 | ||
+ | Name: / | ||
+ | |||
+ | 2 | ||
+ | Name: / | ||
+ | |||
+ | 3 | ||
+ | Name: / | ||
+ | |||
+ | 4 | ||
+ | Name: / | ||
+ | |||
+ | 5 | ||
+ | Name: / | ||
+ | |||
+ | 6 | ||
+ | Name: / | ||
+ | |||
+ | 7 | ||
+ | Name: / | ||
+ | |||
+ | 8 | ||
+ | Name: / | ||
+ | |||
+ | |||
+ | Do you really want to delete the above objects (enter YES or NO)? yes | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | deleted archived log | ||
+ | archived log file name=/ | ||
+ | Deleted 8 objects | ||
+ | |||
+ | |||
+ | |||
+ | RMAN> | ||
</ | </ | ||
===Oracle PDB=== | ===Oracle PDB=== | ||
Line 613: | Line 680: | ||
==User== | ==User== | ||
- | Create a user which can connect to the server and operated | + | Create a user which can connect to the server and operate |
< | < | ||
Line 634: | 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. |
< | < | ||
Line 642: | Line 709: | ||
</ | </ | ||
- | To remove | + | ==Tablespace== |
+ | |||
+ | __Drop__ | ||
+ | |||
+ | To remove | ||
< | < |