Point - in - time restore

Point in time restore requires a full log chain. This means you need to restore that last full backup and all log backups including the one which contains the point you would like to restore to.RESTORE DATABASE <databaseName> FROM DISK = 'E:\Backup\test.bak' WITH FILE = 2 ,REPLACE ,NORECOVERY;From the above, we will restore the full backup from the file 'E:\Backup\test.bak'. Since this file contains multiple backups, we need to specify which FILE to use.
You can identify the file number by looking at the Position column when executing this command:
RESTORE HEADERONLY FROM DISK = 'E:\Backup\test.bak';
Restore each log, specifying the date and time to STOP AT. This needs to be specified in each RESTORE LOG statement
RESTORE LOG <databaseName> FROM DISK = 'E:\Backup\test.bak' WITH FILE = 4 ,NORECOVERY ,STOPAT = '2013-09-28 10:16:28.873’;
And finally recover the database
RESTORE DATABASE < databaseName> WITH RECOVERY;

What need to do when encounter the error ORA-28001: the password has expired

When you encounter the error ORA-28001: the password has expired, execute below queries to resolve this. export ORACLE_SID=< databaseName> sqlplus / as SYSDBA SQL> alter profile default limit password_life_time unlimited; SQL> alter user <userName> identified by <password>; SQL> commit; SQL> exit;

Alter auto extent on existing datafile in Oracle

To alter the existing datafile in Oracle database, use below query. alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' autoextend on maxsize unlimited;

Get all constraints in Oracle

To get all the constraints created in Oracle database, use below query. SELECT * FROM USER_CONSTRAINTS; If you want to get the constraints created for a particular user then use below SQL query. SELECT * FROM USER_CONSTRAINTS where owner = 'userName';

Databases

Search This Blog