I am new to Oracle. From Yesterday, I installed a Oracle 11g Database and took me 3 hours to figure out how to do a full backup. After that, I want to test how to restore it as new db and not overwrite the old db.
is there a GUI tool I can implement it? or How can I do this from RMAN/SQLPLUS?
I have a full backup from EM. It is including datafile , archivelog and control file. names like below.
And another question, I have a new project which will use Oracle. Client will provide us Database and I will restore it to our Oracle Server.
which kind of format for me is easy to install this DB?
1. Directly cold copy.
2. full backup