I have an oracleXE database running on one server and would like to copy that DB to another server running oracleXE as a test environment. I did a backup of the database on the prod server, copied the files in the flash_recovery_area on the prod server to the test server, but cannot get it to restore. It says
RMAN-04014: startup failed: ORA-02778: Name given for the log directory is invalid
Recovery Manager complete.
==================== ERROR =============================
Restore of the database failed.
RMAN Error - See log for error .
Log file is at D:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OX
Any help getting my prod DB copied to a test environment would be appreciated
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.