RMAN Backup:
Step-1 : Go to
C:\oracle\app\user\product\12.1.0\dbhome_1\BIN>
open CMD on this path.
Step-2:
Assign database name to ORCLE_SID.
C:\app\user\product\12.1.0\dbhome_1\BIN>set ORACLE_SID=orcl
Check :
C:\app\user\product\12.1.0\dbhome_1\BIN>echo %ORACLE_SID%
Step-3:
C:\app\user\product\12.1.0\dbhome_1\BIN>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jul 22 13:56:48 2022
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1613180020)
RMAN>
Step-4:
RMAN> backup database ;
Starting backup at (Date)
using target database control file instead of recovery catalog
...................................................
Finished backup at (Date)
----------------------------------------------
Common Error:
RMAN> backup database ;
Starting backup at 22-JUL-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=364 device type=DISK
RMAN-00571: ========================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: =============================================
RMAN-03002: failure of backup command at 07/22/2022 13:40:26
RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Solution:
Archivelog On
1. Shutdown the Database
SQL>shutdown immediate;
database closed
database dismounted
Oracle instance shut down
2. Open the Database Up-to mount stage.
SQL> Startup Mount
connected to target database (not started)
Oracle instance started
database mounted
Total System Global Area 1610609384 bytes
Fixed Size 9028328 bytes
Variable Size 402653184 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7745536 bytes
Advertisements
REPORT THIS AD
3. Enable the Archive log
alter database archivelog;
4. Check destination parameter and change value for archive generation.
-- check
show parameter log_archive_dest
–change value
alter system set log_archive_dest=’D:\Oracle’ scope=both;
5. Open the database.
alter database open;
6. Verify the archive generation by checking the location.
alter system switch logfile;
Disable the Archive Mode:
Rollback Process: noarchivelog
Shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
No comments:
Post a Comment