Login
Remember
Register
Oracle DBA Interview Questions
YouTube Subscribe
Training
Blog
Questions
Hot!
Tags
Categories
Ask a Question
Contact
Ask a Question
My storage is ASM and my archive log destination is full? Now what is the status of DB? how will you fix this?
846
views
asked
in
RAC
by
sateesh
Sr
(
300
points)
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
answered
by
Venkatesh Nelluri
Sr
(
260
points)
archive log destination is full then database in hang state, take the backup of the archive log and delete using rman, other wise execute below command in RMAN to take backup and delete automatically.
RMAN > backup archivelog all delete input.
Please
log in
or
register
to add a comment.
Categories
All categories
Oracle 19c
(1)
Jobs
(2)
DB New Features
(3)
12C Cloud
(24)
Scripts
(7)
RAC
(143)
Storage - ASM
(22)
Single Node RAC
(5)
12C RAC
(5)
Clusterware
(9)
Troubleshooting
(7)
Streams
(11)
11G DBA
(68)
RMAN
(21)
Logical backups
(1)
Dataguard
(14)
Golden Gate
(19)
Tuning
(20)
OEM
(3)
NoSQL - Oracle
(4)
SQL Server
(2)
Sybase ASE
(3)
Infosys
(0)
TCS
(0)
Cognizant
(0)
Most popular tags
rac
asm
11g
12c
tuning
goldengate
single node rac
node eviction
rman
11g new features
streams
tablespace
dataguard
oracle
diagnostic files
cloud
rac training
dba training
incremental backups
temp tablespace
multitenant
undo
grid
flashback
xml db
change tracking
12c new features
dba
undo management
sybase
asmb
grid computing
ora-19809
free space
fan
scripts
taf
clusterware
cluster
sql
sql server
oracle training
oracle dba jobs
dba jobs
rules
lcr
grid installation
oracle dba
ora-19804
archive logs
active dataguard
replication
nosql
sort usage
v$temp_space_header
instance recovery
haip
memory tuning
stream
control files
corrupt
jobs
ora-1555
rollback segment
temp
physical standby
dgmgrl
deadlock
retention
sga
9i
backups
vip
delete
components
10g
standby
upgrade
architecture
pdb
instance
trail
gg
pfile
oracle database 19c new features for developers
oracle database 19c new features for administrators
oracle database 19c new features for dba
oracle database 19c database new features
ora-00214: control file version inconsistent with file
ora-00214 control file inconsistent
control file version inconsistent with file
ora-00214 control file version inconsistent with file
sysbackup privilege
sql interface improvements
rman enhancements
oracle 12c new feature
oracle 12c new feature rman enhancements
ora-19625
error identifying file
rename pdb
Related questions
My OCR file is corrupted and I don’t have the backup. What will happened to Database ? how will you resolve this?
My entire database got crash, including pfile. But I have full backup in tape. How will you restore the db using RMAN?
if archive log destination full in primary database then what are the necessary steps to resolve.
How do you find protection mode, the protection level, the role of the database, and switchover status ?
What is the minimum size of the SGA for an ASM Instance? Does it has Controlfiles and Redo?
...