DBA 大小事處理記錄

今天要在 docker 上刪除資料庫，但是使用 dbca 這個需要 gui 畫面，所以想到改用 rman 來操作，以下為官方指令

RMAN> CONNECT TARGET /
RMAN> STARTUP FORCE MOUNT
RMAN> ALTER SYSTEM ENABLE RESTRICTED SESSION;
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;

database name is "ORCLCDB" and DBID is 2738330970

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 device type=DISK
specification does not match any backup in the repository

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository

database name is "ORCLCDB" and DBID is 2738330970
database dropped