20 Haziran 2013 Perşembe

FRM-92050:Failed to connect to the Server








SOLUTİON:

You have to open port number 9010 on application server

14 Haziran 2013 Cuma

ORA-19804: cannot reclaim string bytes disk space from string limit



Problem:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit

Solution:

Increase your db_recovery_file_dest_size parameter.

SQL>alter system set db_recovery_file_dest_size=<size> scope=BOTH

'Both' means,parameter will change memory an spfile.This parameter dynamic parameter.So you can test backup now :)))

Happy Friday:))

RMAN-06214: Datafile Copy



Problem:

RMAN-06214: Datafile Copy   /u01/backup/online_backup/data_D-NECODB_I-439097153_TS-APPS_TS_SUMMARY_FNO-396_6fntn4p3


Solution:

RMAN> crosscheck copy;
RMAN> delete expired copy;