HOW WE CAN WORK ON R-MAN:-
1.We will enable the archive log:-
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 117
Current log sequence 119
2.we can enable the archive into mount mode:-
1) shutdown database
2) startup mount
3)SQL> show parameter recover;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4122M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
we can also increase the size of fast_recovert_area_dest_size:-
SQL> alter system set db_recovery_file_dest_size=5000M;
System altered.
Then we will check:-
SQL> show parameter recover
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 5000M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
SQL>
Then we will enable the archive:-
SQL> alter database archivelog; ( alter database noarchivelog; for the stop archive )
Database altered.
then we will do the database in open state:-
SQL> alter database open;
Database altered.