I m gettgin a full log of Recovery Manager on daily basis.
Before in kgllkdl(), hd=105ca40.
connected to target database: SSMDB (DBID=3501530375)
connected to recovery catalog database
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 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.
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
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
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.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.