Dinesh DBA

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process When we are taking archive log backup with delete then got an error. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/pac/lci9t1/arch/redo_1_16470_842608348.arc thread=1 sequence=16470 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/pac/lci9t1/arch/redo_1_16471_842608348.arc thread=1 sequence=16471 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process SOLUATION: Cause: The archive logs seems that it is not yet applied in the standby database.                         Select sequence# , applied from v$archived_log; Action: Check the standby database and apply t...

When i was tried to restored the backup i found below error  message RMAN-03002: failure of recover command at 05/29/2019 15:35:47 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover  if needed standby start ORA-00283: recovery session canceled due to errors ORA-19909: datafile 1 belongs to an orphan incarnation ORA-01110: data file 1: '/oradbf1/oradata/ctsdb/system01.dbf' Primary and standby have different incarnations: standby db: RMAN> list incarnation of database; List of Database Incarnations DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1       1       CTSDB    193365640        PARENT  1          31-JAN-17 2    ...

New in Oracle 12c database Architecture, as well as the ability to restore one table from an RMAN backup.  This blog post explains how to do a restore of one table in a database. Setup the test: 1.) Create a user – tables cannot be restored in the SYS schema 2.) Create a table for that user 3.) Take a backup – a backup of the table has to exist; it can’t just be in archive logs. 4.) Drop the table 5.) Restore the table 6.) Check that the table has been restored 1.)    Create a user: CONN / AS SYSDBA   CREATE USER test IDENTIFIED BY test   QUOTA UNLIMITED ON users;   GRANT CREATE SESSION, CREATE TABLE TO test; 2.) Create a table for that user: CONN test/test   CREATE TABLE t1 (id NUMBER); INSERT INTO t1 VALUES (1); COMMIT; 3.) To Check the current SCN or TIMESTAMP :        CONN / AS SYSDBA   SELECT DBMS_FLASHBACK.get_system_change_number FROM dual;   GET_SYSTEM...

Oracle 12C Database Creation - Manual Method 1. Install the Oracle Software in the Primary Server 192.2.4.45. 1.1 Create Directories for the File Locations : =============================================== [oracle@orman01 prod]$ pwd                                                                                                                                                      /oracle/app/oracle/oradata [oracle@orman01 oradata]$ mkdir prod [oracle@orman01 prod]$ cd /oracle/app/oracle/oradata/prod/ [oracle@orman01 prod]$ mkdir -p flash_recovery_area archive_log adump  [oracle@orman01 prod]$ ...