- To backup the database, use below query.
Backup database <databaseName> to disk ='<backupLocation>.bak' with init; - To backup the logs, use below query.
Backup log <databaseName> to disk ='<backupLocation>.trn' with init; - To restore from the database backup, use below query.
restore database <databaseName> from disk =<backupLocation>.bak' with norecovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'; - To restore from the transaction log, use below query.
restore log <databaseName> from disk ='<backupLocation>.trn' with recovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'
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;
Comments
Post a Comment