⟩ How to know the last executed procedure?
Execute procedure name (parameter1,parameter2)
Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.
Execute procedure name (parameter1,parameter2)
Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.
Do you know what is the purpose of SCAN?
Do you know what are the tools provided in Oracle Enterprise Manager?
How to setup the RMAN tape backups?
How to clone the database using RMAN software? Give brief steps? When do you use crosscheck command?
Tell me Is it possible to take Catalog Database Backup using RMAN?
What are the steps required to perform in $ORACLE_HOME for enabling the RMAN backups with netbackup or TSM tape library software?
Tell us In catalog database, if some of the blocks are corrupted due to system crash, How will you recover?
List some of the RMAN catalog view names which contains the catalog information?
Explain the steps involved in TIME based recovery from the full database from hot backup?
Explain the encryption options available with RMAN?