Configuring the default backup destination and archivelog mode
Question is closed for new answers.
meda Changed status to publish 08/03/2022
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>
meda Selected answer as best 18/02/2022