Topic: Backup & Recovery >> Backup Starategy
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| ankur |
Posted: Jan 30, 2007 04:07:32 AM |
Total Post: 59
Joined: Nov, 2006
|
I am using Oracle9i Database.
My Database is in NOARCHIVELOG mode and this is a Testing database.
Which strategy should i follow to take backup of complete database so that minimum time and minimum Data loss occurs.
Before that i was using Export utility of whole database bus when it comes to recovery of that ,it is asking for the complete tablespace structure as well as the users info which i didnt back up while taking backup of database....
Plz tell me the solution in either case
either new Backup Strategy or recovery of whole database from complete database export |
|
|
 Anu |
| Posted: Jan 30, 2007 05:23:04 AM |  |
|
Total Post: 7
Joined: Jan, 2007
|
First know some thing
NOARCHIVELOG mode may be suitable when:
Data loss between backups can be tolerated (during development, training, etc.)
It is faster to reapply transactions (from batch files)
Data rarely changes (non-OLTP)
So you can opt for Cold Database backup.
That is
Shut down your database
Take OS level copy of following files to some other location.
DATAFILE
ONLINE REDO LOGFILE
CONTROL FILE
TEMPERARY and UNDO DATAFILE
PARAMETER FILE
Do remember the file structure of these files. Keep in mind that you whould be able to restore database till the time you backup you database.
I would recommend you to alter database to archive log mode for point in time recovery. Thus you could later on apply archived log files for restoration of the database.
|
|
|
|
|
| ankur |
| Posted: Jan 30, 2007 05:32:44 AM | |
|
Total Post: 59
Joined: Nov, 2006
|
Thankx a lot anu
This is a development database so mild data loss is affordable ..
I restored data from cold backup
But to keep cold backup on week basis is very memory consuming work....
Is there is any other option for backup strategy in NOARCHIVELOG mode.
And do u know how to recover from export backup????
|
|
|
|
|
| Anu |
| Posted: Jan 31, 2007 01:43:34 AM | |
|
Total Post: 7
Joined: Jan, 2007
|
You can use RMAN Utility with INCREMENTAL backup.
But first decide what type of Backup type will suite you.
Diffrential incremental backup that contain only modified blocks from level n or lower.
Cumulative incremental backup that contain only modified blocks from level n-1 or lower.
Incremental backups are specified through the INCREMENTAL keyword of the BACKUP command. You specify INCREMENTAL LEVEL = integer where integer is any integer from 1 to 4.
A level 0 backup must exist as the base backup for an incremental strategy. An incremental backup at level 0 is identical in content to a full backup, but unlike a full backup the level 0 backup is considered a part of the incremental strategy. If no level 0 backup exists when you run a level 1 or higher backup, RMAN makes a level 0 backup automatically.
Backup Constraints
When performing a backup using Recovery Manager, you must be aware of the following:
1.The target database must be mounted for Recovery Manager to connect.
Backups of online redo logs are not supported.
2.If the target database is in NOARCHIVELOG mode, only “clean” tablespace and datafile backups can be taken (that is, backups of “offline normal” or “read only” tablespaces).
3.Database backups can be taken only if the database has first been shut down cleanly and restarted in Mount mode.
4.If the target database is in ARCHIVELOG mode, only “current” datafiles can be backed up (restored datafiles are made current by recovery).
If a recovery catalog is used, the recovery catalog database must be open.
Adding to Perform a Multiplexed Backup in NOARCHIVELOG Mode
1.Ensure that the destination directory where you want to store the backup is available and has sufficient space.
2.Shut down the database cleanly using the NORMAL, IMMEDIATE, or TRANSACTIONAL clause.
3.Mount the database.
4.If you are not using automatic channel allocation, allocate multiple channels and use a format string to multiplex channels to different disks.
5.Run the BACKUP command. Because the database is in NOARCHIVELOG mode, the incremental backups are not applicable, so use the full backup option.
6.Verify that the backup is finished and cataloged.
7.Open the database for normal use.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 855 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 275 |
| neeraj sharma | 254 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
