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:38] – [Oracle DB Archive log] darron | tools:oracle [2024/07/28 19:32] (current) – [PHP] darron | ||
---|---|---|---|
Line 482: | Line 482: | ||
Next log sequence to archive | Next log sequence to archive | ||
Current log sequence | Current log sequence | ||
+ | </ | ||
+ | |||
+ | ==List== | ||
+ | |||
+ | < | ||
+ | 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 | ||
+ | Name: / | ||
+ | |||
+ | 2 | ||
+ | Name: / | ||
+ | |||
+ | 3 | ||
+ | Name: / | ||
+ | |||
+ | 4 | ||
+ | Name: / | ||
+ | |||
+ | 5 | ||
+ | Name: / | ||
+ | |||
+ | 6 | ||
+ | Name: / | ||
+ | |||
+ | 7 | ||
+ | Name: / | ||
+ | |||
+ | 8 | ||
+ | Name: / | ||
+ | |||
+ | |||
+ | |||
+ | RMAN> | ||
+ | </ | ||
+ | |||
+ | ==Disable== | ||
+ | |||
+ | < | ||
+ | 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 | ||
+ | Database Buffers | ||
+ | Redo Buffers | ||
+ | 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 | ||
+ | Archive destination | ||
+ | Oldest online 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 547: | 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 568: | 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 576: | Line 709: | ||
</ | </ | ||
- | To remove | + | ==Tablespace== |
+ | |||
+ | __Drop__ | ||
+ | |||
+ | To remove | ||
< | < | ||
Line 617: | 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 705: | Line 851: | ||
</ | </ | ||
- | ==Config== | ||
- | Add extension=oci8.so to "/ | ||
- | |||
- | Add instant client to library path | ||
- | |||
- | < | ||
- | echo "/ | ||
- | ldconfig | ||
- | </ | ||
===Resources=== | ===Resources=== | ||