Database Backup and Recovery (MOSC)

MOSC Banner

How to execute an rman backup of in 10.2.0.4 DB (8TB) with no free space in local FRA

(Primary 10.2.0.4):Dell PowerEdge R720 (Physical)

(Standby 10.2.0.4):Dell PowerEdge R720 (Physical) Down due to Hardware failure

Replication using DBVisit

RAM: 32GB

CPU: 2 Quad Cores (8 CPUs)

Storage: 10TB

RAID-10

O/S RH Linux 6.3 (Santiago)

Standalone installation with Non-ASM

===================================================

Tablespace                     Size (MB) Free (MB)    % Free    % Used     

------------------------------ ---------- ---------- ---------- ----------     

USERS                                680      9.38         1        99     

AWUNADM                       7853468.73   3115.06         0       100     

AWADM                           76484.05      2.88         0       100  

SYSAUX                               630     30.75         5        95     

SYSTEM                               610      4.38         1        99     

UNDOTBS1                           32765  32670.75       100         0 

TEMP                                1024         0       200       300   

=============================================== ======================

Good Morning Oracle Gurus:

I am seeking advice and guidance to resolve the following 10.2.0.4 database backup/recovery problem. I have provided the environment details above for your information.

The physical standby is down due to a hardware failure. No rman backups have been configured because the Government of Belize Customs department is using DBVisit for the purpose of replication to the standby. Therefore no current backup of the production primary 10g database exists.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center