tgunduz
asked on
Recovery Manager: Release 10.1.0.3.0 - 64bit Production
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_2 007_3084_6 17499007 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_recov ery_area/S SMDB/archi velog/2007 _03_10/o1_ mf_1_10053 _2z6dnwqt_ .arc
Archive Log 99715 10-MAR-07 /u3/app/oracle/flash_recov ery_area/S SMDB/archi velog/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
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_2
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_recov
Archive Log 99715 10-MAR-07 /u3/app/oracle/flash_recov
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
ASKER
No I do not. But can build one.
Is this the only option/solution ?
Is this the only option/solution ?
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.
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.
ASKER
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
Can my test server be 32bit version ?
Do you think I ll have compatiblity problems with 64 / 32 Bit servers ?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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.
For the price of Intel hardware these days I suggest making a business case to your manager to obtain a second 64bit 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.