Solved

Recovery Manager: Release 10.1.0.3.0 - 64bit Production

Posted on 2007-03-17
7
576 Views
Last Modified: 2013-12-19
Hi Experts
I m gettgin a full log of Recovery Manager on daily basis.
With lines
Before in kgllkdl(), hd=105ca40.
..
and
connected to target database: SSMDB (DBID=3501530375)
connected to recovery catalog database

and
RMAN> 2> 3> 4>

Starting backup at 17-MAR-07
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=111 devtype=DISK
channel ORA_DISK_1: finished piece 1 at 17-MAR-07
piece handle=/backup/ARC_17_03_2007_3084_617499007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:50
RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          99714  10-MAR-07          /u3/app/oracle/flash_recovery_area/SSMDB/archivelog/2007_03_10/o1_mf_1_10053_2z6dnwqt_.arc
Archive Log          99715  10-MAR-07          /u3/app/oracle/flash_recovery_area/SSMDB/archivelog/2007_03_10/o1_mf_1_10054_2z6dnwtl_.arc

the log file fninished with

Before in kgllkdl(), hd=15b1f28.
RMAN>
Recovery Manager complete.

I am not sure if my backups are reliable. The company who set up the back-up cron is very confident.

How can I be 100% sure that in case of worst case scenario I can recover my database.
I can not past here full logs due to lack of space....
Any help / URL / ETC.... is higly appreaciated

Thank  you
0
Comment
Question by:tgunduz
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:dbnetsi
ID: 18754034
Do you have a test server.
Conduct a full recovery of your database to a test server is the best way. If that is not possible as you don't have a separate server then try duplicating your database on the same server. If you don't have sufficient space for that and management wont supply the test server update your resume and look for a new job, you don't want to be there and find out it doesn't work.
Good  Practice dictates that you do a regular recovery of your database from tapes.

0
 

Author Comment

by:tgunduz
ID: 18758546
No I do not. But can build one.
Is this the only option/solution ?
0
 
LVL 2

Expert Comment

by:dbnetsi
ID: 18760684
It would be highly recommended. You make it as close as possible to being a mirror of your production server  OS, database version etc you can then use it to test patching strategies. It can also be part of your general DR plan as you can look to setting it up as a fail over server if your production servr fails. Just check your licensing requirements for Oracle.

This will allow you do patch and test against the non production server when you need to apply an Oracle patch.

Alternatively if space allows you can do restores or duplicates to a location on the same server as your existing database resides, if you have the space.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:tgunduz
ID: 18764846
I m using  10G_R1   10.1.0.3.0 - 64bit version

Can my test server be 32bit version ?
Do you think I ll have compatiblity problems with 64 / 32 Bit servers ?

Thank you
0
 
LVL 2

Accepted Solution

by:
dbnetsi earned 500 total points
ID: 18768920
Hi I am not entirely sure of that I understand that 64 and 32 bit datafiles are no different so you may well be able to. For validation of a production server I wouldn't really recommend it, however it would be better than nothing and a good test. I would always recommend that you use the same platforms as there has been times when  an Oracle patch has worked on 32bit and not on 64 and sometimes you may require a patch that is only relevant to 64 bit.

As long as your servers are of the same product that is Intel or Sun or what ever then you should be ok. As far as I know you currently cant restore a database from a sun spar server to an Intel server.
0
 

Author Comment

by:tgunduz
ID: 18769940
Hi
Processors are both Intel
Prod server is 64bits
Test server is 32bits
The DB version will be the same 10G Release 1 ( 10.1.0.3.0 ) on both platforms
Regards


0
 
LVL 2

Expert Comment

by:dbnetsi
ID: 18771144
The only reference to this I can find as I have not done it is that the 64 and 32 bit controlfiles are different and you may have trouble with those restoring to 32bit. This could be your dilemna as it appeared to stop RMAN in its tracks however it may be the restore behavior and if you do a duplicate it might work.
For the price of Intel hardware these days I suggest making a business case to your manager to obtain a second 64bit server.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now