RMAN :: Where Does Control File Auto-backup Information Gets Stored
Jun 15, 2012where does the control file auto-backup information gets stored? or how does a RMAN knows from where to restore a controlfile in auto backup?
View 12 Replies
ADVERTISEMENT
Backup & Recovery :: RMAN Control File Auto Backup Error?
Dec 13, 2011This is what I run
run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';
[code]...
So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.
Backup & Recovery :: Changing Location Of Data And Temp Files From Auto-backup Of Control-file?
Jan 26, 2012I have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.
I have completed the following steps in the restore process.
1. Creating a pfile from spfile
2. Changing the the location of cdump, udump, bdump and the control files ( there are three )
3. Then creating a spfile from this pfile
I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.
After mounting the database in RMAN, tried to run the following.
RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';
[code]....
I am getting the following error message.
Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28
[code]....
RMAN :: How To Know Control File Name From Tape Backup
Aug 19, 2012I have RMAN backup on TAPE. I need to restore control file for particular date on another host. How do I restore control file to new host for particular date?
EXAMPLE:
4949 Full 11.25M SBT_TAPE 00:01:09 06-AUG-12
BP Key: 4949 Status: AVAILABLE Compressed: NO Tag: TAG20120806T223455
Handle: COTSPRD_c-4007601229-20120806-00 Media: 030256
SPFILE Included: Modification time: 28-MAR-12
SPFILE db_unique_name: COTSPRD
Control File Included: Ckp SCN: 237324864 Ckp time: 06-AUG-12
Can I rrun command like :
RESTORE CONTROLFILE FROM TAG 'TAG20120806T223455;
I need to clone from tape to another server for particular date.
Backup & Recovery :: No RMAN Records In Control File
Dec 7, 2012We're running 10.2.0.4 Database on AIX with no catalog Database.We keep all the backup info in controlfiles only.When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.
SQL> select * from V$BACKUP_SET;
no rows selected
and
SQL> sho parameter control
NAME TYPE VALUE
------------------------------------ ------------------------------
control_file_record_keep_time integer 14
RMAN :: 06024 - No Backup Or Copy Of Control File Found To Restore
May 31, 2013I have installed oracle 11.2 on virtual machine and made two copy of this vm i.e vm1 and vm2...i have taken fullbackup with rman on vm1 and autobackup of control file.Now i want to restore this backup on vm2, for this i have configured channel and other setting. run following command
catalog start with '\server3database_backup
manC-3507808503-20130531-00';
"C-3507808503-20130531-00" is the name of control file autobackup.
RESTORE CONTROLFILE ;
it gives me error RMAN-06496: must use the TO clause when the database is mounted or open...then i use following command
RESTORE CONTROLFILE to 'C:oracleAdministratororadataslate';
then it gives me error RMAN-06024: no backup or copy of the control file found to restore...how to restore control file to vm2
Backup & Recovery :: RMAN - Control File Be Used To Store Scripts Which Are Used To Perform Backups?
May 12, 2011Can the control file be used to store scripts which are used to perform backups? I know the RMAN recovery catalog can.
Does the SHOW command display detailed reporting on the RMAN catalog contents other than configuration information?
Backup & Recovery :: RMAN Using Target Database Control File / Separate Catalog Database
Mar 14, 2012How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
View 3 Replies View RelatedBackup & Recovery :: Can A Control File Backed Up Be Present In Multiple Backup Pieces
Sep 27, 2011Suppose I take a multi stream backup, say 3 streams.
So if a control file is backed up in say backup set 1, so is the whole control file is backed up in one backup piece or it may span multiple pieces?
A backup set may have multiple backup pieces.
Backup & Recovery :: Restoring Later Backup Control File And Recovering Till Past Scn
Jul 11, 2012I want to ask if I restore a control file from backup of say day2 and I recover till day1 using RMAN script, then what will be the state of my database? I mean day2 control file may be having SCN-Day2, and I am instructing RMAN to recover till past point in time that is SCN-Day1.
View 3 Replies View RelatedBackup & Recovery :: Configuration Can't Be Changed For BACKUP Or STANDBY Control File
Sep 18, 2012On my stand by DB when I run the following command I get this error:
Is this line really needed based on my run block?
run
{
sql 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE';
allocate channel t1 type 'SBT_TAPE'
[Code]....
Backup & Recovery :: Backup Of Control File On Standby Node?
Apr 3, 2013I am trying to backup my control on a STBBY DB(RAC) and I am getting the ollowing error.
ORA-00245: control file backup failed; target is likely on a local file system
what the issue is? Note the FS is ACFS and can see on all my nodes
show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PA01INS_IM3L059B are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
[code]...
ACFS file system
df -h /share/dbbkup/oracle/PA01INS/rman
Filesystem Size Used Avail Use% Mounted on
/dev/asm/pa01ins-33 75G 2.6G 73G 4% /share/dbbkup/oracle/PA01INS
rman cmdfile=control.rman
[code]...
QUOTE V$DATABASE Displays Information About Database From Control File
Feb 8, 2011The documentation for v$database says: QUOTE V$DATABASE displays information about the database from the control file. Is it safe to assume that there will only ever be one row queried from this view?
View 2 Replies View RelatedBackup & Recovery :: Restore Control File Backup
Feb 10, 2011 I take hot backup of database at 10:00 am.After taking the hot backup 50 archived logs are created.Out of 50 i have backed up first 25 of them and at 5:00pm i lose complete database including control,data and the last 25 archived log files that were not backed up.So I am using latest hot backup to recover
I restore the control file backup and datafile backup taken during ho tbackup(10 am) and i issue the command
.......startup mount
>>>>>>>Recover database until cancel
!!!!!!! Apply the available 25 archive logs
then i give "cancel" since I dont have the next redo log .Now in which mode will the database open(Reset logs or no reset logs)
Backup & Recovery :: To Restore Control File From Backup Set
Dec 9, 2011I want to restore control file from backup set,just as the flowing command,where location does the control file be restored to? how can i specify the location when restore control file?
restore controlfile from '/u01/rman_backup/mybak/df_768589733_7_1.bak';
Backup & Recovery :: Backup Control File To Trace?
May 28, 2012taking the backup of a control file, as i am taking online backup, archive mode.
At first i have executed the statement
sql> alter database backup control file to trace;
then i have removed the control files and enterd some data in a table and committed it.As my oracle is not shutting down, so i shut aborted it. Now after saving the last file from the udump as obkp.sql i am unable to edit this file and use.
how to edit and use this file, so that i can startup my database normally.
Backup & Recovery :: How Many Times To Backup Control-file
Jan 5, 2012When i issue this command ,how many times to backup controlfile?
RMAN> BACKUP CURRENT CONTROLFILE INCLUDE CURRENT CONTROLFILE;
Is there difference between 'BACKUP CURRENT CONTROLFILE INCLUDE CURRENT CONTROLFILE' and 'BACKUP CURRENT CONTROLFILE'?
RMAN :: Recovery Failed In Control File?
Sep 27, 2013I took database backup without "change the controlfile configuration autobackup on".. and unfortunately i deleted my controlfile. Then I tried to restore my controlfile but it gives error,now how can i restore controlfile is there any other way to restore controlfile with aautobackup..
View 17 Replies View RelatedRecovery Manager (RMAN) :: Control File Restoration
Mar 7, 2013We have Oracle 11g on Windows and Daily full Netbackup on Tape @3:00 Am and on disk @3:00 Pm .When we try to restore DB with following command it restore control file from Disk and Not from Tape .
RMAN> RUN{
2> allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=C:WINDOWSsystem32orasbt.dll';
SEND 'NB_ORA_POLICY=ORACLE_DBMS_KTPH12_PROD_BTS_Daily, NB_ORA_SERV=b-nimhp1sys101, NB_ORA_CLIENT= b-btshp1dbs213';4> restore until time "TO_DATE('17-02-2013 03:00:00','dd-mm-yyyy hh24:mi:ss')" controlfile to 'G:oradataTLPRDdcontrol01.ctl' from autobackup;
5> }
Why it is not restring from Tape and Restoring from DISK?
Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?
Jan 28, 2011I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...
brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap
The backup goes thru but i get this erro on the end...
BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28
[code]...
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
[code]...
Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman
[code]...
I have check on the system .. There is not file like that but thwre on on the db i,e
eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1
RMAN :: Fetch Result Of Backup Into Log File After Windows Scheduler Runs Backup
Jan 8, 2013My Rman log location is d:kp man.log, how can i fetch the result of backup into this log file after windows scheduler runs backup..
View 6 Replies View RelatedBackup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?
May 3, 2011I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.
D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba
[code]....
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"
[code]....
* on my DB server I am login using my administrator account, on my PC I dont have admin account.
* I have checked remote execution using local user as well as admin user.
* I have checked the permission and my local ID & EVERYONE has all permission in that folder.
Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?
May 30, 2012How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies View RelatedRestore Backup Without Control File
Sep 11, 2011I have a problem with my control file [URL].........
What I did, I have a duplicate of the database with the invalid control file, let's call it DUMDB. I am using my control file and no recovery-catalog-db.
I recreated the control file. Now everything is working fine, new backups can be taken, restores can be made. I just need to restore a backup tagged with "LASTDEV". The control file for this backup is the invalid one. So I need a restore WITHOUT restoring the control file.
I did:
CODERMAN> catalog backuppiece '/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp';
cataloged backup piece
backup piece handle=/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp RECID=1 STAMP=761604017
CODERMAN> list backup;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 2.77G DISK 00:00:00 26-AUG-11
BP Key: 1 Status: AVAILABLE Compressed: YES Tag: LASTDEV
Piece Name: /u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp
List of Datafiles in backup set 1
===========================
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 63166185 26-AUG-11 /u02/oradata/dumdb/system01.dbf
2 Full 63166185 26-AUG-11 /u02/oradata/dumdb/sysaux01.dbf
3 Full 63166185 26-AUG-11 /u02/oradata/dumdb/undotbs01.dbf
5 Full 63166185 26-AUG-11 /u02/oradata/dumdb/stdtbs01.dbf
6 Full 63166185 26-AUG-11 /u02/oradata/dumdb/users.dbf
CODERMAN> crosscheck backupset 1;
using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u03/flash_recovery_area/DUMDB/backupset/o1_mf_nnndf_LASTDEV_75fmkllw_.bkp RECID=1 STAMP=761603187
Crosschecked 1 objects
CODERMAN> RESTORE DATABASE FROM TAG='LASTDEV';
Starting restore at 11-SEP-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/11/2011 20:32:25
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
This is exactly the same message if you do "RESTORE DATABASE FROM TAG='NONEXISTENTDUMMYTAGXXXX'"
Why can the data files not be found even if they are listed in the backup?
I am on 11.2.0.2.0 on Linux64.
Recovery Manager (RMAN) :: Filename For Datafile Is Missing In Control File
Jun 15, 2012DB:11.2.0.2.0
Oracle Apps:12.1.3
O/S:AIX 6.1 64 bits
RMAN backup throws the error:
RMAN-06169: could not read file header for datafile 40 error reason 1
RMAN-06169: could not read file header for datafile 41 error reason 1
RMAN-06169: could not read file header for datafile 40 error reason 1
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/14/2012 07:54:43
[code]...
Could we skip the backup of the above missing files using RMAN -> backup database skip inaccessible;On further research, this would compromise tablespace SYSAUX recoverability...Questions:
1) What caused the above missing files to get created?
2) What is recommended: Recover the datafiles?
Restore Damage Control File From Hot Backup
Jun 6, 2012I did a hot back up like this :
--check that it is in archivelog mode
SQL> archive log list
-- the data files that will need to be backup by OS command
SQL> select sum(bytes) from dba_data_files;
SQL> select name from v$datafile;
-- note archivelog sequence before starting the hot backup (need to back the archivelog generated during the backup)
SQL> select thread#, max (sequence#) from v$log group by thread# order by thread#;
-- begin the backup
SQL> alter database begin backup;
-- use OS command to copy the datafiles
-- remember to end the backup mode
SQL> alter database end backup;
-- archive the current online redo log files
SQL> alter system archive log current;
-- REMEBER to note the MAXIMM online-redo sequence number
select thread#, max (sequence#)from v$log group by thread# order by thread#;
-- backup the control files
SQL> alter database backup controlfile to '/oradump/hbackup/O11R2/controlbk.ctl' reuse;
-- backup any archive-redo logd generated during the backup
-- select from the v$archived_log mode
-- anything thing that appear under this view is safe to backup as long you don't backup the current archive log file that is being written to.simulated a scenario, if 1 of my multiplex control is damage due to media failure ( i just delete it, seem like i got to shutdown first before i can delete it, using window bases oracle, not too sure linux allow you to delete the control file like this)
To what i understand one can restore a missing control file if you have multiplex it. so I did this :
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
-- while it is being down, i use OS command to copy a good copy of the control file to the missing controlfile location + name.
-- startup
Total System Global Area 535662592 bytes
Fixed Size 1384760 bytes
Variable Size 243273416 bytes
Database Buffers 285212672 bytes
Redo Buffers 5791744 bytes
ORA-00214: control file 'C:ORACLEXEAPPORACLEORADATAXERENAME_CONTROL01.DBF' version 9539
inconsistent with file 'C:ORACLEXEAPPORACLEORADATAXERENAME_CONTROL.DBF' version 9533I google abit and it mention ,
[URL]........
>
You have tried to move one or more copies of control file at the different location when Oracle database was up and running.
You have tried to restore from database backup but your backup has not taken properly. It may taken when database is up and running.
Your database or system got corrupt/damaged during updation was in process.
>
is the error i got because of 1 of the reason above.
Backup & Recovery :: Corrupt Control File?
Dec 2, 2011I've recently moved jobs and am doing a lot of the normal things getting familiar with my new company's databases.I was checking through our production backup logs and came across something that looks a little funny. From the last two days backups, I see:
select completion_time, marked_corrupt, media_corrupt, logically_corrupt
from v$backup_datafile
where controlfile_type = 'B'
order by completion_time desc
COMPLETION_TIME MARKED_CORRUPT MEDIA_CORRUPT LOGICALLY_CORRUPT
01/12/2011 11:27:252011 1201 2
01/12/2011 11:26:180 0 0
01/12/2011 11:25:242011 1201 1
01/12/2011 11:15:562011 1201 0
01/12/2011 01:40:100 0 0
30/11/2011 11:23:482011 1130 2
30/11/2011 11:22:440 0 0
30/11/2011 11:21:562011 1130 1
30/11/2011 11:13:002011 1130 0
30/11/2011 01:41:010 0 0
The 01:40 record will come from our nightly command:
BACKUP INCREMENTAL LEVEL=0 FILESPERSET=20 FORMAT 'full_%d_%t_%s_%p'
DATABASE INCLUDE CURRENT CONTROLFILE
The 11AM records will come from the command:
BACKUP INCREMENTAL LEVEL=0 FORMAT 'ctl_%t_%s_%p' CURRENT CONTROLFILE;
(I know backups shouldn't still be running at 11am and we don't need level 0 backups every night, that's a seperate issue I'll be addressing! ) I see there's been a similar entry here in v$backup_datafile for all backups that there's records for. The database is up and running just fine. There are no unusual errors being reported by the database in OEM or the alert log.I tried looking at both our control files (yes, should have 3 - something else I've listed to change!) with dbverify which showed no issues - though I'm not sure if this is designed to work with control files.
If so, how could I confirm whether it's an issue with a specific controlfile (I'm assuming it's not an issue with the backup to tape itself, as it's reporting the same corruption every day)?I'd obviously like to diagnose this now while the db is up and running, rather than at 4am some morning during a crash and finding out my backup control files are no good!
Backup & Recovery :: Backing Up Control File And SPFILE
Jun 26, 2012I've pasted some of the results of an RMAN backup that I ran. It says that it's backing up both the Control File and the SPFILE, but it appears that only one file is being created. Is this correct? How does this work? Are both files combined into the C-3843121877-20120619-00 file?
Starting Control File and SPFILE Autobackup at 19-JUN-12
piece handle=C:ORACLEPRODUCT10.2.0DATABASEC-3843121877-20120619-00 comment=NONE
Finished Control File and SPFILE Autobackup at 19-JUN-12
Also, regarding the below configuration of RMAN - I can change this directory to whatever I want, correct? In other words, is it just the directory where I am putting the backup?
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:ORACLEPRODUCT10.2.0DATABASESNCFPLDG.ORA'; # default
Backup & Recovery :: Restoring Spfile And Control File To New Location?
Aug 3, 2011Im trying to restore my spfile and (later controlfile) to a new location:
RMAN> connect catalog rman11cv/pwd@metarep
Connected...
RMAN> connect target
ansluten till msldatabasen: DATABASE (DBID=510270843)
RMAN> run
2> {
3> allocate channel ch1 type 'sbt_tape'
4> PARMS="BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"
5> TRACE 0;
6> Restore spfile to pfile 'y:
estorepfile.ora';
7> }
tilldelad kanal: ch1
kanal ch1: sid=537 devtype=SBT_TAPE
kanal ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)
Starting restore at 2011-08-03
frigjord kanal: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: restore-command failed at 08/03/2011 11:39:26
ORA-27191: sbtinfo2 returned an error
The spfile and control file exists.
RMAN>list backup of spfile
BS-nyckel Typ N Storlek Enhetstyp Tidsσtgσng Slutf÷randetid
------- ---- -- ---------- ----------- ------------ --------------
736698 Full 256.00K SBT_TAPE 00:00:04 2011-08-02
BP-nyckel: 736705 Status: AVAILABLE Komprimerad: NO Tagg: TAG2011080
2T181240
Handtag: dkmj0i8p_1_1 Media: V_73870
SPFILE har inkluderats: Σndringstid: 2011-08-02
Backup & Recovery :: Restore Database Using Control File Until Cancel
May 17, 2012In order for the following command to work:
> recover database using backup control file until cancel;
what command must precede it, is it:
> alter database backup control file to trace;