on 03-14-2014 9:53 AM
Hi there,
I am trying to do a full system copy from PROD into QA on a different host.
I will be using the latest offline backup.
I have read on this site that if you are using an online backup then use the BRRECOVER
and if you are using an offline backup which I am then to use the BRRESTORE.
I am a little confused. I am struggling with the control file creation after the restore has taken place.
Can I use the BRRECOVER even though I will be using an offline backup? Will this re-create
the control file automatically??
Hope this makes sense!
Thanks
Andy
Hi Andy,
brrestore is used to restore the files from the backup media.
brrecover is used to recover the database post restoration.
Whether you have offline backup or online backup you need to use brrestore for restoration.
So you can go ahead with brrrestore -m full -b <backup filename> to start the restore
Once the restore is completed you can open the database using
SQL> alter database open resetlogs;
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK,
So Can I presume if I use BRRECOVER it does everything i.e. creates control file
but if I use BRRESTORE I will then need to create the control file manually?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for your case, you have to use brrestore
1) brrestore - restore the datafiles from specific backup
2)manual creation of controlfile (changing sid from PRD TO QAS)
3) recovery
brrecover can be used for
· Complete database recovery
· Database point-in-time (PIT) recovery
· Tablespace point-in-time (PIT) recovery
· Whole database reset
· Restore of individual backup files
· Restore and application of offline redo log files
· Disaster recovery
Thanks ,Siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.