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
