This is consistent backup that means all datafiles and controlfiles are consistent to point in time.database in no archive log mode.
Steps....
- shutdown the database ,sql>shutdown normal
- Copy the controlfiles and datafiles,parameter file and passwordfile os level and then paste it in another location.
- startup database ,sql>startup
Example.....
- shutdown the database, drop the all controlfiles and datafiles and then startup the database.
- Error ora-00205-Error in identifying the control files for the location.
- If you have 5 multiplexing controlfiles,2 multiplexing in different location and remain 3 controlfiles were dropped,you should modify the location in parameter file current controlfile and then save it.
- startup the database using parameter files.
- In mount database,error will appear.
- Recover datafile system and then some datafile , in this case you should copy the backup files and paste it in default location.
sql>recover database;
media recovery complete.
sql>alter database open;
Database opened.
0 comments:
Post a Comment