?
Solved

Recovery Manager: Release 10.1.0.3.0 - 64bit Production

Posted on 2007-03-17
7
Medium Priority
?
600 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 1500 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

777 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