Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create backup of the database and individual Schema in Oracle 11g

User_19BPUNov 1 2015 — edited Nov 1 2015

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



Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2015
Added on Nov 1 2015
6 comments
2,657 views