Hi,
How to create the backup of the database as well as individual schema inside the database using Oracle 11g? Whether we can use :-
1)Alter database backup controlfile to ‘<path>\ backup filename’
& restore it using the below:-
Recover database until cancel using backup controlfile;
(OR)
2) Whether we can use Flashback and Restore of Oracle 11 as below:-
alter database flashback on;
and restore the db :-
create restore point <restore point name>
Which of the above we need to use? How to take the backup of the schema as supposed to whole DB? Please clarify.
Thanks