Is it right?

Code: [Select all] [Show/ hide]

00 02 *** /export.sh

How to set it every week?

Could you solve this it?
I am very new on linux.

I have to run the script every 02 am or every week.

I thought "expdp" is full backup of database.

Should I use 'rman' to do backup full db on everyday?

Quote:

I thought "expdp" is full backup of database.

No it is a data and schema backup not a database level backup.


Quote:

Should I use 'rman' to do backup full db on everyday?

Yes, no, it depends on your restore and recover requirements but it is sure you should use RMAN to backup.
First read Database Backup and Recovery User's Guide, chapter 1 Introduction to Backup and Recovery.
First of all, are you in ARCHIVELOG mode?

...
First read Database Backup and Recovery User's Guide, chapter 1 Introduction to Backup and Recovery.
...

Am I right?

Thank you bro. I found instruction of "Making an Archival Backup" and "Making a Temporary Archival Backup". Which I need to be used future?

He certainly needs to first read the link I provided and repeated.

solution wrote on Tue, 17 November 2020 19:56

Thank you bro. I found instruction of "Making an Archival Backup" and "Making a Temporary Archival Backup". Which I need to be used future?

"archival" backups are somewhat 'special purpose'. If you've never seen rman, and don't know which 'archival' you need, then I'd suggest you don't need either. You just need to set up a normal series of level 0 and level 1 incremental backups, along with backups of your archive logs. NOrmal 'textbook' practice is to take a level 0 backup once a week and a level 1 the other six days. Set recovery period to 7 days. I could spell it out in more detail, but you first need to go back to the cited references and try yourself. You learn nothing if I just give you a script and say "here, use this, it works".

RUN {
   RECOVER COPY OF DATABASE WITH TAG 'incr_update' 
       UNTIL TIME 'SYSDATE - 7';
   BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update'
       DATABASE;
   }RUN {
   RECOVER COPY OF DATABASE WITH TAG 'incr_update' 
       UNTIL TIME 'SYSDATE - 7';
   BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update'
       DATABASE;
   }

...
Yes, no, it depends on your restore and recover requirements but it is sure you should use RMAN to backup.
First read Database Backup and Recovery User's Guide, chapter 1 Introduction to Backup and Recovery.
...

Or is it to provide a means of recovering the database it when it goes belly-up at 2:00 AM?

Quote:

Or is it to provide a means of recovering the database it when it goes belly-up at 2:00 AM?

A clue: RMAN means Recovery MANager.

The 5th parameter is day of the week with 0 = Sunday and 5 = Friday.

HTH
-g

SHOULD you use that script. Probably not. It appears you are ignoring the link that Michael has posted multiple times. Then you jump into the deep end of some rather special purpose uses of rman.
.

I found no luck until now.

@gazzag
Quote:

The 5th parameter is day of the week with 0 = Sunday and 5 = Friday.

HTH
-g

Can you write the full script of it?

EdStevens wrote on Mon, 30 November 2020 09:06

SHOULD you use that script. Probably not. It appears you are ignoring the link that Michael has posted multiple times. Then you jump into the deep end of some rather special purpose uses of rman.
.

Please provide me right section I need.