i.e. SQL> set linesize 2000 select sysdate,sum(apply_finish) apply_finish, sum(apply_lag) apply_lag, sum(transport_lag) transport_lag, sum(startup_time) startup_time, min(TIME_COMPUTED) TIME_COMPUTED from ( select decode(name,’apply …
Datafile 1 (ckpscn 139334570249) is orphaned on incarnation#=2 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback… Errors …
Errors in file …/trace/RAPOR_pr00_2801804.trc: ORA-01119: error in creating database file ‘/data/datafile_1.dbf’ ORA-27054: NFS file system where the file is created …
Some fast and easy configuration scripts for Physical Dataguard installation… PRIMARY Site ALTER SYSTEM SET db_unique_name = DATABASE; ALTER SYSTEM …
cold copy or begin backup & end backup ->> All .log .dbf Create standby control file ALTER DATABASE CREATE STANDBY …
root@primary:/>ps -ef |grep pmon user 372972 1 0 May 20 – 3:01 ora_pmon_sid root@primary:/>su – user user@primary:/swift/user>sqlplus / as sysdba …
@Standby ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=25G; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’/dir/oracle/flashback’; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; CREATE RESTORE POINT db_standby_test …
Check out the similarities and differences of DRC logic between the two DB vendors – MSFT & ORCL to understand …
SQL> select open_mode from v$database; OPEN_MODE MOUNTED SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. …
