EBS System Date Change - 19c (CDB/PDB)

EBS System Date Change  - 19c (CDB/PDB):

1. MT level -  CM logs backed up with CM down, then using 'mv' for the large directories.

2. DB level - turned on flashback, created restore point for the PDB.

3. Changed fixed_date at PDB level

ALTER SYSTEM SET fixed_date='2022-10-31:10:10:10' SCOPE=BOTH SID='*' PDB='SRN5I';

----

ALTER SYSTEM SET fixed_date='2022-10-31:10:10:10' SCOPE=BOTH SID='*';

ALTER SYSTEM SET fixed_date='2022-10-31:10:10:10' SCOPE=BOTH SID='*' PDB='SRN5I';

ALTER SYSTEM SET fixed_date='NONE' SCOPE=BOTH SID='*';

SQL> show con_name;

CON_NAME

------------------------------

CDB$ROOT

SQL> alter system set fixed_date =none scope=both sid='*';

System altered.

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

fixed_date                           string      NONE

SQL> select sysdate from dual;

SYSDATE

---------

16-JUN-22

 alter session set container=SRN5I;

select sysdate from dual;

SYSDATE

---------

31-OCT-22