Login
Remember
Register
Oracle DBA Interview Questions
YouTube Subscribe
Training
Blog
Questions
Hot!
Tags
Categories
Ask a Question
Contact
Ask a Question
My entire database got crash, including pfile. But I have full backup in tape. How will you restore the db using RMAN?
371
views
asked
in
RMAN
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)
if u have alertlog file then in that pfile will avilable, using that pfile mount the database and using RMAN backup restore the database.
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)
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 storage is ASM and my archive log destination is full? Now what is the status of DB? how will you fix this?
How to delete database using RMAN?
Can you have many database versions in the same RAC?
How do you limit CPU utilization of individual database instances with in the Cluster ?
...