Solved

Recovery Manager: Release 10.1.0.3.0 - 64bit Production

Posted on 2007-03-17
7
595 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

728 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