Configuring the default backup destination and archivelog mode

The DB_RECOVERY_FILE_DEST parameter specifies the default location for the fast recovery area.

Here are the steps to enable archivelog mode  and backup to the default location.

SQL> conn sys/orcl@to_primary as sysdba
Connected.
SQL> show parameter db_recovery_file_dest;
 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest              string      D:\app\Admin\virtual\fast_reco
                                                 very_area\orcl
db_recovery_file_dest_size          big integer 9546M
  
--- Shutdown the database and make it at mount state to enable archivelog mode
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;  -- oracle reads the control files
ORACLE instance started.
 Total System Global Area 2499805184 bytes
Fixed Size                  8749920 bytes
Variable Size             687869088 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8024064 bytes
Database mounted.

 ----Enable Archivelog mode---
SQL> alter database archivelog;
 Database altered.
SQL> alter database open;
 Database altered.

  ------Check the archive mode status --
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     6
Next log sequence to archive   8
Current log sequence           8

  --- Connect to RMAN client to backup the database to the default destination
 SQL> $ rman target "'/ as sysbackup '"
 Recovery Manager: Release 12.2.0.1.0 - Production on Mon Feb 7 22:33:47 2022
 Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
 connected to target database: ORCL (DBID=1623755738)

  ----Backup the database using 'backup database' command
RMAN> backup database;
 Starting backup at 07-FEB-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=145 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00005 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00003 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00007 name=D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 07-FEB-22
channel ORA_DISK_1: finished piece 1 at 07-FEB-22
piece handle=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\BACKUPSET\2022_02_07\O1_MF_NNNDF_TAG20220207T223402_K02X1CT0_.BKP tag=TAG20220207T223402 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 07-FEB-22
 Starting Control File and SPFILE Autobackup at 07-FEB-22
piece handle=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\AUTOBACKUP\2022_02_07\O1_MF_S_1096065309_K02X3G72_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 07-FEB-22
 RMAN>

PC Gaming Headset Headphone Hook Holder Hanger Mount, Headphones Stand with Adjustable & Rotating Arm Clamp, Under Desk Design, Universal Fit, Built in Cable Clip Organizer EURPMASK

(27325)

$12.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

🎧【Clamp-on Headphone Stand】The E-Hold Series headphone holder fits desks from 0.31 inch to 1.57 inch thick, making it a versatile choice for most setups. The spring clamp is a breeze to remove and reattach. No glue, no mess. It blends seamlessly into... read more

LLEVTIC Computer Speakers, Desktop Speakers with 6 Colorful RGB Lights, Volume Control PC Speakers, USB Powered Gaming Speakers with 3.5mm Aux Cable for PC Monitor Laptop Tablet Phone

(1250)

44% Off $26.88 $14.99 (as of 30/06/2024 15:56 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Full-Range Stereo Sound Quality】Equipped with advanced sound drivers and a full-range 2.0 channel reinforced stereo core, this computer speakers provides the perfect atmosphere for your entertainment activities such as watching movies, gaming, and l... read more

Laptop Cleaning Kit Keyboard Cleaner, Keyboard Cleaning Kit Electronics Cleaning Tool for MacBook iPad Phone iPhone Pro, Brush Tool for Tablet, Computer, PC, TV Camera Lens Computer Vacuum Keyboard

(2045)

$16.98 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

DEEP CLEAN YOUR DEVICE The electronics cleaner kit can effectively deep clean all your electronic devices such as mobile phones, tablets, TVs, etc. It comes with retractable large keyboard brush, polishing cleaning cloth X 2, keycap puller, metal pen... read more

UtechSmart Venus Pro RGB Wireless MMO Gaming Mouse, 16,000 DPI Optical Sensor, 2.4 GHz Transmission Technology, Ergonomic Design, 16M Chroma RGB Lighting, 16 programmable Buttons, Up to 70 Hours

20% Off $59.99 $47.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Extensive Fully Programmable Buttons】16 customizable buttons can improve your gaming skills and performance by complex custom button macro coding of reconfiguration and assignment. The button custom function combines multiple keys into one button th... read more