RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process - Oracle 11g Standby Database

 RMAN> show all;

 There would be like following deletion policy in your current rman configuration :

 CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

 Now :

 

1. Change the Archive log deletion policy to STANDBY:

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

 2. delete the obsolete:

delete noprompt force archivelog until time 'sysdate-10';

 3. revert the old values:

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

4. show all;

Comments

Post a Comment

Popular posts from this blog

adop phase=prepare [ERROR] META:18:03:58.800: bad stylesheet: kustrigc (Tested on R12.2.5 by me)

Initializing.     Run Edition context  : /oradev/oracle/r12/uat/fs1/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch edition context: /oradev/oracle/r12/uat/fs2/inst/apps/sid_hostname/appl/admin/sid_hostname.xml     Patch file system free space: 222.29 GB Validating system setup.     Node registry is valid.     [ERROR]     META:18:03:58.800: bad stylesheet: kustrigc     Encountered the above errors when performing database validations.     Resolve the above errors and restart adop. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files along with snippet of the error message corresponding to each log file. adop exiting with status = 1 (Fail) $ Solution: 1. To find the current version of the adgrants.sql script on the instance, do the following:   a. Source the database environ...
Read more

After cloning - adapcctl.sh: exiting with status 204

After cloning on appsTier, following was error as on source SSO was enabled: Error: applprod@hostname:…1_hostname/admin/scripts$ sh adapcctl.sh start                                                                                            You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance ... adapcctl.sh: exiting with status 204 In the logfile: 19/07/09 20:35:17 Start process -------- /erp_ndr/app/inst/apps/SID_hostname/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing ht...
Read more

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more