SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 244249
Current log sequence
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string miscdb
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.0100E+10 bytes
Fixed Size 3721224 bytes
Variable Size 1778386936 bytes
Database Buffers 8287944704 bytes
Redo Buffers 29831168 bytes
Database mounted.
SQL>
Space Assign for Fast Recovery Area:
SQL> alter system set db_recovery_file_dest_size = 200G;
System altered.
Choose the destination:
SQL> alter system set db_recovery_file_dest='/u02/app/oracle/FRA/miscdb';
System altered.
SQL> ALTER DATABASE ARCHIVELOG;
Database altered.
SQL>
SQL> alter database open;
Database altered.
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u02/app/oracle/FRA/miscdb
db_recovery_file_dest_size big integer 200G
recovery_parallelism integer 0
SQL>
