Purpose

Use the CREATE RESTORE POINT statement to create a restore point, which is a name associated with an SCN of the database corresponding to the time of the creation of the restore point. A restore point can be used to flash a table or the database back to the time of creation of the restore point without the need to determine the SCN or timestamp.

There are two types of restore point:
• Guaranteed restore points: A guaranteed restore point enables you to flash the database back to the restore point regardless of the DB_FLASHBACK_RETENTION_TARGET initialization parameter setting.
Guaranteed restore points must be dropped explicitly by the user using the DROP RESTORE POINT statement. They do not age out.
• Normal restore points: A normal restore point enables you to flash the database back to a restore point within the time period determined by the DB_FLASHBACK_RETENTION_TARGET initialization parameter. You can explicitly drop a normal restore point using the DROP RESTORE POINT statement.

Read more...

If the processes do not match for Output Post Processor

CONCURRENT_QUEUE_NAME RUNNING_PROCESSES TARGET_PROCESSES MAX_PROCESSES MIN_PROCESSES
-------------------- ----------------- ---------------- ------------- -------------
FNDCPOPP 6 3 3 3

Check Internal Manager log

Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Process monitor session started : 15-APR-2015 14:05:45
Internal Concurrent Manager found node APPROD to be down. Adding it to the list of unavailable nodes.
Internal Concurrent Manager found node DBPROD to be down. Adding it to the list of unavailable nodes.
CONC-SM TNS FAIL
Call to PingProcess failed for XDPCTRLS
CONC-SM TNS FAIL
Call to PingProcess failed for XDPQORDS

Call to PingProcess failed for FNDOPP
CONC-SM TNS FAIL
Call to PingProcess failed for FNDOPP
CONC-SM TNS FAIL
Call to PingProcess failed for FNDOPP

Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:11
Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:11
Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:12

Read more...

This script will report on all backups – full, incremental and archivelog backups.

col STATUS format a9
col hrs format 999.99
select session_key, input_type, status,to_char(start_time,'mm/dd/yy hh24:mi') start_time,to_char(end_time,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$rman_backup_job_details order by session_key;

SESSION_KEY  INPUT_TYPE    STATUS              START_TIME           END_TIME              HRS
--------------------------------------------------------------------------------------------------------------------------------
378                   DB FULL          RUNNING            02/25/15 08:10      02/25/15 10:15     2.08416
378                   DB FULL          COMPLETED       02/25/15 08:10      02/25/15 10:31     2.35944
386                   BACKUPSET    RUNNING           02/25/15 10:31      02/25/15 11:03     0.53305
386                   BACKUPSET    COMPLETED       02/25/15 10:31      02/25/15 11:20     0.81388
========================================================================================

Monitor RMAN Progress

Read more...

Navigate to:
System Administrator > Concurrent > Program > Define > Query the program name
Copy the executable name

Navigate to:
System Administrator > Concurrent > Program > Executable
Query the copied executable name
Executable File Name is the name of the RDF

SELECT APPLICATION_NAME,'$'||BASEPATH||'/'||'reports/US' Reports_Path,EXECUTION_FILE_NAME FROM APPS.FND_EXECUTABLES_VL A, APPS.FND_APPLICATION_VL B WHERE EXECUTION_METHOD_CODE='P' AND A.APPLICATION_ID=B.APPLICATION_ID AND EXECUTION_FILE_NAME like '%&RDF_NAME%';

Enter value for rdf_name: GLXCAR

APPLICATION_NAME: General Ledger
REPORTS_PATH: $GL_TOP/reports/US
EXECUTION_FILE_NAME: GLXCAR

Applies To:-

Oracle Applications Framework - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
 

Solution:-

To implement this there are 2 actions required:
Read more...