Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
tools:oracle [2024/02/26 06:42] – [Oracle DB Archive log] darron | tools:oracle [2024/07/28 19:32] (current) – [PHP] darron | ||
---|---|---|---|
Line 517: | Line 517: | ||
8 | 8 | ||
Name: / | Name: / | ||
+ | |||
+ | |||
RMAN> | RMAN> | ||
Line 551: | 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 616: | 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 637: | 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 645: | Line 709: | ||
</ | </ | ||
- | To remove | + | ==Tablespace== |
+ | |||
+ | __Drop__ | ||
+ | |||
+ | To remove | ||
< | < | ||
Line 686: | Line 754: | ||
You should add " | You should add " | ||
</ | </ | ||
+ | ==Config== | ||
+ | Add extension=oci8.so to "/ | ||
+ | |||
+ | Add instant client to library path | ||
+ | |||
+ | < | ||
+ | echo "/ | ||
+ | ldconfig | ||
+ | </ | ||
==TEST== | ==TEST== | ||
Line 774: | Line 851: | ||
</ | </ | ||
- | ==Config== | ||
- | Add extension=oci8.so to "/ | ||
- | |||
- | Add instant client to library path | ||
- | |||
- | < | ||
- | echo "/ | ||
- | ldconfig | ||
- | </ | ||
===Resources=== | ===Resources=== | ||