归档满RMAN进不去,CPU98%了!(转IT邦德)
--创建PFILE
SYS@devdb> create pfile='/home/oracle/devspfile.ora' from spfile;
--将快速恢复区修改大一点启动库,原来200G,修改到400G
*.db_recovery_file_dest_size=404800m
--pfile启动数据库
SQL> startup pfile='/home/oracle/pfile.ora';
[oracle@dev1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 14 13:55:26 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS@devdb> startup pfile='/home/oracle/devspfile.ora';
ORACLE instance started.
Total System Global Area 2.5837E+10 bytes
Fixed Size 26605704 bytes
Variable Size 3288334336 bytes
Database Buffers 2.2481E+10 bytes
Redo Buffers 40501248 bytes
Database mounted.
Database opened.
SYS@devdb> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 274
Next log sequence to archive 278
Current log sequence 278