Monthly Archives: August 2007

Flashback using Restore Point

PITR (Point In Time Recovery) was never so easy!!! Just follow some simple steps & use the power of flashback SQL> SHUTDOWN DATABASESQL> STARTUP MOUNTSQL> ALTER DATABASE ARCHIVELOG;SQL> ALTER DATABASE SET DB_RECOVERY_FILE_DEST_SIZE=200G; SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+FLASH1′;SQL> ALTER DATABASE FLASHBACK … Continue reading

Posted in Oracle Database Architecture | Tagged | Leave a comment