If I am using the following RMAN script for hot backup daily, will it be able to recover my whole database?
I will crosscheck obsolete backup and delete them weekly... Is there a more automated way of controlling the old backups or archived logs?
connect target /
set snapshot controlfile name to '/backup/orcl_snapshot.ctl';
allocate channel ch1 type disk;
sql 'alter system archive log current';
backup format '/backup/orcl/%d_t%t_s%s_p%p'
database plus archivelog;
release channel ch1;
allocate channel ch1 type
disk format '/Backup/orcl/%d_ARCH_%u_%s_%p';
until time 'Sysdate-2' all
release channel ch1;
Will keep only two days worth of archivelogs and delete the rest of archivelogs after backing them up.If the backup is not sucessfull delete will not happen.
I will do the database backup first without the line "plus archivelog" right? I tried to do the archivelogs backup after the database backup as shown in Hrishy's posting.
I did "alter system switch logfile" before the archivelogs backup, however I am still encountering the same errors... Any help please?
RMAN-20242: specification does not match any archive log in the recovery catalog
If we ask rman to backup archivelogs that are more than 2days old and there are none, thats not an error. so no need to worry about it.
In this case, if I set the backup archivelogs as a daily backup cronjob then it will always produce this error 'coz there are no 2 days worth of archivelogs to backup? It will only starts to backup and delete the archivelogs when there are 2 days worth of archivelogs? Am I right?
If I have dropped a tablespace and want to recover from RMAN, is this possible?
Errors would be produced only for about two days..not after that as 2 days worth of archive logs would remain on disk.so you wont get this error everyday.
You need to do point in time recovery if you want to get back a dropped table
space from RMAN .read up the oracle docs on RMAN on how to do this.
Thanks Hrishy for all your replies! I will go check out the manuals
You also need to validate your rman backups.
And also you need to restore your database to some other place (Duplicate)
to confirm the strategy with various timings, and to understand the concepts.
I have been reading the TSPITR manual. There is one catch as shown in the list of restrictions below :
When performing RMAN TSPITR, you cannot do the following:
# Recover dropped tablespaces.
# Recover a tablespace that has been dropped and re-created with the same name.
In this case, if i have accidently dropped a tablespace, there is no way to recover it?
You are talking two different concepts.
1)TPSIPTR thats for a different purpose all together.
In your question you had asked can i recover a
dropped tablespace the answer is definately
a yes and here is
this is from the documentation.
To recover the database until a specified time, SCN,
or log sequence number:
After connecting to the target database and, optionally, the recovery catalog database, ensure that the database is mounted.
If the database is open, shut it down and then mount it:
Determine the time, SCN, or log sequence that should end recovery.
For example, if you discover that a user accidentally
dropped a tablespace at 9:02 a.m.,
then you can recover to 9 a.m.--just before the drop occurred.
You will lose all changes to the database made after that time.
You can also examine the alert.log to find the SCN of an event
and recover to a prior SCN. Alternatively, you can determine
the log sequence number that contains the recovery
termination SCN, and then recover through that log.
For example, query V$LOG_HISTORY to view the logs that
you have archived.
RECID STAMP THREAD# SEQUENCE# FIRST_CHAN FIRST_TIM NEXT_CHANG
---------- ---------- ---------- ---------- ---------- --------- ----------
1 344890611 1 1 20037 24-SEP-01 20043
2 344890615 1 2 20043 24-SEP-01 20045
3 344890618 1 3 20045 24-SEP-01 20046
Perform the following operations within a RUN command:
Set the end recovery time, SCN, or log sequence. If specifying a time,
then use the date format specified in the NLS_LANG and
NLS_DATE_FORMAT environment variables.
If automatic channels are not configured, then manually
allocate one or more channels. Restore and recover the database.
The following example performs an incomplete recovery
until November 15 at 9 a.m.
SET UNTIL TIME 'Nov 15 2001 09:00:00';
# SET UNTIL SCN 1000; # alternatively, you can specify SCN
# SET UNTIL SEQUENCE 9923; # alternatively, you can specify log sequence number
If recovery was successful, then open the database
and reset the online logs:
ALTER DATABASE OPEN RESETLOGS;
TPSIPTR is when you want to recover only one
tablespace to a different point in time
you would probably want to use TPSIPTR when
you want to recover a accidentally dropped table.
Hope things clear up a bit :-)
Last edited by hrishy; 07-05-2005 at 11:45 PM.
Click Here to Expand Forum to Full Width