• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Raise oracle backup

I have got an Oracle 11 backup . But it is more than 10 .bck files ( ranging from 9gb to 2 MB .   There is no script. But I have a Oracle database created for a different purpose. How do I raise the oracle backup there ?
0
Sam OZ
Asked:
Sam OZ
1 Solution
 
Geert GOracle dbaCommented:
do the backup files contain numbers ?
you'll need the dbid if you want to restore the database

post the names of the backup files
it's possible we can recognise the backup file types and help you build a restore script with it
0
 
slightwv (䄆 Netminder) Commented:
You need to know what backup software created those files and specifically how.  Most backup software products have several different and varying options when it comes to performing the backup.

I would check with the DBA or System Admin that created them.
0
 
Sam OZAuthor Commented:
Hi,
  Thanks. please see the backup names in the attachment
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
Sam OZAuthor Commented:
Incase the attachment did not come thru, the snapshot is here https://imgur.com/a/KyqBp
0
 
Sam OZAuthor Commented:
Just to add, this is an rman backup . But can you please tell how I can restore it ?
0
 
slightwv (䄆 Netminder) Commented:
There are really too many factors about RMAN recovery to provide the exact steps you need to perform.

This is just a quick list off the top of my head.  It is not meant to be an inclusive list of what we would need:
What caused the need to recover from backups?
Are you recovering on a new server or the one where the failure took place?
Are you doing a complete or point of failure recovery or a point in time recovery?

It might be as simple as a "recover database" from the RMAN command.


I would start in the online documentation.

Database Backup and Recovery User's Guide
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/part-diagnosing-responding-failures.html#GUID-ED89DC53-A816-450B-BFF4-A712D2694EEC

If possible, I would work with the DBA that set up the backups.  I would also suggest working directly with Oracle Support if the database is important to operations.
0
 
Mark GeerlingsDatabase AdministratorCommented:
You normally don't take an Oracle backup from one system and restore that into an existing Oracle database on a different system.  An Oracle export can be used that way, but not an Oracle backup.

An Oracle backup is usually used to either create a complete copy of a database on a different server, or to restore the database that was backed up to as it was at the point in time when the backup was taken.

We don't know where or why you want to restore the backup that you have.  If you can answer some of the questions that slightwv asked, that could help us know exactly what you are trying to do.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now