Posts

FLASHBACK RAC DATABASE WITHOUT STANDBY DATABASE

RAC Database -> Flashback to Different Restore Points
Precheck ============= SQL>select name,time from v$restore_point; NAMETIME --------------------------------------------------------------------------- BEFORE_UPGRADE21-FEB-18 04.37.05.000000000 PM
Flashback is off with guarantee flashback database
SQL> select log_mode,flashback_on from v$database;
LOG_MODEFLASHBACK_ON ------------------------------------ ------------------------------------------------------ ARCHIVELOGRESTORE POINT ONLY
I am going to create a restore point before changing further
Create a restore point RP02 ======================== SQL> create restore point RP02 guarantee flashback database; Restore point created.
Doing some change to the database [Create a table test03 – After RP02 and before RP03]
SQL> create table test03 (col1 number) tablespace users; Table created.
SQL> insert into test03 values ('03'); 1 row created.
SQL> commit; Commit complete.
Create another restore point RP03 ======================…

Oracle 12cR2 RAC Database Software Installation and Create Database

Oracle 12cR2 Grid Infrastructure installation

Add additional node to 12cR2 RAC Cluster Testing

Image